Quick question about measure groups

  • We have several calculated members in our cube and it'd be nice to add them to the existing measure groups. Is this possible? If so, how would one go about doing it? I thought it'd be simple and straightforward but a couple hours of Googling isn't turning anything up.

  • Use the option in the cube structure tab of the desired cube to add 'New Measure'. This is available in the toolbar or by right-clicking in the Measures window. From there you can walk through the wizard to select the usage type, source table, column, etc.

    Measures (Cube Structure Tab, Cube Designer) (SSAS)

    New Measure Dialog Box (SSAS)

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • Thanks for the reply, but I just found what I was looking for. It's under the Calculations tab, then click on Calculation Properties. In that window, I can assign a calculated member to an existing measure group.

  • My bad, thought you were just trying to add some additional calculations from your fact table that you might have added or did not include originally.

    Yeah, this can be done in the Calculation Properties you can select the Measure Group to associate it with along with specifying a Display folder. Glad you found it okay.

    With BIDS Helper you also get a Description section - http://bidshelper.codeplex.com/Wiki/View.aspx?title=Calculation%20Helpers

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 4 posts - 1 through 4 (of 4 total)

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