How can I create a new attribute member from the sum of two other attributes
members? Example, We receive contributions. Each gift has a type of
contribution (Attribute) such as Gift and gift adjustment. What I need is to
be able to drop an attribute down that combines these two together as one
attribute.

Thanks for the Help!
--
Marty

Hi Marty,

Could you provide more details about the data for these dimension
attributes, with examples? If you inspect the Customer dimension table
in Adventure Works Data Source View, the FullName field is a combination
of others - is this similar to what you want?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

What about creating a calculated member on the attribute hierarchy - see
[Budget Variance] on the Scenario dimension of Adventure Works for an
example. The MDX expression for the member could be like:

Aggregate({[PaymentType].[Gift],
[PaymentType].[GiftAdjustment]})


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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