Databases Reference
In-Depth Information
Figure 16-15
6. Press the F5 button on your keyboard to deploy the SSIS processing
package and make sure it executes correctly. If everything has been
specified correctly you will see successful completion of the SQL
Server Analysis Services Processing task and the Send Mail Suc-
cess tasks — also, these tasks will be highlighted in green indicating
the successful execution. Of course you do need appropriate priv-
ileges on the Analysis Services instance to perform these operations.
Loading Data into an Analysis Services Partition
Typically, the data from the transactional source database (production sys-
tem) is extracted, staged to some intermediate storage, and then undergoes
transformations before being stored in a data warehouse (flat file or relational
format). This data then needs to be propagated to the cube for analysis. Ana-
lysis Services has the ability to read data from various data sources from flat
files to various relational databases. One way to add new fact data to the
cube is to create new partitions that read data from the data sources. You can
use SSIS's Script task to create a new DDL, execute the DDL using the Ex-
ecute DDL task, and then process the partition using the Analysis Services
processing task. You can create a package that will integrate all these tasks.
Even though you can utilize these tasks to load fact data, it is not easy to load
Search WWH ::
Custom Search