This discussion is archived
7 Replies Latest reply: Dec 12, 2012 5:22 AM by JaiG RSS

How to wrte the MDX language in 'Edit Column Formual' in Answer,

BIDev Newbie
Currently Being Moderated
Hi Experts,
How to wrte the MDX language in 'Edit Column Formual' in Answer, like below express in Logic Layer in BMM:

EVALUATE_AGGR('MAX( %1.members,[Is_Close])', "Sales Cube"."Sales".""."Sales"."Gen5,Time" )

or

EVALUATE_AGGR('MAX( Time.currentmember.siblings,%1)', "Sales Cube"."Sales".""."Sales"."Is_Close" )

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points