locked
mdx to Calc Member question. RRS feed

  • Question

  • I have 2 dimensions, date dim & StatusType dim, and a measure, [Count_ROCANCELED] . 

    The following mdx works fine.  i like to put it in the calc member, so, when user drop the calc member it can be sliced by the date dim with that "filter" of [StatusType].[Status Date Type Desc].&[CANCELED] .

    what is the correct syntax for the calc member? In the process I will need to keep the date hierarchy. thanks.

     SELECT NON EMPTY { [Measures].[STCount_ROCANCELED] } ON COLUMNS, NON EMPTY { ([Date--LinkedStatusType].[YMD].[Month Number Of Year].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [StatusType].[Status Date Type Desc].&[CANCELED] } ) ON COLUMNS FROM [SOS OLAP]) WHERE ( [StatusType].[Status Date Type Desc].&[CANCELED] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS


    -- IBM has jobs for USA employee to work oversea (India) and get their wages.


    • Edited by light_wt Monday, August 19, 2013 6:54 PM
    Monday, August 19, 2013 6:44 PM

Answers

  • (
    [Measures].[RO Status Canceled Date Count] ,
     [Date--LinkedStatusType].[YMD]
    , [StatusType].[Status Date Type Desc].&[CANCELED]

    )


    -- IBM has jobs for USA employee to work oversea (India) and get their wages.

    • Marked as answer by light_wt Monday, August 19, 2013 7:23 PM
    Monday, August 19, 2013 7:23 PM