Error when comparing presentation variables in filter

Question

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 ErrorOdbc driver returned an error (SQLExecDirectW).

Error Details

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.

user4109719 · Answer

That works.  It was confusing that it works as a stand alone analysis.  Why is that?

Sherry George · Answer

CASE WHEN '@{p_org}' = '@{p_org_drill}' THEN 1 ELSE 0 END