Cognos Report Studio - Value prompts and dimension aliases
Posted on 2012-04-05
I have created a report in Report Studio Professional which has a crosstab whose query is filtered by a value prompt. The data source for the report is a TM1 cube i.e. dimensional.
The value prompt and filtering works without an issue. I however want to show the dimension alias in the value prompt to give more meaning to the user. So I set the 'Display value' property of the control to the use the alias. This also works.
My problem is that whenever you use an alias as the 'Display value' (with the element as the 'Use value') the automatically included 'All members' entry in the list changes to a MUN that resolves to 'All members'. This is of course very long and quadruples the width of the prompt and looks very ugly compared to all the other entries.
Does anyone know of a way to a) stop the automatic entry changing to a MUN or b) suppress the automatic entry from the list ?