Skip to Content

MSSQL Connection


1) I have been provided with an SQL Query like




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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2015 at 06:35 PM

    If the tables are already in your universe and so are the objects, then you can just build a Webi query with them. A derived table is not a best practice solution.

    If the tables are not there:

    Insert the tables into your schema, join them on the keys in your join condition.

    Create the objects that you need to use in your query.

    The key to your date calculations is how your fiscal period is stored. What data type is it on SQL Server? If it is datetime then you can simply use the datepart function to create further objects within the same class as your fiscal period object.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2015 at 03:17 PM


    If you have already the SQL then easy step is to create derived table.create objects and use in the webi.


    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I am not good in the writing SQL..😭If you can write SQL and  spilt the records then you can use in the derived table.Yes you can defined the prompts in the derived table.

      If not then might be use different tables and your earlier thread i have explained with steps to combined the month and year.