Calculation Helpers

This feature enhances the Calculations tab of the cube editor.

First, it remembers whether you work in the Script View or the Form View and takes you to that view immediately upon opening the Calculations tab of the cube editor.

Second, this feature improves the Calculation Properties dialog in several ways. The Microsoft version required that you close and reopen the cube designer window before it would pick up any new calculated measures you added to the calc script. This problem is solved with the BIDS Helper add-in. BIDS Helper also allows you to edit descriptions on calculated measures and named sets via the UI. Previously, editing these descriptions was only possible via direct editing of the *.cube XML file.

BIDS Helper replaces the existing Calculation Properties button with its own:

CalculationPropertiesButtonTeaser.gif

The Calculation Properties window that appears when you click that button is identical to the Microsoft one, except that it adds an "Edit Description" button:

CalculationPropertiesDescriptionsTeaser.gif

Last edited Feb 17, 2007 at 5:22 AM by furmangg, version 3

Comments

dgosbell Dec 2, 2012 at 9:49 PM 
Calc properties are stored in a separate part of the XMLA from the MDX Script where the members/sets are defined, so it's possible that you have some orphaned properties in there. If you view your cube in Code View you should be able to do a search and see if this is the case.

Minnie Nov 26, 2012 at 10:04 PM 
1. for some reason, the "calculation properties" window show me the 'named set' which I deleted off the project long timer ago (I just double checked it is not in the script view either)
2. it does not show all my measures or named sets; actually it only shows the one which I deleted off the project as mentioned above.