Still cannot see it...

Sentence that works:

SELECT {[Measures].[Budget år],[Measures].[Regn.
åtd.],[Measures].[Restbudg.],[Measures].[Regn.så.sp.],[Measures].[Regn.så.to
t],[Measures].[Åtd / tid],[Measures].[Så.sp / tid]} on columns,
descendants([Organisation].members) on rows FROM BudgetOgRegnskabConjoint
WHERE ([Tid].[2004].[Kvartal 1].[Marts],Delregnskab.[1
Hjemmetjenesten],[StedAktKonto].[All StedAktKonto].[Øvrige
driftsudgifter].[Fælles].[SIK])

Sentence that doesn't:

SELECT {[Measures].[Budget år],[Measures].[Regn.
åtd.],[Measures].[Restbudg.],[Measures].[Regn.så.sp.],[Measures].[Regn.så.to
t],[Measures].[Åtd / tid],[Measures].[Så.sp / tid]} on columns,
descendants([Organisation].[Fælles].[SIK].members) on rows FROM
BudgetOgRegnskabConjoint WHERE ([Tid].[2004].[Kvartal
1].[Marts],Delregnskab.[1 Hjemmetjenesten],[StedAktKonto].[All
StedAktKonto].[Øvrige driftsudgifter].[Fælles].[SIK])

It says cannot bind - unknown dimension or level
[Organisation].[Fælles].[SIK] but that is the name of the level ?

\Michael Vardinghus

You did not use the descendants() properly

here is the syntax: Descendants(«Member», [«Level»[, «Desc_flags»]]

You should specify the parent member first

Thanks

Faelles is father to SIK ... but Faelles also has OKO and Personel as
children.
Alongside Faelles level I have North and South with their corresponding
children.


"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> skrev i en meddelelse
news:CC59F178-53DA-45DB-8B48-8E5B584C059D (AT) microsoft (DOT) com...

If [Organisation] is a parent-child dimension, then is [SIK] actually a
member, rather than a level? In that case, is this what you really need:

Descendants([Organisation].[Fælles].[SIK].Children)


From SQL Server BOL>>
In a parent-child dimension, only a single level can be defined (besides
the optional (All) level), but it usually produces multiple levels in
the hierarchy.

- Deepak

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

Think that's it....


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> skrev i en meddelelse
news:%23D9%23JqaTEHA.2908 (AT) TK2MSFTNGP10 (DOT) phx.gbl...