0 Replies Latest reply on Aug 18, 2015 2:14 AM by 920424

    LTS Settings


      I have a dimensional hierarchy - level 1 (top) - level 2 - level 3 - level 4 - level 5 (lowest).  I have a fact table which contains level 3 granularity and I would like to roll up from level 3 to level 1. 

      I have physical join between fact and dimension and also logical join.

      Now my Fact LTS Content level is set at Level 3 for above dimension.  When I run the report with level 3 column and fact, the numbers are not matching with database instead its showing overblown numbers.  How do I design this in RPD?  Appreciate your inputs.