RE: Calculated Member MDX syntax

From: Jim (walkerzz_at_hotmail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 10:51:04 -0800

Brian -

Thanks for your help. Thank worked perfectly.

Jim

>-----Original Message-----
>To exclude some members from a large set you can use the
except function, as in:
>
>sum(except([ABC_Company_Pvd_Type].[Company Pvd
Type].members,{[ABC_Company_Pvd_Type].[Company Pvd Type].&
[SH],
>[ABC_Company_Pvd_Type].[Company Pvd Type].&[SN]}))
>
>In this particular case you could also define your second
calc member by substracting the first calc member from the
dimension [All member].This is likely to be faster.
>HTH,
> Brian
> www.geocities.com/brianaltmann/olap.html
>
>
>
>
>.
>

Relevant Pages

  • Re: Setting the default member
    ... >You have to create the calc member in the cube: ... >leaving the editor. ...
    (microsoft.public.sqlserver.olap)
  • RE: Obtaining First Member In Set
    ... I know my calc member name is ridiculously long, I just did it for clarity, ... > My Time Dimension structure is as follows. ... > Level 2 MOC Quarter ...
    (microsoft.public.sqlserver.olap)
  • Re: Setting the default member
    ... Then go back to the dim editor and type in the name of the calc member ... In the dimension editor I canīt use calc members!!! ...
    (microsoft.public.sqlserver.olap)
  • RE: Calculated Member MDX syntax
    ... To exclude some members from a large set you can use the except function, ... In this particular case you could also define your second calc member by substracting the first calc member from the dimension.This is likely to be faster. ...
    (microsoft.public.sqlserver.olap)
  • Re: calculated member caption
    ... > First check on which dimension you've created the calc member. ... Check the syntax of the calculated member. ...
    (microsoft.public.sqlserver.olap)