Post reply

OLAP Cube Calculations

  • June 18, 2010 at 6:54 am

    #236617

    Hi ,

    I have excel pivot built from an SSAS Cube.

    I have two measures m1 and m2, how can i create a calculation in excel pivot , so that when i drill down on dimension , the calculation should flow along with it.

    Appreciate .

  • June 18, 2010 at 7:06 am

    #1182101

    You can't create calculated fields in Excel when using a cube source (as far as I'm aware), you would have to create a a new calculated measure in the cube and then use that in your pivot table instead.

    e.g. On the calculations tab of your cube design create a calculated measure like so:

    CREATE MEMBER CURRENTCUBE.[Measures].[New Measure]

    AS

    [Measures].[M1] + [Measures].[M2],

    FORMAT_STRING = "#,##0.00;-#,##0.00;-;-",

    VISIBLE = 1 , DISPLAY_FOLDER = 'Calcs' ;

    When you deploy the cube you don't need to reprocess it if the only thing that has changed is the calculation script.

    Hope this helps.

  • June 23, 2010 at 8:06 am

    #1183945

    Thanks a lot .... Appreciate your help....

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

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