i want to add one Derived table in my existing universe,

[Former Member]

Hi ,

In my existing universe i wan to add one derived table,Based upon the derived table i need to change some of my objects.In this scenario  I have 2 fact tables to which i  need to join my derived table,and those 2 Fact tables are connected with one dimension table.i made connections in between 2 fact tables and derived table.i involved that join in to the fact table context.But when i create report based up on the same my query is taking to much time and because of that my database server also got hanged.it is fetching almost 40 GB data...........      please do the needful. 

[Henry_Banks]

this is a cross post . same as this entry :  http://scn.sap.com/thread/3301986

please don't cross post !

thanks,

H

[dennis_scoville4]

There are a couple of things you can do:

1. Ensure that you have indexes on the columns being joined in the two Fact tables.
2. Model a new table in your data warehouse/data mart.

Since a derived table is essentially a database view, and database views are inherently inefficient for large datasets, Option 2 would be your best choice given that your results set is 40 GB.

[TammyPowlas]

Hello,

Design Studio does not support Universes

This is in the wrong space.  I will try to move to Semantic Layer; please post these types of questions in that space.

Regards,

Tammy