I have a "Hotel" dimension similar to that of "Customers" in "Sales" cube of
"FoodMart 2000" database.
The "Hotel" dimension contains 3 levels as

Hotels
Level 1-->Region
Level 2-->Brand
Level 3-->HotelName

I have a Member Property Of "Hotel Rooms" in the 3rd level "HotelName"

Now, when I look for total rooms in a Brand A, it has to give the sum (
total rooms of Hotels in Brand A).

The same thing applies for the Region also.

Could anyone please advise me on how to design the dimension?

Thanks in advance.
Andrew Jayaraj.

Maybe this calculated member, replacing Hotel Rooms with Store Sq. Ft., will
help:

with member measures.TotalStoreSize as 'Sum(Descendants (
Store.Currentmember ,[Store Name] ) ,CLng(
iif(Store.currentmember.properties("Store Sqft")="","0",
Store.currentmember.properties("Store Sqft") ))) '
select
{[Measures].[Unit Sales] , TotalStoreSize} on columns,
store.members on rows
from Sales

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Andrew Jayaraj" wrote:

Yes, It worked.

Thanks for your help Brian.

- Andrew



"Brian Altmann" <findme@thesignaturewebsite> wrote