This content has been marked as final. Show 2 replies
To use a source correctly, the Oracle BI Server has to know what each source contains in terms of the business model. Therefore, you need to define aggregation content for each logical table source of a fact table. The aggregation content rule defines at what level of granularity the data is stored in this fact table. For each dimension that relates to this fact logical table, define the level of granularity, making sure that every related dimension is defined.
Good scenario is Fact table and Aggregate fact table.
If helps pls mark
Edited by: Srini VEERAVALLI on Jan 22, 2013 9:57 PM
Edited by: Srini VEERAVALLI on Jan 24, 2013 7:16 AM
Please refer below links. You will get better idea .