Solved

How do I correct the problem in a Cube To Table Report parameter "All" & "Select All"

Posted on 2011-03-02
3
249 Views
Last Modified: 2012-05-11
Please view the attached.

Using report wizard on a cube worked great for me except for this parameter issue.  In the cube query builder I select All for the parameters when the wizard completes I open the data transposed to a table my parameter looks like the attachment.  Please advise to correct either removing the "select all" or "all" and still be able to make individual selections. Sample Parameter Drop Down
0
Comment
Question by:rhservan
[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
  • 2
3 Comments
 
LVL 10

Expert Comment

by:itcouple
ID: 35017957
Hi

It is important to understand what 'ALL' means. Select all just ticks all the boxes below. ALL will return only one row (aggregation on top level) or no filter which is usually what you don't want.

You can remove it by changing autogenerated MDX (go one level down which will skip all). I will see if there is a easier way to do that. If I cannot find it just post your actual MDX and I will show you where to change it.

Regards
Emil
0
 

Author Comment

by:rhservan
ID: 35019604
I have attached the query below.
Sample.txt
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 35020160
Could you find out what dataset the parameter is using? The dataset will be hiden so you will have to unhide it. Once you find it send the MDX.

Regards
Emil
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

705 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