passing presentation variable - date field error

3409791

Hi All,

could anyone please provide some suggestion - I have a field in the RPD which is based on the to_date and it is to get the last day of the month

1)OPV Field - LAST_DAY(TO_DATE(TO_CHAR(TO_DATE(A.REC_CALNDR_PRD,'YYYYMMDD'),'MM/DD/YYYY'),'MM/DD/YYYY')) AS MONTH_ENDING

2). From the Answers it looks like below without any format in the column properties data format

3). For testing I create the prompt in answers with a presentation variable - and I choose choice list - so the values in it looks like

4). when I specify the filter using presentation variable - Month Ending is equal to / is in  @{vtest} - This is working when I open the answers but when I look at the results it is giving an error "date value was expected"

when we look at the results in answers it should not give me an error - right? it should specify the message or custom message like no results etc

I think I am missing something here - thanks a lot for yur time

Rj

Pedro F

What do you mean by exactly by this: "This is working when I open the answers but when I look at the results it is giving an error "date value was expected"" ?

It's normal that you can only see result for your analysis when you have it in a dashboard with the dashboard prompt that sets your presentation variable @{vtest}. If you want to see results inside your analysis, you need to set up a default variable for your variable, something like "Month Ending is equal to / is in @{vtest}{01/31/2017}.

Is that your issue or it doesn't work at all?

3409791

when I open the answers - that is when I click on open and when I select a value it is ok - but within the answers when I click on "results" tab it is giving me an error

when I use a presentation variable it will generally say no data returned something like that - but not a error message - right?

thanks for your time, It's been a while I used answers - really appreciate your time

Rj

Pedro F

No, the error you're getting it's normal. The filter is expecting to receive a date value and instead is getting the value 'vTest'. Like I said, in the screenshot that you put there where you set the filter, fill in the box for (default) (just below the one where you put the variable name) and the variable will assume that value as the default one and won't produce the error you see now.

Bose Pandian

Hi,

In Answer, if you want to test the result, then just update the default column with any date value and try. It will not give any error.

Khalid Ibrahim

You can also default in the current date or create a repository variable that you can then default to in your prompt.

Thomas Dodds

In addition to your other issues ... you are burdening the OPV (which is not a performance approach in itself) ...

1)OPV Field - LAST_DAY(TO_DATE(TO_CHAR(TO_DATE(A.REC_CALNDR_PRD,'YYYYMMDD'),'MM/DD/YYYY'),'MM/DD/YYYY')) AS MONTH_ENDING

You don't need half the functions...

LAST_DAY(TO_DATE(A.REC_CALNDR_PRD,'YYYYMMDD')) AS MONTH_ENDING