- 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.
- PHP動態網站程序設計
- TypeScript Blueprints
- Python自然語言處理實戰：核心技術與算法
- Raspberry Pi for Secret Agents（Third Edition）
- Scratch 3游戲與人工智能編程完全自學教程
- jQuery開發基礎教程
- Learning OpenStack Networking（Neutron）
- Spring+Spring MVC+MyBatis從零開始學
- 大話Java：程序設計從入門到精通
- 從Power BI到Analysis Services：企業級數據分析實戰
- 跟戴銘學iOS編程：理順核心知識點
- 深入理解Java虛擬機：JVM高級特性與最佳實踐
- Spark技術內幕：深入解析Spark內核架構設計與實現原理
- Android技術內幕（系統卷）
- 數據結構與算法詳解