OBIEE-Presentation Variable in SQL expression in a Column Filter
838923Feb 11 2011 — edited Feb 14 2011Hi,
I have the following:
(1) A dashboard prompt having Month names like eg. October,July etc
(2) I have declared a Presentation Variable by name @{Month}
(3) A report is there where i have a column called 'Scenario' which has values like 'Actual','Budget','LE_Jul','LE_Oct' etc
(4) In 'Scenario' column , i have given in the column filter-->SQL Expression as below:
('LE_'||SUBSTRING(CAST('@{month}{July}'AS CHAR(40))FROM 3))
My end result should be like whatever month name(ex. July) is selected in the Dashboard Prompt, my scenario should be equal to 'LE_Jul'.
I am getting Error like :
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: 37000 code: 8180 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.. [nQSError: 16001] ODBC error state: S0002 code: 208 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DIM_SCENARIO'.. [nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)
Pls give ur inputs if anyone has faced such an issue.
Thanks.