-
Problems with aggregation of distinctcount-measure
Hi Experts,
I have a problem:
I have various cube packed in a virtual cube to give me distinctCount Values of customers who purchased products (DC customer] and purchased products (DC product) along with Saleries [RW] over numerous dimensions such as productgroups customergroups etc.
In the calculated measure [RW kum] I can sum the the salaries from the beginning of the year until [time].currentmember with the following MDX-Code:
With member [Measures].[RW kum] As 'Sum(Periodstodate([time].[year]).[Measures].[RW])'
Select {[Measures].[RW],[Measures].[RW kum], [Measures].[DC customer]} on rows,
[Productgroup].[Itemgroup].Allmembers on columns
From [vcub_Sales]
Where [Time].[2005].[march]
IF I use this PeriodsToDate-Formular with the the measure DC customer I will get the sum of distinctcounts of the periods.
What I want is the distinct count of all customers who have purchased since the beginning of the Year until the [Time].currentmember in the same Level.
Given this problem, do I..
1. have make another Cube or
2. another time dimension or
3. is there a way in MDX to get the result?
I would appreciate any replies.
Zannadar
-
Hi:
Did you get a chance to read my article on how to handle Distinct Counts in MSAS?
http://databasejournal.com/features/...le.php/3482536
Give it a twirl, and come back with any specific questions that remain.
Needless to say, letting us know that it was helpful is appreciated (although certainly not expected).
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|