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.