calculated member

#1

Is it possible to use calculated member in another calculated member todo
some arithmetic? if so, is there any syntax

thanks
kalyan

#2

[forwarding to the OLAP newsgroup]

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]
PLEASE POST NEW QUESTIONS AT
http://forums.microsoft.com/msdn/sho...id=81&siteid=1

<Nir (AT) Rashim (DOT) Co.il> wrote

Quote:

Hi

When looking at the template of the calculated member [Percentage of
Total] it appears that I have to refer to the <<Target Hierarchy>>.
That means that I have to create a calculated member for every hierarchy.
Is there a way to create only one calculated member that refer to current
hierarchy.

Thanks

#3

Could you post the actual MDX query in SSRS 2005 - and does this same
query run acceptably in Managment Studio?

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

#4

Seeing the large number of cross-joins in the row set, and assuming that
[Measures].[Amt Due] and [Measures].[Amt Recd] are themselves base cube
measures, you could try setting the NON_EMPTY_BEHAVIOR property of
[Measures].[Difference AmtRec - AmtDue] to: {[Measures].[Amt Due],
[Measures].[Amt Recd]}.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

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

calculated member

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

calculated member - 03-09-2006 , 11:35 AM

Re: Calculated Member - 05-16-2006 , 10:55 PM

Re: calculated member - 01-19-2007 , 03:50 PM

Re: calculated member - 01-20-2007 , 08:26 PM