MDX question

[Former Member]

Hello all,

I want to write a query in MDX returning the list of our customers buying product A AND product B.

How can help me further? I've already looked at some documentation. What I need is a coding sample.

Thanks, Nathalie

[Former Member · Accepted solution]

Hi,

Few links on MDX:

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

The easiest way is to be build a query to obtain the result you want. Then use t-code MDXTEST to help you put together the MDX statment against the query.

[Former Member · Accepted solution]

Hi Rick,

It's what I've already done. What I don't know is how to write the line of code selecting Product A AND Product B. I tried whith a WHERE statement, but it didn"t work.

Thanks, Nathalie

[patrick_williams]

How about something like this...

SELECT

{[Measures].[0QUANTITY]} ON AXIS(0),

{[0MATERIAL].MEMBERS, [0CUSTOMER].MEMBERS} ON AXIS(1)

FROM [<i>cubename</i>/<i>queryname</i>]

WHERE {[0MATERIAL].[A], [0MATERIAL].<b>}