Hi,

I'm hoping someone can explain why my aggregation isn't working. I've
broken the problem down to the bare minimum to illustrate the point - I've
got a parent child dimension where each leaf element represents part of an
organisation. Each leaf has a cost associated with it, which is the cost of
running that department. I want the cost of running the department to
aggregate up to the parent.
As a simple test of a calculated cell I've tried this:-
scope ([Measures].[Data],
[Organisation].[Parent ID].[Level 03].children
);
this = [Organisation].[Parent ID].currentmember.properties ("Cost");
end scope;

If I then put the Organisation dimension and the measure onto the SSAS pivot
table I get values for my leaves, but no aggregated value, not even zero.

If I change it to something like this:-
this = 5;
then I see the correct aggregated value. Can someone explain to me what's
going on?

thanks,
Paul.

What is the data type of the "Cost" property - assuming that is numeric,
you would need to retrieve the strongly-type value (otherwise, if it's a
string, it could be cast):

this = [Organisation].[Parent ID].Properties ("Cost", TYPED);


http://msdn2.microsoft.com/en-us/library/ms144821.aspx
Properties (MDX)
Updated: 17 July 2006

Returns a string, or a strongly-typed value, that contains a member
property value.

Syntax

Member_Expression.Properties(Property_Name [, TYPED])
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

"Deepak Puri" wrote:

Many thanks for the help Deepak.

Paul

Will SSAS perform an aggregation on a Property? I was under the impression
that only measures are calc'ed up the hierarchy.

-z


On 9/18/06 11:51 PM, in article
A0342728-870C-491F-ABFA-3ED67CAE5BBC...soft (DOT) com, "Paul"
<Paul (AT) discussions (DOT) microsoft.com> wrote:

In this case, it is still a measure: [Measures].[Data] which is being
aggregated up the hierarchy, but since its values lower in the hierarchy
are overwritten with the corrsponding hierarchy Property values, it is
now the Property values which will be aggregated upwards.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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