DAX Calculations and Queries - SQL Server Analysis Services 2012 Cube Development - page 379

Product Standard
Cost:=SUM([ProductStandardCost])
Total Product
Cost:=SUM([TotalProductCost])
Sales Amount:=SUM([SalesAmount])
Tax Amt:=SUM([TaxAmt])
Freight Cost:=SUM([Freight])
10. Take a look at the columns in the table. We have key columns, which you
have hidden, and we have the base columns for measures, which you have
hidden. The remaining visible columns are not needed, so you will delete
them.
11. Delete each remaining column that is not hidden. Make sure that you don't
delete the key columns and numeric measure base columns that you hid
earlier. You can delete a column by selecting it and then pressing the Delete
key or by right-clicking on the column and choosing Delete Column from the
menu.
Note
As a rule, if you don't need a column from the source data, delete it. It's
easier to add a column later if you decide you need it than to have unne-
cessary data in the model, which can impact performance and memory.
12. To inspect measures, select the cell in the Calculation Pane below the table
grid.