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

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?
主站蜘蛛池模板: 石渠县| 句容市| 荥阳市| 凭祥市| 琼结县| 格尔木市| 宜兰县| 河源市| 资溪县| 凤凰县| 隆安县| 尉犁县| 阿鲁科尔沁旗| 天气| 无极县| 大埔县| 观塘区| 迁安市| 杂多县| 通山县| 卓资县| 勃利县| 霍城县| 信丰县| 宁河县| 米脂县| 伊春市| 万安县| 花莲县| 沈丘县| 刚察县| 卫辉市| 卢湾区| 紫金县| 乌兰察布市| 拉萨市| 察哈| 合阳县| 神木县| 新蔡县| 福建省|