Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
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
11
Views
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!