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.