COGNOiSe.com - The IBM Cognos Community

Hi All,

I have two chart items i.e. C1 and C2 and two table items i.e. T1 and T2. My report has to give the user a single select drop-down which will have combinations of all the above four items. The user shall see a drop-down having 4 options which are C1-T1, C1-T2, T1-C2 and T2-C2. Thus, when user selects the option C1-T1, the C1 chart and T1 table gets displayed and similarly for the other four options. At a time ONLY one combination should be displayed.

Any help/suggestion will be highly appreciated.

Best Regards
Dev

I imagine ytou will need to code the four values as static values, and use conditional blocks to show only the desired chart based on the parameter selection.

Is this a relational or dimensional package?

MF.

Quote from: MFGF on 14 Jan 2014 02:46:36 AM
I imagine ytou will need to code the four values as static values, and use conditional blocks to show only the desired chart based on the parameter selection.

Is this a relational or dimensional package?

MF.

Hi MF,

Thanks for the prompt reply. This is a dimensional package. Also, I figured how to do it. I wanted a solution without Conditional Blocks and I think I have got it :) I will post my steps for reference. Thanks again.

Step 1) I dragged 1 value prompt into report area and named its parameter as p.Series.

Step 2) Set the static choices with the following values:
Use Value         Display Value
C1                    Chart C1
C2                    Chart C2
T1                     Table T1
T2                     Table T1
C1-T1                Chart C1 - Table T1
C1-T2                Chart C1 - Table T2
C2-T1                Chart C2 - Table T1
C2-T2                Chart C2 - Table T2

Step 3) Next I dragged a table cell below the prompt with 1 column and 4 rows.

Step 4) Insert Chart and Table items into the cells as follows: 1st Cell = Chart C1; 2nd Cell = Chart C2; 3rd Cell = Table T1; 4th Cell = Table T2.

Step 5) I created 4 Boolean variables in Conditional Explorer with following values:

1st Boolean Variable: C1
Expression: ParamValue('p.Series') Contains ('C1')

2nd Boolean Variable: C2
Expression: ParamValue('p.Series') Contains ('C2')

3rd Boolean Variable: T1
Expression: ParamValue('p.Series') Contains ('T1')


4th Boolean Variable: T2
Expression: ParamValue('p.Series') Contains ('T2')

Step 6) Go back to Page Explorer and set the Render variable property for the 4 items i.e. Select Chart item C1 and then Set the Render Variable to C1.
Select Chart item C2 and then Set the Render Variable to C2. Similarly for the remaining 2 table items.

Run the report and select the values from the dropdown to get the desired view.


*** CLOSING THE TOPIC FROM MY SIDE ***

Best Regards
Dev