Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MSSQL Connection

Hi,

1) I have been provided with an SQL Query like

Select

From

Where

2) I also could able to see the above tables present in the SQL Query with an universe connection(MSSQL) based schema user.

Now, i am struck with what universe design i can approach for eg: derived table with provided sql query or to design with table and joins of the SQL Query or to write an custom sql in the report level. Pls. provide some steps for the right approach.

Thanks,

Dinya,

replied

Hi,

How much time this query taking if you are running at database?Similar you can compare the refresh time at webi level.

Amit

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question