Hi ,

I want to know if it is possible to view different measures at
different members of a diemsion hierarchy. for e.g the dimension has
the following members

client
Matter
Employees

The measure 'leverage' should not exist for employees as it doesnt
apply at that level

And also if it is possible to have different calculations for
calculated members at different levels of a dimension ...any alternate
solutions and ideas will be greatly appreciated.


Thanks

Are you using AS 2000 or 2005 - different approaches may be appropriate
in each case?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

without knowing the better available options in AS 2005, you can always use
iif() to branch your calculations on different levels.

"afsheen" wrote:

Iam using AS 2005

thanks

With AS 2005, instead of iif() you could use scoping in MDX scripts to
customize calculations by attribute address:

http://msdn.microsoft.com/library/de.../en-us/dnsql90
/html/imdxsmss05.asp

Richard Tkachuk
Microsoft Corporation

March 2005
Updated June 2005

Summary: This document describes how Multidimensional Expressions (MDX)
for Microsoft SQL Server 2005 can be applied to common business
problems. This document assumes some familiarity with MDX.
...


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***