Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Using AsofDate variable as a Dashboard prompt — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using AsofDate variable as a Dashboard prompt

Received Response
12
Views
2
Comments
in Reporting and Analytics for HCM 2 comments

Summary:

Using AsOfDate variable as a Dashboard prompt

Content (required):

We have several OTBI reports that run using AsOfDate as the prompt variable. I would like to add these reports to a dashboard and create the dashboard prompt for the AsOfDate variable. Is this possible?

Currently, in the analysis AsOfDate is set up on the prompt tab and on the advance tab I have entered the SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}';

I want to change this to a dashboard prompt. I have created the dashboard prompt (see screen shot) and removed the prompt set in the analysis. However, since AsOfDate is a variable prompt, I am not sure how to attach it in the analysis. For any other field, I would add it as a filter stating "is prompt". Can this be done with AsOfDate and how?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!