Hi all,
I am using sql 2000 AS with SP4 and Proclarity 6.1.
I am working on a Sales cube. There is a dimension called Retailers, the
heirarchy is : Area > Distributors > Retailers. At leaf level (Retailer) I
have a property called "Coverage Day" which can be any of the week days. It
actually tells me on which day of week shud this particular retailer be
visited by my sales person. The sales person actually gets the data files
from the retailer.
So, if a retailer has a coverage day - Monday, then I shud have data of the
retailer for all mondays in the month. In practice however, this can be
delayed due to various reasons and the file can come at days other than
coverage day.
Now, I have a report which shows me Retailors and the flag - 0/1 for
coverage day, which ii am getting using a calculated member. I am actually
comparing the properties of 2 dimensions - Retailer (coverage day) and Time
(week day).
The problem is , I want the member to work on a non leaf level also. For
example, When I see the same report at Monmth level, it should show me the no
of coverage days each retailers has. i.e If june has 4 fridays, then retailer
R1, which has coverage day = friday, for june should show me 4.

I am not good in MDX and have no idea how can get this.
any suggestion?