MDX Drill Through on Calculated Members

Hi All,

I need help with MDX.

I have to Write a MDX Query that fetches me the customers who purchased in  both categories a and b.
I tried writing a calculated member that counts the customers in both a and b using intersect and count function but i am unable to drillthrough.

WITH MEMBER [Measures].[Cont1+2 count] AS (
Count(Intersect(NONEMPTY(
[Customers].[CustomerKey].[CustomerKey].members,
([Products].[category].&[Film/TV],[Measures].[NoOfCustomers] )),
NONEMPTY([Customers].[CustomerKey].[CustomerKey].members,
([Products].[category].&[Games], [Measures].[NoOfCustomers])))))
SELECT
FROM [Cube]
WHERE ([Measures].[Cont1+2 count])

This code gives me the count of customers who purchased both a and b but it doesn't give the customers who are contributing to the count.

I searched the forums and found that we cannot drillthrough a calculated member.

Can someone suggest me an alternative method Please.

Thanks in Advance

Cheers
Visu
Visu18Asked:
Who is Participating?
 
EE_AutoDeleterCommented:
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.

EE_AutoDeleter
0
 
Visu18Author Commented:
I got the solution

SELECT NON EMPTY { } ON COLUMNS,
Intersect(NONEMPTY(
[Customers].[Customer Key].[Customer Key].members,
([Products].[category].&[Film/TV],[Measures].[NoOfCustomers] )),
(Intersect(NONEMPTY([Customers].[Customer Key].[Customer Key].members,
([Products].[category].[CM Category].&[Music], [Measures].[NoOfCustomers])),
NONEMPTY([Customers].[Customer Key].[Customer Key].members,
([Vw Products].[category].&[Games], [Measures].[NoOfCustomers]))))) ON ROWS
FROM [Cube]


This gives me the customers that are in both categories.
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.