Calculated Cells in SSAS 2008

• Daniel Jebaraj

  SSC Veteran

  Points: 245

  More actions

  August 11, 2010 at 6:34 am

  #225923

  Hi All,

  We are actually re-developing an SSAS 2000 cube in SSAS 2008(as we have some problems with Migration Wizard Tool) which has calculated cells.

  Can you please tell me how to create calculated cells in SSAS 2008 defined in SSAS 2000. It seems it is not straightforward.

  Thanks.

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  August 11, 2010 at 8:45 am

  #1205404

  You should be able to use either CELL CALCULATION or SCOPE statements in the MDX script within the cube.

  The official doc for CELL CALCULATION can be found here.

  Steve.