What is the purpose of content tab in the logical table source(LTS) after mapping the columns in the LTS why we have to set the logical level for the dimension if we won't set what will happens.
Please let me know with good scenario for better understanding.
Edited by: RAJ.bi on Jan 22, 2013 7:57 PM
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