Categories
- All Categories
- 145 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Error when comparing presentation variables in filter
I have added a column to an analysis comparing presentation variables :
CASE WHEN @{p_org} = @{p_org_drill} THEN 1 ELSE 0 END
When I view the results in the analysis it's okay. However, when I view it in the dashboard page, it's resulting in an error:
| View Display Error | |
Odbc driver returned an error (SQLExecDirectW). Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "DETE". (HY000) SQL Issued: {call NQSGetQueryColumnInfo('SELECT CASE WHEN DETE = DETE THEN 1 ELSE 0 END FROM "Corp System"')} SQL Issued: SELECT CASE WHEN DETE = DETE THEN 1 ELSE 0 END FROM "Corp System" | |
In this case both presentation variables resolved to "DETE" which is correct.
The analysis did not have the error in the dashboard before adding the column.
As a test I created an analysis with nothing but that one column and no filters, and put it on a separate page on the dashboard. When I first enter the dashboard and go to that tab, it displays a result with no errors. However, after I select some values from the prompts and click "apply" and then go to that tab, it has the error.
Answers
-
CASE WHEN '@{p_org}' = '@{p_org_drill}' THEN 1 ELSE 0 END
0 -
That works. It was confusing that it works as a stand alone analysis. Why is that?
0