Oracle Analytics and AI

Parameter saying that the query results are "Integer" when they should be date, text etc.?

I am trying to create a column that is the exact same as the current date parameter, but I want it to be the day prior to current date.

Like the above example I would like for it to be the day previous.

I've tried doing a parameter that's current date - 1, however it says the result of this is an integer rather than a date. How can this be fixed?

Find more posts tagged with

Filter

Parameter

FDI

Fusion AI Data Platform

Accepted answers

fbarazan-Oracle

Create a calculated column first and then use it.

All comments

fbarazan-Oracle

Perhaps I am not clear about your question. But you can do the following:

Caroline Blanchard

So what I'd like to do is take that previous date calculation you have there and put it into a parameter, similar to the out of the box parameter 'Current Date'. The reason for this is we'd like to have a little box that shows what date they can expect their data to be updated through. For us, the daily refresh runs overnight so the data is current through yesterday.

These are the out of the box parameters. We'd like to create our own parameter 'previous date'. However, when trying to validate the parameter, it disputes the data type created. Any ideas on how we can fix this? @fbarazan-Oracle

fbarazan-Oracle

Would this work for you?

Caroline Blanchard

@fbarazan-Oracle If I choose 'Column' under available values I get a list of values pertaining to the subject areas in the report.

Also you have to have a value under initial value. Did your parameter save like that??

fbarazan-Oracle

Create a calculated column first and then use it.

Caroline Blanchard

That worked for me thank you