Solved

Cognos Report Studio - Value prompts and dimension aliases

Posted on 2012-04-05
5
2,159 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

912 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

16 Experts available now in Live!

Get 1:1 Help Now