- Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
- Reza Rad
- 242字
- 2021-08-13 17:55:23
Time for action – modifying the measure properties
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:
What just happened?
You changed the display format of the measures by configuring the FormatString property. You can also change the AggregationFunction to Sum, Average, Count, and so on. Also, in this example, you saw a new browser for the Analysis Service cube.
Excel is a great tool for business users; it can connect to the SSAS cube and shows measures and dimension attributes as formatted. Business users are quite familiar with Excel because it can be easily found on every system that has Microsoft Office installed. Also, Excel has many features for filtering and charting, which makes it more comfortable for users to work with data.
- ClickHouse性能之巔：從架構設計解讀性能之謎
- Mastering NetBeans
- Android應用程序開發(fā)與典型案例
- C/C++常用算法手冊（第3版）
- Python程序設計案例教程
- Serverless架構
- Python算法從菜鳥到達人
- 青少年信息學競賽
- Learning R for Geospatial Analysis
- C#開發(fā)案例精粹
- Learning JavaScript Data Structures and Algorithms（Second Edition）
- ASP.NET 4.0 Web程序設計
- Learning D
- 百萬在線：大型游戲服務端開發(fā)
- Python滲透測試編程技術：方法與實踐（第2版）