Skip to Content

Build universe on CRM based tables

Hi guys

I have been tasked to build a universe on some of the CRM based tables.

Now to build even a simple report from these tables, there are a lot of self joins involved as the data is not in its 3rd normal form.

Do you experts have any tips to share as how do I get started building a universe where I do not have a proper relational model?

All I have is a set of queries which are used to produce some reports for the end users..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 01, 2016 at 06:30 PM

    You can start with derived tables in DF layer..

    Also share your requirement in more details.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 06:35 PM

    How about creating Custom SQL based WebI reports? I afraid Derived table based universe might not holds good for Large datasets.

    Add comment
    10|10000 characters needed characters exceeded

    • Free Hand SQL or derived table is not different in case of large data set.Both are going to be behave in same manner as both options are going to hit the database only.

      Derived table or alias is still better approach comare to freehand sql as freehand sql is required for indivdual reports requirment.