This content has been marked as final. Show 3 replies
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......
Thanks for ur reply,
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:
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