Oracle Communities

Oracle Analytics and AI

Child Item

Possible to catch prompt variable in a report like a presentation variable in the dashboard, but jus

Robert Angel

Hi,

Is it possible to reference the prompts created purely in answers on the prompts tab?

i.e.

Date Column, filtered with IsPrompted

Prompt defined in Prompt Tab in answers for Date between

Is it possible to display the value of the From and To dates passed to the date in a similar fashion to which you can reference presentation variables in headings etc? @{MyVariable}{DefaultValue}

Note my data is displayed at detail level, so min max will not do it.

thanks,

Robert.

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Hi Robert,

Don't think it's possible (without setting a variable).

The embedded prompt works directly on the same columns (replacing the hardcoded filter or the "is prompt"), but isn't defined as variable itself (automatically).

You have the "filter view" which will do that (but probably also show other things you would prefer to hide ...)

[Deleted User]

Have you tried it?

Because it's just like dashboad prompts. The prompt sets a variable. The variable hence is instantiated with a value. You display it. Period.

Just did it btw and works perfectly fine.

Robert Angel

Not the news I wanted but thanks for the answer....

Robert Angel

My mistake!

Thanks,

Robert.

Gianni Ceresa

I maybe missed a bit reading ...

Of course if in the prompt you define to set a variable it works just like a dashboard prompt as Christian said.

If you don't define a variable there isn't a syntax to reference the values ( that's what my 1st answer was about).

[Deleted User]

Man reading your initial post I had a "WTH" second Like "what tid they mess up this time"