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.
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?
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 .
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?
simple value prompt with [Year] =? year ?
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.