1 Reply Latest reply on May 8, 2015 10:50 PM by Christian Berg

    No fact table exists at the requested level of detail

    user6185307

      Hi Guys,

      I see the above error many times in the forum but still did not find out how to solve it.

       

      I created a view in my database where I joined different tables and if I run it in sql is working perfectly fine.

       

      I want to expose it in BI, by creating a repository.

       

      I do not have dimensions or hirarchies but a fact table that I want to join with logical tables.

       

      When I select all the fields from the same logical table, it works, but I can not mix them up with the facts or columns of the other logical tables.

      It seems like there are some join missing?

      Any suggestions? Attached some screen shots

       

      Thanks and Regards

      G.