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

Prompt Default Value is Getting Lost

Started by HalfBloodPrince, 06 Dec 2011 12:59:43 AM

Previous topic - Next topic

HalfBloodPrince

Hi ,
I have two charts on the report page. Each having separate prompt year data item. I have set a default value of both to 2008. At start both char shows data for year 2008 on chart i have Year from Time Dimension . But when I select a year prompt in chart 2 all year data is displayed in chart one.

CognosPaul

Dimensional or relational? How are you setting the default values? Are the parameter names different between the two prompts? Do you have two separate prompt objects? What type of prompt objects are you using? By all year do you mean it's showing all the years in the data source?

HalfBloodPrince

I have changes in existing report. Prompt queries points to Relational table while month column on chart is from  time dimension .
Yes i have set default values of all chart year to 2008.Each prompt query is different. No its show all the month from all the years if select year prompt of another chart .

CognosPaul

So you have two queries for the charts. Each query has a filter on year. Is the prompt a prompt macro (#prompt('Year1','integer','2008')#) with a default value, or a prompt alias (?Year1?)?

You have value or text box prompts on the page? Do you put the default values in those?

HalfBloodPrince

simple value prompt with [Year] =? year ?

CognosPaul

Does a prompt object for the year param appear anywhere on the page? If not, then when the page is refreshed no value will be entered into the param and the chart will run unfiltered.