date column issue.

User_DBCL0

Hi ,

I have created a logical column by concatinating Year, month, week  from time period and date value from fact(since we want the dates based on the data availability).

After deploying the rpd the column is working fine when we full this date column along with a measure from fact only.

But I want to use the date column in prompt. But the date column is not working independently.

gettting below error:

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

For this tried creating a implicit fact column and added it the subject area also. Still getting the problem.

Can you please suggest what could be the problem.

Thanks,

SwapnaPrerana

I think you should duplicate the fact. Remove all the measure columns in the duplicated (Now this will be treated as Dimension in BMM Layer). Keep only the dimensional columns like the date logical column which you created etc. In the actual fact, keep only the measure columns. Join the Fact and the duplicated fact. And then drag the same into the Presentation Layer. Also make sure, you have joins with the other tables (which you use with date column) and Duplicated fact for Date.

User_DBCL0

HI Swapna,

Thanx for your response. I have followed the steps. But is not working. giving the same error.

Thanks,