Solved

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

Posted on 2011-03-02
3
232 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
  • 2
3 Comments
 
LVL 10

Expert Comment

by:itcouple
Comment Utility
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
Comment Utility
I have attached the query below.
Sample.txt
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 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

8 Experts available now in Live!

Get 1:1 Help Now