[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Cognos Report Studio - Value prompts and dimension aliases

Posted on 2012-04-05
5
Medium Priority
?
2,260 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

649 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