Hi,
i have
<li> 2 fact table
<li> 3 dimension table
and i have given the 2 fact table join with all the 3 dimension table(so all the fact table as been joined with all the dimension table). That's it and after that i didnt perform anything.
I checked for the consistency the repository doesn't throw any error.
After that in answers, if i selected one column from my one fact table and another column from my other fact table
w_budget_f.Budget_date
w_actuals_f.expenditure_type
And if i viewed answers means it is throwing error like
[nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail: [,,,[W_ACTUALS_F.EXPENDITURE_TYPE],[W_BUDGET_F.BUDGET_DATE],]. (HY000)
SQL Issued: SELECT s_0, s_1, s_2 FROM ( SELECT 0 s_0, "BISAMPLE"."W_ACTUALS_F"."EXPENDITURE_TYPE" s_1, "BISAMPLE"."W_BUDGET_F"."BUDGET_DATE" s_2 FROM "BISAMPLE" ) djm
What is wrong with it.
Whether i should not view the results by selecting the two columns from my two fact tables.
or what went wrong, it is just a simple thing that i made, then why i cannot able to view the answers for the both the columns that i have taken from both the fact table.
This error is killing me.
Kindly help me out of this issue friends,
All izz Well
GTA