Re: Conditional MDX Staement

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Rob Anderson (RobAnderson_at_discussions.microsoft.com)
Date: 12/21/04 

Date: Mon, 20 Dec 2004 23:59:02 -0800

Hi Richard, thanks for your response. I want the All level to show the
aggregation of the 2 measures. This would mean allocating the amount for
measure1 to all descendants of prduct.level1 and allocating the amount for
measure2 to all other members and then aggregating. Any ideas?

"Richard Tkachuk [MSFT]" wrote:

> What do you want the calculation to show when you're at the all member in
> the product dimension? The way the calculation is set up, it will be
> Measure2 - this your intent?
>
> --
> _______________
> Disclaimer : This posting is provided "AS IS" with no warranties, and
> confers no rights.
>
> "Rob Anderson" <Rob Anderson@discussions.microsoft.com> wrote in message
> news:5EB61F54-4F13-4F8B-AC67-3F0713DAC894@microsoft.com...
> > Hi Guys,
> >
> > We're having some problems with an MDX statement defining a calculated
> > member. What we have is a cube with 2 different measures. We would like to
> > determine which measure to use based on one of the dimensions (lets call
> it
> > Products) .
> >
> > The products dimension has 3 levels. Where the member is a descendant of 1
> > of the members in the first level then we want to use measure1, otherwise
> use
> > measure2.
> >
> > The MDX looks like this:
> >
> > iif(Ancestor([Product].CurrentMember, [Product].[level1]) is
> > [Product].[Level1].&[9],
> >
> > [Measures].[Measure1],
> > [Measures].[Measure2]
> > )
> >
> > This all looks fine in a pivot table but when I put the dimension on rows
> > and select 1 or more, but not all of the members in the dimension, the
> grand
> > total for the measure is never correct. Usually it's whatever the
> grandtotal
> > is for measure1 or measure2. Can anybody shed any light on this for me?
>
>
>

Relevant Pages

  • Re: Allocating costs across a period of time
    ... The following allocates the amount to each month on the basis of the days in the month and a rate per day determined by dividing the amount to be allocated by the total number of days: ... Dim Date1 As Date, Date2 As Date ... Dim StartMonthDays As Long, EndMonthDays As Long ... >I am writing a procedure that involves allocating a series of costs over>a ...
    (microsoft.public.word.vba.general)
  • [Suspend2][ 21/28] [Suspend2] Get swapwriter image storage needed.
    ... Return the amount of space in the image header needed for swapwriter ... configuration info. ... which we factor in when allocating the space. ...
    (Linux-Kernel)
  • Re: Finding Restore Point
    ... >>But in practice the amount of allocated space does directly impact how far ... SR checkpoints can be different sizes - therefore you ... Allocating a certain ... > amount of disk space to SR will allow X number of checkpoints - not how far ...
    (microsoft.public.windowsxp.general)
  • Re: U Area Removal
    ... the amount of data we have stored in each process' U ... > I propose to remove the ability to swap the U area, allocating p_stats ...
    (freebsd-arch)