1 Reply Latest reply on Feb 14, 2013 3:09 PM by SriniVEERAVALLI

    logical level for logical fact table sources

      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
          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