We are using OBIEE 11.1.1.7
I keep getting the following error when trying to run a query against Dimensions only in OBIEE Answers:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14020] None of the fact tables are compatible with the query request Dim
I have the following setup in RPD.
Physical
I have 2 fact tables and three dimensions
F1 <- D1, D2
F2 <- D2, D3
BMM
I have one fact tables and three dimension tables:
F <- D1, D2, D3
I created a dimension higherarchy for each dimension table and kept the two default logical levels --Total and Detail.
The fact table has two LTS, and the levels are set up as follows:
F1: D1=Detail, D2=Detail, D3=Total
F2: D1=Total, D2=Detal, D3=Detail
F1.x is setup as implicit fact column.
Now my OBI query has only dimension columns ie. D1.x, D2.x and D3.x. I dont need any Fact. It throws the above error.
please any suggestion would be appreciated.