Cross tab Column hiding and conditionally render chart x-axis label tooltip disp

[xyz]

Hi All,

We are using Cognos 10, data source oracle and using relational model. We have a requirement to show different period (Month, Week and Day) reports. For this purpose we have created three different crosstab reports embedded with chart report in rows.

For 'Month' selection in the prompt page, we have a crosstab report, where we are displaying Month dimension in the column, in rows line chart and few measure. Similarly for 'Week' selection in the prompt page, we have a crosstab report, where we are displaying Week dimension in the column, in rows lines chart and few measure and for 'Day' selection in the prompt page, we have a crosstab report, where we are displaying Day dimension in the column, in rows lines chart and few measure. So this is the earlier design. Where we have three different set of crosstab which gets rendered based on the time selection.

We wanted to change the design of the crosstab to make it a single report for maintenance and enhancement perspective for any future changes, but the problem here is, if I use the case statement like below both in the chart and cross tab columns. In the crosstab columns I am loosing the functionality of drill up and drill down, for chart I am having difficulty to display the Axis Label like Month or Week or whatever is selected in the tool tip, whenever we hover over the line chart points, as we are using the single data item like below, whose name is Period. Can we show custom tooltip of Month, Week or Day, when the time prompt is selected in the prompt page?

Case
When (?Time?  = 'Months') then ([Month])
When (?Time?  = 'Weeks') then ([Week])
When (?Time?  = 'Days') then ([Day])
End

So, only option for cross tab columns is I have dragged and dropped the Month level, Week level and Day level in crosstab columns and hiding and un-hiding the display based on the time selection, here the performance hit happened as we don't have option of setting the render variable option, we can only use style variable here in crosstab rows. For chart above case statement is working fine, but the problem is display name should change on the tooltip based on the time selection from the prompt page, which is not happening, do we have any option to achieve the same here.

Can you all please let me know, your suggestions/guidance for the same.

Thanks & Regards,
XYZ