官术网_书友最值得收藏!

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:

  1. Open SQL Server Management Studio and connect to the Analysis Services instance.
  2. Expand the Chapter 02 SSAS Multidimensional database, and then expand the dimensions.
  3. Right-click on the Product dimension and click on Process.
  4. 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:
    Time for action – processing the data
  5. Process the Product dimension again but with the Process Full option. This time, you will see the product category hierarchy with all members.
  6. 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:

What just happened?
主站蜘蛛池模板: 浑源县| 夏津县| 含山县| 枝江市| 东安县| 工布江达县| 祥云县| 平安县| 昌宁县| 洛浦县| 肥东县| 黄浦区| 梨树县| 阳城县| 朝阳区| 龙口市| 安龙县| 上林县| 阜阳市| 启东市| 中西区| 松滋市| 阿巴嘎旗| 运城市| 金堂县| 新巴尔虎右旗| 夏津县| 南皮县| 蓬溪县| 肥乡县| 江津市| 交口县| 定安县| 丰宁| 原阳县| 盐城市| 儋州市| 宜兰县| 友谊县| 高要市| 兴义市|