Hello All,
I have a scenario where I've to build an analysis using two or more Fact less fact tables and one conformed dimension. These Fact less fact tables doesn't have even single measure which can be used in the analysis. They Just have the Attributes such as Gender, DOB, Effective date and Begin date etc. I Joined the two facts with conformed dimension in the BMM and set the Logical level of facts to detail level for Dimension. Then when I'm creating analysis using one fact and Conformed dimension it's working fine but as soon as I add the column from second fact it's giving me the error.
Error Details
Error Codes:
OPR4ONWY:U9IM8TAC:OI2DL65PState: 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 Fact. Please have your System Administrator look at the log for more details on this error. (HY000)
I did search Google for for fact less fact modeling in obiee but they are all mentioning about single fact less fact. So is there any other way I can model Multiple fact less fact tables?
Thanks.