- 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 Multidimensional
database, 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:

- 少兒人工智能趣味入門(mén):Scratch 3.0動(dòng)畫(huà)與游戲編程
- DevOps with Kubernetes
- 認(rèn)識(shí)編程:以Python語(yǔ)言講透編程的本質(zhì)
- Designing Hyper-V Solutions
- 精通API架構(gòu):設(shè)計(jì)、運(yùn)維與演進(jìn)
- Swift 3 New Features
- 數(shù)據(jù)結(jié)構(gòu)案例教程(C/C++版)
- JSP程序設(shè)計(jì)實(shí)例教程(第2版)
- UML2面向?qū)ο蠓治雠c設(shè)計(jì)(第2版)
- Java并發(fā)編程:核心方法與框架
- Sails.js Essentials
- OpenCV Android Programming By Example
- Clojure High Performance Programming(Second Edition)
- The Applied Data Science Workshop
- Natural Language Processing with Python Cookbook