I need a calculated parent with 2 calculated childs!!! -- sql server data warehouse

Agustin
4/15/2004 6:01:10 AM

I want to build a strcuture like this!!

Dimension Name
!_Calculated Parent
!_Calculated Children
!_Calculated Children

Ex

WIT
MEMBER [Measures].[Child 1] AS '10
MEMBER [Measures].[Child 2] AS '20
MEMBER [Market].[Exp].[Calculated Parent] AS '[Measures].[Child 1] + [Measures].[Child 2]
MEMBER [Market].[Exp].[Calculated Parent].[Child 1] AS '[Measures].[Child 1]
MEMBER [Market].[Exp].[Calculated Parent].[Child 2] AS '[Measures].[Child 2]

But this is not possible cause [Market].[Exp].[Calculated Parent] not exists!!! Anyone have an idea?

Matt Carroll [MS]
4/26/2004 2:30:13 PM

Calculated members cannot have children in Anaysis Services. However, you
can create dumby entries (add a row to your dimension table) in the
dimension and then use custom member formulas or calculated cells to apply a
formula to them.

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

[quoted text, click to view]

sql server data warehouse : I need a calculated parent with 2 calculated childs!!!