After modifying the dimension attribute's properties, it is time to change the measure's properties. Properties such as display format, display folder, and aggregation function can be changed in the Properties window. Perform the following steps:
In SSDT, go to the Cube designer, and in the Cube structure tab, select the Sales Amount measure. Change the FormatString property of this measure to Currency.
Select the Order Quantity measure and change FormatString of this measure to #,##.
Go to the Excel browser; there is an option to view the cube in Excel, and you need to click on Analyze in the Excel icon in the browser.
In the Excel browser, choose Sales Amount and Order Quantity, and from Order Date, choose Calendar Year as shown in the following screenshot:
