- 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.
- 手機安全和可信應用開發指南：TrustZone與OP-TEE技術詳解
- 極簡算法史：從數學到機器的故事
- 零基礎學Visual C++第3版
- 深度實踐OpenStack：基于Python的OpenStack組件開發
- SOA實踐
- .NET 4.0面向對象編程漫談：基礎篇
- OpenCV 3和Qt5計算機視覺應用開發
- JavaScript動態網頁開發詳解
- 深入淺出RxJS
- 深入分布式緩存：從原理到實踐
- Java EE企業級應用開發教程（Spring+Spring MVC+MyBatis）
- ASP.NET 4.0 Web程序設計
- SSH框架企業級應用實戰
- 黑莓(BlackBerry)開發從入門到精通
- Visual Basic 程序設計實踐教程