Hi, All Gurus

I am stuck on one problem for Calculated Measure
Any help will be very important for me.

For a simple cube I have one cube with 1 Dimension and 1 Fact tables

The Diemension is parent child.
id parent id name
1 enterprise 1
2 1 team1
3 2 Agent 1
4 2 Agent 2

so the dimension will like this

entreprise1
-team1
-Agent1
-Agent2

Fact Table is Like This

Id VALUE DATA

1 240
2 230
3 110 100
4 110 100

The Calculated measure we will get from the field VALUE

I want the cube like this

Goal (Calulated Measure from
VALUE) DATA
Ent Team Agent1 110
100
Agent 2 110
100
Total 230 ---- Goal for Team 1 Only
( Not From Agent1, Agent2 ) 200 (sum of Agent1
&Agent2)
Total 240 -------Goal for
Enterprise 1 Only (Not From Team1, Agent1, Agent2) 200(sum of Team)
--

Thanking You

Amish M Shah
Sr. Programmer
IntraAction Software(Ahmedabad, India)
Mo - 9879398697

Since the fact table has "Value" data for non-leaf members, presumably
the "Members With Data" option has been selected for your dimension. In
that case, assuming there is a basic Sum measure called "MyValue", then
the "Goal" can be:

'([MyDimension].CurrentMember.DataMember,
[Measures].[MyValue])'

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks Deepak


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote