?
Solved

Cognos Report Studio - Value prompts and dimension aliases

Posted on 2012-04-05
5
Medium Priority
?
2,241 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:SNeupane
ID: 37811679
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
ID: 37811708
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
ID: 37811783
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
ID: 37897547
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
ID: 37913824
I found the answer myself - but it was my mistake.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to increase the row limit in Jasper Server.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

770 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