How to create 2 prompts on same column

fabryddorf-Oracle

Hi Guys,

On OBIEE 12c I am creating a report and using same revenue column twice filtered by same dimension but with different values.

i.e Accomondation revenue= revenue using trx_code=1000

Food revenue=revenue using trx_code=5000

Instead of the values 1000 and 5000 I will use presentation variables that should be updated by column prompts with presentation variables.

Of course this is not working because i can not create two prompts on same trx_code column, though the variables will be different.

I tried to use then variable prompts using sql statement to retrieve the trx_codes, rather then column prompts. In the prompts i am getting the correct trx codes, I can see from the sql statement that the trx_codes were replaced correctly in the variable, but then on the report I return an ODBC error.

I am an end user and do not have access to RPD or so. Any idea or documentation you could share?

View Display Error Odbc driver returned an error (SQLExecDirectW).

  Error Details

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed:

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 17001.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 17012.

Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: SELECT 0 s_0, "Financial-Transaction Details"."Details"."Transaction Date" s_1, "Financial-Transaction Details"."Filters"."Property" s_2, FILTER("Financial-Transaction Details"."Transaction Amounts"."Gross Amount" USING ("Financial-Transaction Details"."Financial-Transaction Codes - Details"."Transaction Code" IN (1001))) s_3, FILTER("Financial-Transaction Details"."Transaction Amounts"."Gross Amount" USING ("Financial-Transaction Details"."Financial-Transaction Codes - Details"."Transaction Code" IN (9053))) s_4 FROM "Financial-Transaction Details" FETCH FIRST 10000001 ROWS ONLY

fabryddorf-Oracle

This is solved now. The approach was correct. It was giving an error because I have to pass the trx code value in single quotes

select ''''||"Financial-Transaction Codes - Details"."Transaction Code"||'''' from "Financial-Transaction Details" FETCH FIRST 65001 ROWS ONLY