Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

date column issue.

Received Response
11
Views
2
Comments
User_DBCL0
User_DBCL0 Rank 4 - Community Specialist
edited Aug 13, 2024 6:12PM in Oracle Analytics Forum

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,

Answers

  • SwapnaPrerana
    SwapnaPrerana Rank 3 - Community Apprentice

    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
    User_DBCL0 Rank 4 - Community Specialist

    HI Swapna,

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

    Thanks,