Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Hiding measures above Country level (AS2000)

Author  Topic  kmamykin Starting Member 1 Post Posted - 2006-11-07 : 16:33:46 Hello, I have the following problem I would appreciate your help with: I am designing a cube “Cost Benchmarking” using Analysis Server 2000 with the following structure (simplified for the sake of this post): Dimensions: Countries (levels: (All), Regions, Countries) Clients (levels: Client) Media (levels: TV Station) Months (levels: Years, Quarters, Months) Measures: Cost (amount of money the clients spent on advertising, in local currency), Cost in USD (Cost converted to USD at the fact record level), Impressions (raw number of impressions the ad campaign achieved, in thousands), CPM (Cost Per Thousand impressions, calculated = Cost/Impressions) The problem is that several measures do not make business sense to aggregate above the country level, namely Cost, Impressions and CPM. Users don’t even want to see those measures until a country is specified (we are planning on using Excel Pivot Table as a client).‘Cost in USD’ however can be aggregated at the Region and (All) levels. Is there a way to hide those measures above the Country level? Thanks Kliment