Database Reference
In-Depth Information
Using SQL Server Integration Services
to process Analysis Services objects
SQL Server Integration Services
(
SSIS
) is an enterprise-level data ETL tool, which
can be used for a multitude of purposes, including the processing of Analysis Services
objects. SSIS is a huge product in its own right and even the discussion of its capabil-
ities is well beyond the scope of this topic. In this section, you will learn how to create
a simple SSIS package that processes various SSAS objects. You could extend the
SSIS solution to include a variety of tasks, such as extraction of data from source sys-
tems, populating a staging area, populating a Star schema data warehouse, and so
on.
How to do it...
To create a SSIS package for processing SSAS objects, perform the following steps:
1. Open SSDT and navigate to
File
|
New Project
. Choose
Integration Ser-
vices Project
from the business intelligence templates and provide a descript-
ive name for the project.
2. Drag
Analysis Services Processing Task
from the SSIS toolbox to the pack-
age's
Control Flow
tab. Give the task a descriptive name, for example,
Pro-
cess Objects in Sample Database
.
3. Double-click on the task to open the
Analysis Services Processing Task
ed-
itor. Next navigate to the
Processing Settings
tab to choose objects to be
processed.
4. Once you configure a connection to your Analysis Services instance and spe-
cify the database, you can choose multiple cubes, measure groups, partitions,
and dimensions you wish to process.
5. When you click on the
Impact Analysis
button, SSIS provides you with the
list of objects which will be impacted by processing options you chose. For
example, fully-processing dimensions will cause partitions to become unpro-
cessed. You also have an option to check the impacted object in order to add
it to the list of objects, which will be processed by this task, as shown in the
following screenshot:
Search WWH ::
Custom Search