Re: Reproduce a member at each level in the dimension hierarchy?

#1

Have you built calculations? My guess is that once calculated member will
suffice. They are defined in the cube editor (right-click calc members
folder).

Measures.VersusTop
' (Measures.MyMeasure, OrgDim.CurrentMember) /
(Measures.MyMeasure, OrgDim.[Top Member]) '

Anytime you divide you need to check for div/zero -- wrap expression in IIF.
1st see if this is what you have in mind.

tom @ the domain below
www.tomchester.net

"Alan" <XalanX.XhowardX (AT) XparadiseX (DOT) XnetX.XnzX> wrote

Quote:

I have a dimension with the following levels:

Organisation -> Division -> Department -> Subsection

There is one organisation at the top level. Is it possible to reproduce
this
member within each of the other levels as well? What I'm trying to do is
create a pivot chart that allows the comparison of a measure for a member
at
any level in the dimension against the same measure for the topmost
organisation member.

This is what I think I need in my hierarchy to allow me to compare B1
against A, C3 against A, etc.:

A
- B1
-- C1
-- C2
-- A
- B2
-- C3
-- C4
-- C5
-- A
- A

What's the proper way of doing this? I'm using SQL Server 2000 Ent Ed.
Analysis Services and Excel 2000.

Many thanks,

Alan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Reproduce a member at each level in the dimension hierarchy?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Reproduce a member at each level in the dimension hierarchy? - 10-18-2003 , 03:18 AM