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
Solved

Cognos Report Studio - Value prompts and dimension aliases

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

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…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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