Hi

I have a problem with multiple hierarchies and a certain business
requirement.

I have measure - [MEASURES].[xCountBusinessDays] - based on a column in
my view containing a 0 or 1 depending on whether a certain day is
weekday or not. Then, there is a calculated member that, for all levels
except the date level, simply returns this measure. This works fine,

My problem is that for the date level I want the value for the current
member's parent, as this is used in other calculations to divide sales
figures by the number of business days during a given period. This
period can be any level in either a year-week-date or a
year-quarter-month-date hierarchy.
The calculated member is defined like this:


CREATE MEMBER CURRENTCUBE.[MEASURES].[Count Business Days]
AS [Measures].[xCountBusinessDays],
VISIBLE = 1;

SCOPE [MEASURES].[Count Business Days];


SCOPE ( [Period].[Period Month].[PM - Date].Members);
this = ([Period].[Period Month].CurrentMember.Parent,
[MEASURES].[xCountBusinessDays]);
END SCOPE;


SCOPE ( [Period].[Period Week].[PW - Date].Members);
this = ([Period].[Period Week].CurrentMember.Parent,
[MEASURES].[xCountBusinessDays]);
END SCOPE;

END SCOPE;

My problem is that if I have both hierarchies in the [MEASURES].[Count
Business Days] scope they seem to disturb each other.
If I drill down to the [Period].[Period Month].[PM - Date] level I will
get the value for the week hierarchy: 5. Not 21 like I expected for
July 2006.

If I switch the order of the two defined scopes the opposite will
occur. Drilling down to the [Period].[Period Week].[PW - Date] level
will give me 21 as result, not 5.

Am I missing something here?