If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to provide the source from Value prompt to Date prompt.

Started by babukatra, 09 Oct 2009 07:10:28 AM

Previous topic - Next topic

babukatra

Hello Friends,

Please help me How to resolve the fallowing issue.

Issue:

1. I needs to ctreate one value prompt which shows two Vlaues
Those are 1. Previous Week
                2. Specified week are not there in database.

I created that using Valueprompt Parameetor and added the those two Values using static choice.

But I need to create the another prompt as dateprompt with from and to options based on 1 st prompt.

i.e select "Previous Week" option defaults data display to last week and disable the from and to date fields; select "Specified Period" option enables From and To date fields.


Reqirement: I need to show Top 5 products sale value based on selcted date.

In my sales table I had the salesdate.
and time dimenssion table is also there.

Based on these two tables how I can design that prompt page. Please help me out any one to resolve this issue.


adoremars

Hi,

In this case you need to use render variable for the date prompt.

For eg: consider these are the static choices for a value prompt - lastweek, currentweek, MTD,Customselection. And also create the same choices in the condition explorer tab as a string.

Create another date prompt using a date field. Select the created date prompt and go to the property area and in render variable drop down select the created string name in cond explorer. This will enable the date prompt when the user slect customselection in value prompt.