This discussion is archived
5 Replies Latest reply: Jan 20, 2013 9:41 AM by kmannaraj RSS

No fact table at the requested level error.

kmannaraj Newbie
Currently Being Moderated
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

Legend

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