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