Hi all! Unfortunately I'm faced with a problem for which I can't find a
solution. The requirement I'm facing seems not too exotic therefore I
hope you came across it too. I'm analyzing receipts and I need to know
how many of them contain products A and B. I know how to query the
number of receipts that contain product A ([Measures].[Receipts],
[Product].[A]) but since a tuple can only contain one member of a
dimension, it is impossible to add Product B to the query.

Thanks for any help!

Martin

Hi Martin.

WHERE { [Measures].[Receipts].[Product].[A] :
[Measures].[Receipts].[Product].[b] }

Have you tried range inclusion?

<kontakt (AT) ryf (DOT) de> wrote

If these members are not next to each other in the hierarchy you can
also just list the members in a set separated by commas.

eg.

WHERE {[Product].[A], [Product].[b] }

Mind you the above will only work in AS2k5. In AS2k you would need to
aggregate or sum the set of members

eg.

WITH
Member Measures.AB as { [Measures].[Receipts].[Product].[A],
[Measures].[Receipts].[Product].[b] }
SELECT
Measures.AB on columns
FROM <Cube>

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <eMpE74gjGHA.4512 (AT) TK2MSFTNGP04 (DOT) phx.gbl>,
Tim.NoSpam (AT) hughes (DOT) net says...

Thank you very much for your help.

Unfortunately what I'm looking for is a slightly different problem. I
need to know how many Receipts contain both Products A and B not just
one of them. Therefore I need a Tuple that contains both Products I
guess. But I have no clue how to construct such. Any help is welcome.

Thanks,

Martin

I understand you want the case of basekt analysis.

Google search will give you many related information with keyword of MDX and
"basket analysis"

Ohjoo

<kontakt (AT) ryf (DOT) de> wrote

Ohjoo is correct, what you are talking about is known as basket
analysis. Amir Netz (one of the key people behind Analysis Services)
wrote the following article on the subject:

http://msdn.microsoft.com/library/de...l=/library/en-
us/dnsql2k/html/distinct2.asp

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <OwERyIojGHA.1204 (AT) TK2MSFTNGP02 (DOT) phx.gbl>, ojkwon (AT) olap (DOT) co.kr
says...

Or do it in two steps, first find all the receipts contains A, then filter
those receipts that contains B.

"kontakt (AT) ryf (DOT) de" wrote: