Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

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

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
rhservan
Asked:
rhservan
  • 2
1 Solution
 
itcoupleCommented:
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
 
rhservanAuthor Commented:
I have attached the query below.
Sample.txt
0
 
itcoupleCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now