July 13, 2009 at 9:02 am
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.
July 13, 2009 at 10:58 am
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)
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 13, 2009 at 11:21 am
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.
July 13, 2009 at 11:31 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply