2 Replies Latest reply on Jan 23, 2013 7:44 AM by Satya Ranki Reddy

    Content tab in LTS

      Hi Experts,

      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
        • 1. Re: Content tab in LTS
          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
          • 2. Re: Content tab in LTS
            Satya Ranki Reddy

            Please refer below links. You will get better idea .