Optimizing Microsoft SQL Server Analysis Services: Optimize Query Performance with a Derived Measure

3. Click the store_cost column to select it, as depicted in Figure 15.

Figure 15: Select Store_Cost (Circled) …

4. Click OK to accept the selection, and to close the Insert Measure dialog.

The new measure appears in the tree, named Store Cost 1 by default (because a measure named Store Cost already exists in the cube), as shown in Figure 16.

Figure 16: The New Measure Appears …

5. Click the new Store Cost 1 measure to select it, if necessary.

We will now rename the measure, and then add the syntax to the Source Column property to enable the same logic in the measure that we saw in the original calculated measure, and which we have confirmed with management to be correct.

6. Expand the Properties pane that appears below the tree if required, by clicking Properties, as depicted in Figure 17.

Figure 17: Upward Arrow Indicates Properties Pane is Collapsed …

Continues…

Leave a comment

Your email address will not be published.