Post reply

MDX creating a member

  • April 30, 2015 at 1:48 am

    #307533

    Hi

    I have a

    [Project].[Project Status]

    there are 4 statuses

    Open

    Cancelled

    Closed Complete

    Closed Failed

    I want to create a member that groups the closeds

    Can you use case statements?

    case when 'open' then 'open' when 'Cancelled' then 'Cancelled' else 'Closed' end

    Thanks in advance

  • May 1, 2015 at 12:23 pm

    #1795086

    1. If you want only few members to show in dimension, use the view and modify view to show whatever members you need.

    2. In Dimension, if you want to see all members, for measures you want to aggregate all closed members. you can use following peseudo code(CELL CALCULATION)

    MEMBER [Measures].[Some Measure]

    AS

    ([Measures].[Amount],[Project].[Status].current member]

    CELL CALCULATION Closed

    FOR ''(([Measures].[Amount],{[Project].[Status].[Closed1],[Project].[Status].[Closed2]}))'' AS [Measures].[Some Measure Closed]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply