Hi Cognos Gurus,
I need some help on my requirement regarding parameter display - details below.
1.) I have a prompt page with multi-select value prompt p_Quarter (prompt values are: CQ, NQ, NQ+1, NQ+2, NQ+3, NQ+4)
2.) If the user selected one value on p_Quarter (e.g NQ), the report display the following:
Quarter: NQ (value selected on p_Quarter)
Quarter Data: NQ (filter - retrieved data based on the value selected on p_Quarter)
3.) If the user selected more than one value on p_Quarter (e.g CQ, NQ), the report will display the following:
Quarter: CQ (default display)
Quarter Data: CQ, NQ (filter - retrieved data based on the values selected on p_Quarter)
4.) The "Quarter: CQ" value will be the default value if the value selected on p_Quarter is greater than 1, else if the value selected is equal to 1 then the Quarter display will be equal to the value selected on the p_Quarter.
Thanks in advance...
Sorry, it isn't clear to me what you are asking. Is this a relational or dimensional source? What do CQ and NQ refer to? What is the difference between Quarter and Quarter Data? I think an example illustrating your requirement might help you elicit better responses.
Have you reviewed THIS LINK? (http://www.cognoise.com/index.php/topic,24030.0.html)
Hi Lynn,
Sorry to confuse you...
I am using a dimensional data source..
CQ and NQ stands for Current Quarter and Next Quarter which is used in the report as filter value for value prompt p_Quarter.
Quarter value comes from the value selected by the user in the prompt. Quarter value will differ based on the filter value selected, if one value is selected in the filter then that value will be displayed in Quarter, (e.g if NQ was selected then QUARTER: NQ). If more that one value is selected, the Quarter value will be default to CQ, (e.g if CQ, NQ was selected then QUARTER: CQ)
Quarter Data are filters to be applied in the report no matter how many filter values was selected.
Example:
Prompt Page
Quarter Filter (Multi select)
_____________________
CQ
NQ
NQ+1
NQ+2
NQ+3
NQ+4
_____________________
If user selected quarter value equal to NQ, the report will pull NQ data with Parameter Display as below:
Quarter: NQ
Quarter Data: NQ
If user selected quarter values equal to CQ, NQ, NQ+1, the report will pull CQ, NQ, NQ+1 data with Parameter Display as below:
Quarter: CQ
Quarter Data: CQ, NQ, NQ+1
Logic Summary:
1 filter selected, Quarter is equal to the filter selected
2 filters selected, Quarter is default to CQ
Thanks!!!