Thanks for your reply. I have used both CAST and Evaluate functions as per your suggestion but faced the below issues: With Evaluate function got the same error as yesterday: Evaluate('TO_CHAR(%1 ,%2)' AS CHAR ,TIMESTAMPADD( SQL_TSI_DAY , DAY_OF_QUARTER( (@{pv_start_date}{date '2016-01-01'})) * -(1) + 1,…

Thank you for your response. I have used Evaluate Function but its giving me the below error: Error Codes: OPR4ONWY: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…

Thanks for your response. Its report on a dashboard page. Here is my scenario: Dashboard prompt with column and date presentation variable prompts. Report 1 is on Dashboard page.Report1 has Report2 as Drill down report. Column and presentation variable values are passed to Report1 but for Report2 presentation variable…

Thanks for your response. I am talking about OBIEE report(Analysis) with drill down report on a dashboard not a BI Publisher object. Thanks again for the help!!

Thanks for your response. I was able to fix the issue by selecting the hierarchy level instead of the column as per your suggestion. Thank you once again for your help.

Thank you for your response. If I dont use CAST on measure then I am getting invalid expression error. I am using the below formuula: TODATE("Core"."Fact"."Number of Samples", "Core"."Date"."Fiscal Year") Thanks in advance for your help!!

Thank you for your response. Number of Samples has Varchar as datatype as UNIQUE_COLUMN has Varchar as datatype in table. Do I need to remove cast on Number of Samples to make it work. Thanks in advance for your help!!

Thanks for your response. As per your suggestion I have setup the fiscal calendar as alternative hierarchy for Date Dimension and created a new logical column with the below formula but its giving me the below error: TODATE(CAST("Core"."Fact"."Number of Samples" as DOUBLE), CAST("Core"."Date"."Fiscal Year" as smallINT))…