I am trying this expression in the Calculated Member Builder

[Measures].[Cost]/[Building].[Head Count]

And I get the following error:

Unable to update the calculated member.
Formula error - cannot bind: unknown dimension or member: "[Building].[Head
Count]"

This seems simple unless I cannot use a dimension member in the calculation.

Thanks in advance
GH

I have figured out the binding issue ... is really telling me i have a poorly
formed MDX expression.

I am not trying this test expression as my Calculated Member:
(Calendar.CurrentMember).[Location].[Head Count]

This is returning an #err in all cells returned.

My challenge is finding Cost\Person

I have the following dimensions:
Calendar with Date/Year/QTR/Month/MonthDay/WeekDay
Location with Area/Region/District/Branch/Building/HeadCount

The fact table fctCosts with the measures FixedCost,VriblCost

I want to be able to add the Calculated Member Cost/person where (FixedCost
+ VrblCost) / HeadCount = Cost\Person

But I cannot get the value of (Calendar.CurrentMember).[Location].[Head
Count] to print.
--
Thanks in advance
GH


"GH" wrote:

Hello,

To understand the issue better, I'd like to know the detailed meaning of
HeadCount. Is it a member property of building member? Or they are staffs
in the building?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Headcount is the number of staff permanetly assigned to that building.

So if the annual total costs of the building is $100,000 and the Headcount
is 10 then the Annual CostPerPerson will be $10,000.
--
Thanks in advance
GH


"Peter Yang [MSFT]" wrote:

HI Peter,

My latest approach is to make the Headcount a Member Property of the
BuildingName.

Then when using the CalculatedMemberBuilder to create a calculated measure
or Member using MDX expression
[Location_HC].CurrentMember.Properties("HeadCount") returns a #ERR in the
grid.
--
Thanks in advance
GH


"GH" wrote:

Hello,

Because the headcount is only the member properties of the leaf level of
location dimension, there will be error if you use them directly in
caculated member. You may want to try the following MDX:

With
Member Measures.[headcount] As
' IIf
(
IsLeaf ( location.CurrentMember ),
val( location.CurrentMember.Properties("headcount") ),
Sum
(
Descendants( location.CurrentMember,,Leaves ),
Measures.[store sqft]
)
) '

Member Measures.[Cost Per headcount] As
' Measures.[store sales] / Measures.[headcount] '

select
{ Measures.[headcount], Measures.[Cost Per headcount] } on columns,
NON EMPTY [location].[building].members on rows
from costcube

Hope this is helpful.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
<udRVilStFHA.780 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
<C8FA01CE-9763-4977-8344-5EE0197F96C2 (AT) microsoft (DOT) com>

HI Peter,

Your post was helpful and I have made progress.

Currently I am using one dimension Location_HC with the following levels
Region, Country,City, Building Name.

Building Name has the Property "Head Count"

There is one measure "Cost".

I am trying to create a CalculateMeasure CostPerPerson ...

Step one is to get the headcount correctly calculated across the tree.

The following MDX expression works great and the calculations are correct at
all levels:
IIf(IsLeaf(location_hc.CurrentMember),
val(location_hc.CurrentMember.Properties("head count")),
SUM(Descendants(location_hc.CurrentMember,[building Name])))

Step two is to divide the Cost by the headcount so I tried this expression:
IIf(IsLeaf(Location_hc.CurrentMember),
(Measures.Cost)/(val(Location_hc.CurrentMember.Properties("head
count"))),(Measures.Cost)/(SUM(Descendants(location_hc.CurrentMember,[Building Name]))))

Only the leaf level calculates correctly, none of the other levels calculate
correctly.

The only difference is the division .... I don't understand!!


--
Thanks in advance
GH


"Peter Yang [MSFT]" wrote:

Hello,

I think the reason is that cost is already a measure and you does not need
to manually sum it again:

You may want to use another caculated member to do this as I mententioned:

Member Measures.[Cost Per headcount] As ' Measures.cost /
Measures.[headcount]

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<udRVilStFHA.780 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
<C8FA01CE-9763-4977-8344-5EE0197F96C2 (AT) microsoft (DOT) com>
<AF5113B7-374B-4F2D-8391-B7B74BB6A7C7 (AT) microsoft (DOT) com>
<7h$#Hf3tFHA.768 (AT) TK2MSFTNGXA01 (DOT) phx.gbl>
ng Name]))))

Thanks Peter,

That point went over my head.

I have it working now ...

Now I am going to add in additional dimensions ... hopefully without issue.

Thanks for your patience.

--
Thanks in advance
GH


"Peter Yang [MSFT]" wrote:

HI Peter,

I am back on this issue ...I have added the dimension Calendar
(Year,Qtr,Month) to the cube ... now I have the Location ( Area, Region,
District, Branch, Building (and the building property Headcount)).

Now all levels are calculating the total sum of the headcount .... I cannot
find any documentation with a calander dim being used.

Any suggestions would be appreciated.
--
Thanks in advance
GH


"GH" wrote: