Re: Switch MDX according to VALUE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

1)
I need you to post the entire MDX, not just the IIF part.

2)
Is this a calculated member? If so, under which dimension is it stored?
If it is stored under the Measures dimension,
Sum([Product].CurrentMember.Children) won't work because you need explicitly
say according to which numeric value you wish to Sum.

Something like: Sum([Product].CurrentMember.Children, [C Area])

Elad




"Andrew A via SQLMonster.com" <forum@xxxxxxxxxxxxxx> wrote in message
news:51F4620D9BB2E@xxxxxxxxxxxxxxxxx
>
> Hi Elad,
>
> I followed your advice entering to MDX Sample Application, find "STORE EL"
> and have this value:
> [Enterprise].[All Enterprise].[STORE EL]
>
> Comparing:
> [Enterprise].CurrentMember is [Enterprise].[All Enterprise].[STORE EL]
>
> Posted my MDX.
>
> iif
> (
> -- [Enterprise].CurrentMember is [Enterprise].&[STORE EL],
> -- [Enterprise].CurrentMember.level.name = "STORE EL",
> -- [Enterprise].CurrentMember.name = "02",
> -- [Enterprise].CurrentMember.Uniquename = [STORE EL].Uniquename ,
> -- [Enterprise].CurrentMember.properties("caption") = "STORE EL",
> -- [Enterprise].CurrentMember is [Enterprise].[Enterprise].&[STORE EL],
> [Enterprise].CurrentMember is [Enterprise].[All Enterprise].[STORE EL],
> iif(isleaf([Linea].currentmember),
> iif(
> [Measures].[C Area] = 0,
> null,
> [Measures].[S Area] / [Measures].[C Area]
> ),
> Sum([Product].CurrentMember.children)
> ),
> iif(
> [Measures].[C Area] = 0,
> null,
> [Measures].[S Area] / [Measures].[C Area]
> )
> )
>
> Enterprise, is a Dimension that have Children (some stores)
> Line is a dimension that only have ALL LEVEL and a Few Lines, that I want
> to
> Sum for STORE EL and want only to make Average for STORE ADAMS
> Resuming the problem, this line:
> [Enterprise].CurrentMember is [Enterprise].[All Enterprise].[STORE EL]
> must return true to enter to one MDX1 (STORE EL) and false to return to
> MDX2
> (STORE ADAMS)
>
>
> --
> Message posted via http://www.sqlmonster.com


.

Relevant Pages

  • Re: Switch MDX according to VALUE
    ... It would be helpful to post the entire MDX, not just the IIF part. ... > I followed your advice entering to MDX Sample Application, find "STORE EL" ... is a Dimension that have Children ...
    (microsoft.public.sqlserver.olap)
  • Re: Best design practice for temporal facts...
    ... Now do you store in a fact table the following columns of data: ... DateTimeStamp (When was this data captured, FK to time dimension) ... just to show the change in utilization at any given moment. ... > For more information regarding Real-Time Cubes, ...
    (microsoft.public.sqlserver.olap)
  • Re: how to get a properties of another dimension?
    ... Looking at the schema of the Foodmart HR Cube, ... "Reference" dimension in AS 2005 terms, ... One way to infer the relationship between an employee and the ... corresponding store ...
    (microsoft.public.sqlserver.olap)
  • Advice needed to build a lean-to shed...
    ... I need to store my car somewhere for at least 3 years. ... Austin Healey 3000 and is about 12x5 in overall dimension. ...
    (alt.home.repair)
  • custom rollup formula slow
    ... Let's say I've got a cube with these 2 dimensions: ... ...Store ... it's aggregating the Time dimension before the Store dimension... ... Looking at a slice closer to the leaf performs OK. ...
    (microsoft.public.sqlserver.olap)