Using detail table for the summary Universe

[rg8942]

Hi Guys,
I am new to BO.
i have a detail table in DW(oracle),and planning to create a 25 months summary universe using this table.there are no fact tables for this detail table at this time and since the data is not too huge planning to produce couple of reports from this summary universe.
please note that all the data i want to see in the report is available in this single detail table,my only issue is to convert this into summary table.
my question is how can i convert this detail table to summary table,i have some date fields and also the table is partitioned on load date which one will be a better option.
and also going for hierarchies will be a good idea.
if my questons is not clear i can explain in detail.
any replies from you is greatly appreciated.

Thanks

 

[blom0344]

Hello rg8942 ,

It all depends on what you mean by 'summary' table and the size of the detailtable you are working on.
I presume that with summary you mean an aggregate table. There really is no need for this if the Universe you are planning consists of one big detail table. With proper indexes you can get good performance and there is no performance drag through joins. The actual aggregating step will be done through defining aggregating objects like
sum(sales). You can then choose a set of dimensions and the generated SQL from query panel will automatically give you an aggregated result set. Be aware that when you start using aggregates you actually lose functionality , cause you can't get to a more detailed level from an aggregate.
Only define and use aggregates as new tables (sources) if you run into performance issues which cannot be resolved in the database itself.... T. Blom
Information analyst
tbl@shimano-eu.com