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

Using a member set as macro prompt default selection?

Started by Varapaavi, 15 Jul 2016 06:00:06 AM

Previous topic - Next topic

Varapaavi

Hi!

Is it possible to use a data item with set() function to determine the default selection of a macro prompt in case user chooses none of the options? I'm doing a report about a specific group of customers (with no logic unfortunately). I'm trying to make a prompt on the report page so user could only look the figures of one of those customers, but I can't figure how to make the default selection for the prompt something else than the default member of the hierarchy.. I have a data item in another query that lists the wanted customers and using it as a slicer I pull the list of customers for the prompt to use. However I cant do the same in the query for the report page, because I have to have the prompt as slicer and it is from same dimension. Now the prompt works OK if any or all of the options are chosen, but if nothing is chosen it will show data for all of the customers in database.

Data is a powercube and I'm running cognos 10.2.