Hello All,
I am creating a report using Cognos 8.4 and TM1 9.5
I need to create a Drop down prompt - with the following conditions.
1. Data must be sourced from TM1 cubes.
2. The UI should be dropdown or a Radio Group button.
3. The prompt should be optional and should run initially with default selections.
To put my issue in simpler terms, I need to use Value prompts to report on Dimensional data but with a default selection.
I was able to achieve the first two conditions. I am not able to achieve the third criteria.
Any suggestions on how to achieve this? ???
Thanks,
Sag
In the Insertable Objects window, find the member you want to use as your default selection for the prompt and right-click and select Properties. From the Properties window, select and copy the MUN (Member Unique Name) of the member then close the Properties window.
Go to the properties of your prompt and open the Default Selections property - Add a default and paste in your MUN.
MF.
Thanks a ton for your help :)
Sagar