Skip to Content
0

Build universe on CRM based tables

Nov 01, 2016 at 05:52 PM

30

avatar image

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..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Nov 01, 2016 at 06:30 PM
0

You can start with derived tables in DF layer..

Also share your requirement in more details.

Share
10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Nov 01, 2016 at 06:35 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

0