HeatMaps and data discrete value slider

[cognos05]

Hi All,

I have a heat Map with X -dimension as product and Y - Dimensions as Distributors and Measure as Revenue.

I wanted to have a slider which would show the changes in heatmap based on the time line..

Data for discrete slider is Children(currentYTD) which will give July,Aug 2014.

And I will add the same data item in Heat mao as a extra categories to be filtered.

The issue is by default both july and aug 2014 data is shown in heat map when running first,
but the slider below the heat map has jul 2014 selected by default. but when I change the value to Aug 2014 and July 2014 it works properly.

How to handle this issue.

Because the first time i run it gives a misleading result .

Thanks,
Nithya

[MFGF]

Hi All,

I have a heat Map with X -dimension as product and Y - Dimensions as Distributors and Measure as Revenue.

I wanted to have a slider which would show the changes in heatmap based on the time line..

Data for discrete slider is Children(currentYTD) which will give July,Aug 2014.

And I will add the same data item in Heat mao as a extra categories to be filtered.

The issue is by default both july and aug 2014 data is shown in heat map when running first,
but the slider below the heat map has jul 2014 selected by default. but when I change the value to Aug 2014 and July 2014 it works properly.

How to handle this issue.

Because the first time i run it gives a misleading result .

Thanks,
Nithya

Your Data Discrete Value Slider is setting an active report variable. You simply need to define a default value for this variable of Jul 2014.

Cheers!

MF.

[cognos05]

Thanks MFGF!!
I Was able to set a default value and it worked.

So my data item is currentYTD and I have used children(currentYTD) as my data item to the discrete data slider.

It showed me the values applicable  foe chidren(currentYTD) like Jul 2014, Aug 2014 and etc.. I chose one value and the heat map was generated based on that value.

This children(currentYTD) might change every year..is there a way to say the default value to be the the first member of children(currentYTD).

Thanks,
Nithya

[MFGF]

Thanks MFGF!!
I Was able to set a default value and it worked.

So my data item is currentYTD and I have used children(currentYTD) as my data item to the discrete data slider.

It showed me the values applicable  foe chidren(currentYTD) like Jul 2014, Aug 2014 and etc.. I chose one value and the heat map was generated based on that value.

This children(currentYTD) might change every year..is there a way to say the default value to be the the first member of children(currentYTD).

Thanks,
Nithya

Nope - not as things stand. Default values for AR variables are defined in the report as specific items.

An alternative would be to use a control that allows multiple simultaneous selections, such as a Data Toggle Button Bar, and don't set a default for the variable. Then you would have an initial view with all the months selected.

Cheers!

MF.