If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding all items on a data radio button group

Started by cognos05, 10 Mar 2015 02:26:25 PM

Previous topic - Next topic

cognos05

Hi,

I have a region data item and it doesn't have a All member in it.
I am currently using set(East, West, North, South ) and adding this datitem to my radio button group
I would like to have one more all  member here, along with four regions. How do I set this and If I set this, how will I pass my all value to whatever control I have may be list or crosstab.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 10 Mar 2015 02:26:25 PM
Hi,

I have a region data item and it doesn't have a All member in it.
I am currently using set(East, West, North, South ) and adding this datitem to my radio button group
I would like to have one more all  member here, along with four regions. How do I set this and If I set this, how will I pass my all value to whatever control I have may be list or crosstab.

Thanks,
Nithya

You could perhaps add a button to unset the variable? Depending how the variable is used, you might then have to add a default card to each data deck, but this will obviously not be needed if you are filtering lists/visualizations etc.

MF.
Meep!

cognos05

Can you explain a bit more..
Now I have to show all four members, right now say the variable is set to a default value of East.

How should I use a button to show all and proceed . Assume I am using a crosstab below to filter.

Thanks,
Nithya

cognos05

Hi MFGF,

Can you give us a sample for adding all product option in a radio button or the steps to achieve this. I hope it would also help others who are trying to achieve the same.

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 10 Mar 2015 04:16:34 PM
Can you explain a bit more..
Now I have to show all four members, right now say the variable is set to a default value of East.

How should I use a button to show all and proceed . Assume I am using a crosstab below to filter.

Thanks,
Nithya

Drag in a button object from the toolbox and have it unset the variable. Simple :)

MF.
Meep!

cognos05

#5
Hi All,
Finally got it working.
Let me put it in steps so others can follow.
1) I would drag a data radio button group
2) I have a dimension in which I have a region level, but I would need to show only few region on my report
3) Use a data item and the expression of the item would be  set(required region members)
4) Now drop this data item in the radio button group and it should show the required regions.
5) I will have a cross tab below the radio button group and I will create a variable that will connect radio button group and my crosstab and filter it out, say vRegion is the variable.
6) I will set the default value of the variable to anyone of the regions.
7) Now I will have to bring in a button and name it as show all regions.
8) This button would select both radio button and crosstab and set this value to empty and since crosstab will have all regions, it would show all data now.


Do any one know a method to directly add this show all button as part of radio button. I think we need to do a union query,but is this possible in using cube as a source. Thanks

Thanks,
Nithya

MFGF

Quote from: nithya1224 on 12 Mar 2015 04:03:17 PM
Hi All,
Finally got it working.
Let me put it in steps so others can follow.
1) I would drag a data radio button group
2) I have a dimension in which I have a region level, but I would need to show only few region on my report
3) Use a data item and the expression of the item would be  set(required region members)
4) Now drop this data item in the radio button group and it should show the required regions.
5) I will have a cross tab below the radio button group and I will create a variable that will connect radio button group and my crosstab and filter it out, say vRegion is the variable.
6) I will set the default value of the variable to anyone of the regions.
7) Now I will have to bring in a button and name it as show all regions.
8) This button would select both radio button and crosstab and set this value to empty and since crosstab will have all regions, it would show all data now.


Do any one know a method to directly add this show all button as part of radio button. I think we need to do a union query,but is this possible in using cube as a source. Thanks

Thanks,
Nithya

The alternative, if your region dimension has an "All Regions" member, is to modify your set to be:

set([All Regions member],[all your other Region members required for the radio buttons])

This would then give you an extra radio button allowing you to select the All Regions member (ie have no region filter).

MF.
Meep!