3 Replies Latest reply on Nov 20, 2012 2:05 PM by 01Bhagya Chandran

# No fact table exists at the requested level of detail

Hi all,

I am working with 5 Fact and 6 Dimension tables. I have also created a new Logical fact table XXX for Measures and joined XXX with all dimensions. I have also given detail level of dimensions in content tab of Fact LTS.

while generating report, When i place a measure from New fact table XXX it show an error as

[nQSError: 14025] No fact table exists at the requested level of detail

Kindly guide me.

Thanks and Regards
Hari
• ###### 1. Re: No fact table exists at the requested level of detail
how many dims u r pulling in the request .u can check all the tables which u r including in request has direct join wiht fact which u r adding in the request
or u can check the server is recognisng u r fact as fact (i.e. the table is indicated by# in BMM)
I think it will help u......
• ###### 2. Re: No fact table exists at the requested level of detail

D1,D2,D3,D4,D5,D6 are Dimension tables.
F1,F2,F3,F4,F5 are Fact Tables.
XXX is newly created Fact table.

F1 is joined with D1,D3,D4,D5,D6

F2 is joined with D1,D2,D3,D4,D5

XXX is joined with D1,D2,D3,D4,D5,D6

When i throw the request from D5,D2,F1 i am getting the result.

But when i throw the request from D5,D2,F1,XXX it shows the error as

[nQSError: 14025] No fact table exists at the requested level of detail:
• ###### 3. Re: No fact table exists at the requested level of detail
don't use dimension caloumns from fact table
if u want to use dimension caloumns from fact table
1.create the new logical table in BMM
2.pull all non fact caloumn to this newly create table
3.join this logical table wiht the actual fact (i.e. from where u taken these columns)
i think then it will work