This discussion is archived
1 Reply Latest reply: Feb 14, 2013 7:09 AM by Srini VEERAVALLI RSS

logical level for logical fact table sources

alex.v Newbie
Currently Being Moderated
it is clear that for fact aggregates, we should use the Content tab of the Logical Table Source dialog to assign the correct logical level to each dimension.
question is : is it mandatory to assign even for non-aggregates fact tables the logical level for each dimension (which normally should be set to the most detailed level of each dimension) ? is it any known issue if "logical levels"in content tab are not set ?

the reason I'm asking this is a strange bug I have (I'm not going to discuss it here) and then only workaround seems to be NOT setting the logical levels (on content tab) for logical fact table sources.

thank you !
  • 1. Re: logical level for logical fact table sources
    Srini VEERAVALLI Guru
    Currently Being Moderated
    If levels are not set: By default levels are considered as lowest level
    It should not matter if you set or not

    Generally we set for facts explicitly when we are using Aggregate tables.

    Your current issue might be a case by case; I would suggest to check implicit fact, any table mapped to the source to force a join etc

    Mark if helps

    Let me know how it helps

    Edited by: Srini VEERAVALLI on Feb 5, 2013 8:33 AM

    Any updates on this?+_

    Edited by: Srini VEERAVALLI on Feb 14, 2013 9:09 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points