- Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
- Reza Rad
- 443字
- 2021-08-13 17:55:26
Time for action – processing the data
Deployment will load metadata from an existing Analysis Services project into the SSAS Server, but it won't load data. To load data, another step is required, which is called processing. As there are different requirements to load data, there are multiple types of processing. Sometimes, you just need to populate the changes, but in some cases, such as populating dimensions, you want to populate everything again. In this example, we will go through the processing options by performing the following steps:
- Open SQL Server Management Studio and connect to the Analysis Services instance.
- Expand the
Chapter 02 SSAS Multidimensionaldatabase, and then expand the dimensions. - Right-click on the Product dimension and click on Process.
- In the Process window, you can change the process options to Clear. Click on the Clear option to process and then view the product dimension in the browser; you will see an error message that states that the dimension doesn't contain any hierarchy . The following screenshot shows the Process Options menu:
- Process the Product dimension again but with the Process Full option. This time, you will see the product category hierarchy with all members.
- Right-click on the cube and then click on Process. You will see the processing options there as well. This shows that processing can be done in the cube or dimensions level.
What just happened?
As you've seen in this example, there are different kinds of processing; some of them are the same as dimensions and partitions. Some of them are only for one of the processing types. The following table (available at http://technet.microsoft.com/en-us/library/ms174774.aspx) provides an explanation of the most useful kinds of processing and the SSAS database object that they can be applied to:
The time taken for processing depends on the structure of data and constraints in the destination database and also depends on the quality of data in the source database; there might be occurrence of some errors. You can catch errors during the processing and do some error configuration. This configuration can be found in the Dimension Designer, cube designer, and also in the Process window, as shown in the next screenshot (by clicking on Change Settings). The next screenshot shows a sample of the Dimension key errors settings.
One of the reasons to use error configuration is to deal with errors that occur during processing. For example, you might want to catch errors such as key not found and log them, but you still to perform the processing. So, you can use error configuration to perform settings to cover that requirement. Take a look at the following screenshot, which shows the change settings:
- 解構(gòu)產(chǎn)品經(jīng)理：互聯(lián)網(wǎng)產(chǎn)品策劃入門寶典
- Web Application Development with R Using Shiny（Second Edition）
- Python高級編程
- 21天學(xué)通C++（第6版）
- Mastering KnockoutJS
- Learning ELK Stack
- QTP自動化測試進(jìn)階
- C# 8.0核心技術(shù)指南（原書第8版）
- Oracle 18c 必須掌握的新特性：管理與實戰(zhàn)
- Spring Boot實戰(zhàn)
- Django實戰(zhàn)：Python Web典型模塊與項目開發(fā)
- Cocos2d-x by Example：Beginner's Guide（Second Edition）
- Visual C++開發(fā)寶典
- 交互設(shè)計師成長手冊：從零開始學(xué)交互
- C/C++代碼調(diào)試的藝術(shù)