5 Replies Latest reply: Jan 20, 2013 11:41 AM by Maraprik RSS

    No fact table at the requested level error.

    Maraprik
      I have one dimension

      Account

      Two fact tables

      Threshold and Transaction

      These tables are joined to the Account Dim using Account Number.

      Now when I create an analysis using Account Numbers from all three tables, it says no fact table at the requested level. If I include any other fact from both the fact tables, it populates null. It works right when I create an analysis from one dimension and either of the fact tables.


      Why do we get this error and how else should it be modeled.

      Edited by: 979130 on Dec 29, 2012 12:52 AM