3 Replies Latest reply: Dec 26, 2012 2:37 PM by Srini VEERAVALLI RSS

    Aggregate layer mapping

    UOOLK
      All,

      I need help ,

      1 have an aggregate table with columns (TotalUnits,ManUnits) with week grain and derived table (TotalUnits,ManUnits) with day grain
      I am mapping to fact table having columns
      TotalUnits : mapped to LTS derived and aggregate columns directly
      AutoUnits : Calculation (TotalUnits-ManUnits) at present using only derived table but in dilema if we could add AGG
      ManUnits :mapped to LTS derived and aggregate columns directly

      Q1 :- how do i map the aggregate table to Autounits- Calculation (TotalUnits-ManUnits) ?
      --adding the calc in the LTS aggregate and setting the content level to week !!!!

      Q2 when i map the columns directly for Total and Man for both aggregate and derived i get aggregate as source in the Derived From box in the Logical column properties
      is this normal to see the aggregate source as the primary source .
        • 1. Re: Aggregate layer mapping
          Srini VEERAVALLI
          Make sure you got 2 LTS for logica fact table
          make sure you have both fact and aggregate table mappings for measures TotalUnits,ManUnits
          to confirm the same when you double click on any of the measure you should see mapping with fact and agg table.

          For AutoUnits: Two ways to go with:
          Create measure AutoUnits with expression as TotalUnits-ManUnits and mapping with fact and other one is with Aggtable.

          other way is just create another logical measure using existing column in logical fact

          When you use these measures with date; fact will be used for other columns agg will be used.

          Any updates on this?

          Edited by: Srini VEERAVALLI on Dec 25, 2012 8:27 AM
          • 2. Re: Aggregate layer mapping
            UOOLK
            Edited by: Srini VEERAVALLI on Dec 25, 2012 8:27 AM
            Thanks Srini
            but i havent understood your point here
            -Create measure AutoUnits with expression as TotalUnits-ManUnits and mapping with fact and other one is with Aggtable.

            other way is just create another logical measure using existing column in logical fact

            When you use these measures with date; fact will be used for other columns agg will be used.

            the simpler way to explain is i have to have one logical column which should map derived and agg source
            one source for day grain has a calculation and the aggregate has a different calculation

            or to put it simply how will you map aggregate source to an existing day grain mapped column where calculation is involved
            • 3. Re: Aggregate layer mapping
              Srini VEERAVALLI
              Logical column properties->tab Data Type->check for Show all logical sources
              here you shoul see the fact and agg tables as sources
              metric AutoUnits : Calculation (TotalUnits-ManUnits) shoul map for both sources.

              when you use this date,AutoUnits columns you see fact in the physical query
              when you use this week,AutoUnits columns you see agg fact in the physical query