April 28, 2009 at 7:45 pm
Hi,
I am trying to get the data for my SSRS Report Though SSAS.i am getting data from diffrent
Measure Groups and Filtering through various Dimensons.I have a situation in this to filter the data by
having certain criterias .In short i need to union 6 MDX Statements.
Select
MeasureA,
MeasureB
ON Columns
nonempty
Filter
(
DIM.Group
*
Dim.Months
*
(
DIM.description,
MeasureA+
MeasureB+
MeasureC,
Measurec<>0)
ON
Columns
Where
DIM.Group.Package1 = YES
in second query the Filter will be
DIM.Group.Package2 = YES
in the third query the Filter will be
DIM.Group.Package3 = YES
There is no relationship between some of the measure Groups and Dim.Group.Package.
But Dim.Group.package and Dimgroup belong to same Dimenson.
Can some one can explain me how to get around to get my output of six MDX statements.
Thanks,
Venkat
April 30, 2009 at 8:56 pm
It appears that you should be able to return all of your data in a single query. Trying to understand group and package. Is group actually a hierarchy you have defined and package a level within the hierarchy. If they are in the same dimension then just create a named set with the values you are looking for and put this on the rows, you don't need to run three queries and utilize the WHERE clause for this. I am assuming you are used to T-SQL and not MDX syntax and how to use the cube.
Also, what are you trying to do on the rows. It appears that you are doing a filter within the nonempty, but are missing some right parenthesis and not sure if you have these flip-flopped or not but it does not look correct.
Please review your MDX that you have pieced together and provide more details on the dimension you are trying to reference here.
You might want to take a look at Mosha's MDX Studio tool to use it to Analyze your MDX to provide you some feedback and suggestions on your MDX - http://mdxstudio.com/[/url] (v.0.4.12 is the latest release).
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply