Saturday, June 11, 2005

Reflect latest data in Analysis Services

One of my favorite update in SQL Server 2000 is the Analysis Services, formerly known in SQL Server 7.0 as OLAP Services. Every SQL Server 2000 administrator should use Analysis Services but this portion of a data warehouse faces certain common operational issues. Analysis Services and its environment must be configured appropriately.

I saw this post recently and found it to be very helpful, as it shows the steps needed to update the cubes in Analysis Services:

When you enter new transactions in Microsoft Business Solutions - Great Plains, you must sometimes also include those transactions in the Microsoft SQL Server 2000 Analysis Services cubes. The "More Information" section describes how to update the cubes with the latest transaction data.

Before you update a cube, you must rerun the Data Transformation Services (DTS) packages that update the data warehouse. You must complete this process in SQL Server Enterprise Manager. To rerun the DTS packages, follow these steps.

Note These steps refer to the sample TWO company in Microsoft Great Plains.
  1. Click Start, click All Programs, click Microsoft SQL Server, and then click Enterprise Manager.
  2. Click the Great Plains server folder.
  3. In the Great Plains server folder, click Data Transformation Services, and then click Local Packages.
  4. Locate the MSGP_TWO_to_MSGPAnalysisCubesDW_Package_Master_8 master DTS package.

    Note Each company has a master DTS package.
  5. Right-click MSGP_TWO_to_MSGPAnalysisCubesDW_Package_Master_8, and then click Execute Package to process the package.

    Note Process time will vary based on the amount of data.
After you update the data warehouse, you must update the cubes. To update a cube, follow these steps:
  1. Click Start, click All Programs, click Microsoft SQL Server, click Analysis Services, and then click Analysis Manager.
  2. Expand MSGPAnalysisCubes.
  3. Click the Cubes folder, and then locate the cube that you want to update.
  4. Right-click the cube, and then click Process.
  5. Click to select the Full check box, the Refresh check box, or the Incremental check box. The check box that you select depends on the type of update that you want to perform.
To update all cubes, follow these steps:
  1. Click Start, click All Programs, click Microsoft SQL Server, click Analysis Server, and then click Analysis Manager.
  2. Right-click MSGPAnalysisCubes, and then click Process the Database.

    Note Process time will vary based on the amount of data.

1 comment:

Anonymous said...

If anyone needs construction sites ... Remodeling your home tips and more can be found at http://good-remodeling.com/wood.pl?expert=remodeling