Creating a Calculated Member in Report Designer

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  April 28, 2011 at 5:37 am

  #249473

  Hi All,

  I want to create a Calculated Member [New Joiner] while creating a SSRS report in Report Designer for which I was trying to do this...

  [New Joiner] =

  IIF(

  [EMPLOYEE].[GRADE CODE].&[A] or [EMPLOYEE].[GRADE CODE].&,

  [Measures].[NEW EMPLOYEE],

  Nothing)

  This however, doesn't seem to be working and takes a lot of time and never executes.

  I however also tried using

  Aggregate(

  {[EMPLOYEE].[GRADE CODE].&[A], [EMPLOYEE].[GRADE CODE].&},

  [Measures].[NEW EMPLOYEE])

  But this was giving absurd values :hehe: . Any help in this regard would be very much appreciated.

  Athar

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  April 28, 2011 at 8:59 am

  #1317323

  Above code is for the DataSet created in the report which is pointing to Cube.