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
rhservanAsked:
Who is Participating?
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.