Measure should only be calculated for certain Dimension Attributes

Hi,

I've created a Dimension - Organisation (company_name,
department_name,room_name). The primary key is Organisation_ID and I
have a Measure Room Utilization. I'd like to show this Measure only
when Room_Name is selected and with every other member of this
Dimension there should occur a 0 for Room Utilization.

It works when I create a hierachy inside the Dimension with the
following MDX statement:

CREATE MEMBER CURRENTCUBE.[MEASURES].Room_Utilization
AS
case when [Organisation].CurrentMember.Level.Ordinal = 4
then [Measures].Room_Utilization
else 0
end
VISIBLE = 1;

how can I get it going when my Organisation Dimension has the following
attributes:
company_name,
department_name,
room_name

without hierachy and I only want to calculate the Measure Room
Utilization for the room_name attribute?

Thanks!

Here is how you can do it with Analysis Services 2005

Create RoomUtilization;

(Organization.[Room Name].[Room Name].MEMBERS, Measures.RoomUtilization) = Measures.PhysicalMeasureRoomUtilization;

And, of course, you would make PhysicalMeasureRoomUtilization a hidden one.

HTH,

Mosha (http://www.mosha.com/msolap)

sql