Solved

Cognos Report Studio - Value prompts and dimension aliases

Posted on 2012-04-05
5
2,140 Views
Last Modified: 2012-06-27
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 ?
0
Comment
Question by:AL_XResearch
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:SNeupane
Comment Utility
Not sure this will work but try using a caption() or value() around the data item in crosstab columns.
0
 
LVL 3

Author Comment

by:AL_XResearch
Comment Utility
Thank you 'SNeupane' but the problem I am trying to resolve is the display of the MUN value in the 'Value Prompt' control - nothing todo with the Crosstab. The value prompt is based on it's own query which selects all elements from that dimension.

The 'All members' item is automatically added by report studio.
0
 
LVL 8

Expert Comment

by:SNeupane
Comment Utility
I see.
You can try the same logic above in prompt data items as well.

However, I tested in one of our TM1 cubes for month in prompt and used alias description as display value but I don't see any MUN in the prompt list.
See the attached screenshot.
Is there a different way to recreate the issue?
TM1-alias.png
0
 
LVL 3

Accepted Solution

by:
AL_XResearch earned 0 total points
Comment Utility
My appologies, I have found a solution - It was my own fault. The dimension the value prompt was based one where there was an 'All customers' entry but there was no element alias defined for this - so ReportStudio defaulted to showing the MUN as there was no alias available.

I had defined 2 similarly named by differently structured dimensions and simply selected the wrong one.
0
 
LVL 3

Author Closing Comment

by:AL_XResearch
Comment Utility
I found the answer myself - but it was my mistake.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
How to increase the row limit in Jasper Server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now