Tuesday, October 18, 2011

[nQSError: 14026] Unable to navigate requested expression

Today I came across this error in analytics

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14026] Unable to navigate requested expression: Dim - GL Balance Details.Accounted Currency Code. Please fix the metadata consistency warnings. (HY000)
To fix this error, I set the content tab for the fact table, in fact here Dim - GL Balance Details is a Degenerated Dimension (because LTS is the Fact table),Here the Physical Join existing as
"Dim - GL Balance Details"."Accounted Currency Code" = "Fact - Fins - GL Balance"."Debit Credit Indicator”
Dim - GL Balance Details has the LTS- Fact_W_GL_BALANCE_F
Fact - Fins - GL Balance has the LTS- Fact_W_GL_BALANCE_F
and Fact_W_GL_BALANCE_A
1.So Created a Dimensional Hierarchy Table - GL Balance Details with Total and Detail levels


2.Add the GL Balance Details Detail level to the Fact - Fins - GL Balance LTS(i.e Fact_W_GL_BALANCE_F and Fact_W_GL_BALANCE_A ) in the Content tab


Assign the GL Balance Details Total level to The Aggregate LTS Fact_W_GL_BALANCE_A

No comments:

Post a Comment