Hi,

I would like to have a budget attribute of a dimension used as measure
for use in a calulation.

What is the statement to use in SSAS2005?

I tried some statements without error but always empty !

Example:

Dimension:
[Store].Budget

Regards, Marco

insure that the "value column" property is setup for your attribute
and use something like:
[Sotre].[Budget].membervalue to retrieve this value.

acessing [Sotre].[Budget].membervalue required that you are at the store
level.

so this:
sum(store.[store attribute].[store attribute].members,
[Sotre].[Budget].membervalue )
or
sum(store.[store hierarchy].[store leaf level].members,
[Sotre].[Budget].membervalue )
return the total budget of ALL stores.


"Marco" <olap (AT) gmsbv (DOT) nl> wrote