June 10, 2004 at 8:43 am
Hi All,
I want to pull data from a cube via MDX such that I have one dimension on the rows, one dimension on the columns, and three measures (on the columns too?). For example, the following statement will give me Call Classes on the columns, Regions on the rows, and Call Count for a measure:
SELECT [Call Class].Members ON COLUMNS
[Regions].Members ON ROWS
FROM BilledCallDetail
WHERE ([Measures].[Call Count])
What I need is to have not only call count show in the data portion of a grid but also two other measures - Amt & Minutes. Can anyone shed any light on this for me? When I put all three measures in the slicer, I get an error stating the tuple can't be resolved.
Thank you,
Michael
mhweiss
June 10, 2004 at 11:24 am
Hi, try this:
SELECT { CrossJoin( { [Call Class].Members },{ [Measures].[Call Count],[Measures].[Other Measure1],[Measures].[Other Measure2] } ) } ON COLUMNS
{ [Regions].Members } ON ROWS
FROM BilledCallDetail
/rockmoose
You must unlearn what You have learnt
June 10, 2004 at 5:24 pm
Thank you! That worked great!
Michael
mhweiss
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply