dbTalk Databases Forums  

Get a calculeted member from member of different dimensions

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


Discuss Get a calculeted member from member of different dimensions in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrea Temporin
 
Posts: n/a

Default Get a calculeted member from member of different dimensions - 06-17-2004 , 04:55 AM






My problem is this:
How can I Store into a cube( as a calculeted member or calculeted cell) the
ratio of two specifica members of two different dimensions?

I mean

[DimensionA].[LevelA].[MemberA]/[DimensionB].[LevelB].[MemberB]

supposing the current values for all other dimensions of the cube ...
I've just tried to store it as a calculeted member or calculeted cell into
the cube but browsing the cube with Analysis Menager i've got #ERR and
double cliccking a cell gives me "Infinite recurdion detected during
execution of calculeted member".



Reply With Quote
  #2  
Old   
Francesco De Chirico
 
Posts: n/a

Default Re: Get a calculeted member from member of different dimensions - 06-17-2004 , 07:56 AM






Hi Andrea ,
may be your calculated member is using itself. This happen if you use
something like this:

[DimensionA].[LevelA].CurrentMember / [DimensionB].[LevelB].[MemberB]

and the calculated member is also defined for the DimensionA.


--
Francesco De Chirico



Reply With Quote
  #3  
Old   
Andrea Temporin
 
Posts: n/a

Default Re: Get a calculeted member from member of different dimensions - 06-17-2004 , 10:26 AM



This expression
([Measures].[Valore],[PianoDeiConti].[PerSezioni].[Tutti i
conti].[CE].[EC].[60].[60.010])/([Measures].[Valore],[Parametri].[PianoStand
ard].[S].[SM].[SM.01].[SM.01.10].[SM.01.10.01])
saved as calculeted member on Measures works but gives me the error I
reported if I save It as a calculeted member on dimension
[Parametri].[PianoStandard] or as CalculetedCells ovveriding the value of
one member of [Parametri].[PianoStandard].
I don't use the CurrentMember clause as you see and I dont specify any
member of the Dimension [Parametri].[PianoStandard] in the where clause.
Any other idea?
Thank you very much?
PS:
Mybe I have to create an AllLevel in the [Parametri].[PianoStandard]
hiererarchy?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.