Home > Working with Planning Projects > Building an Application > Building Application Models > Building A Cube Model > Measure Settings > Other Functions for Measures Editor

Other Functions for Measures Editor
Last Updated 2/22/2012 6:40 PM

 There are other functions you can do for the Measures :

Re-Ordering Measures - The order of the measures can be changed once they have been created by using the up and down arrow icons above the measures list.

Simply select the measure you want to move up and down in the order and then select either the up arrow to move the measure up or the down arrow to move the measure down.

Renaming Measures - To change a measure name, first select the measure to be renamed so that it is highlighted, then right click in the panel containing the list of measures and select Rename from the menu.
A pop-up will display the current measure name, which you can edit and then select  to save the renamed measure.

Removing Measures - To delete a measure, first select the measure to be removed so that it is highlighted, then right click in the panel containing the list of measures and select Remove from the menu.
A confirmation pop-up will appear (this is a safety feature) and by clicking , the measure will be deleted from your measures list.

Saving a copy of the Measures list and associated logic - Once you have created your Measures, you can save a copy of the Measures and the calculations to an external text file.

Just right click the mouse on the list of Measures and when the pop-up appears, select the option to Export to File.

A dialogue box will appear for you to provide the name of the file you wish to save to.



The Measures list and the logic will be saved in a comma delimited format, so you should add the .csv file extension to the name of the file you choose.

In the example below, we have chosen to save the file in the MyDocuments  folder as a file called ExpenseMeasures.csv.



The benefit of exporting a copy of the Measures list and Logic in this way is that should you need to build another model using the same logic, you can simply import from the saved file.

Importing the Measures List and Logic - Similarly, we can import a list of measures and calculations using the Import from File capability.

Once again, all we need to do is right click the mouse on the Measures list window and select Import from File, and when we are prompted for the file name, we enter the name of the file containing the Measure List and Logic.

You can import into an empty measures list or if you import into an existing measures list, the imported measures will overwrite any already existing measures.