This content has been marked as final. Show 3 replies
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