Create the Data Warehouse

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The Business Intelligence Tools (BIT) in Speech Server are samples that illustrate how to build a data warehouse of large volumes of Speech Server data and Online Analytical Processing (OLAP) cubes for reporting on the data.

Creating the Data Warehouse

By default, the BIT PackageB_DW package creates a series of 24 partitions based on the start date provided as an input parameter. Each partition represents a time period of one month. Data is added to the partitions according to the start time of the Speech Server session in the source database.

Note

PackageB_DW creates all partitions on a single disk. To split partitions among multiple disks, the package must be manually edited to assign a location to each partition.

To set the start date, open PackageB_DW.xml and set the StartDate parameter to the beginning date of the time period required for the data warehouse.

To change the number of created partitions, open PackageB_DW.dtsx for editing and modify the WHILE loop control variable in the Partition Meta Data task such that the desired number of partitions are created. In the following code example, the integer sets the number of created partitions.

WHILE (@intI<=24)

Note

If the StartDate parameter is removed from the configuration file, the starting date defaults to October 1, 2004.

See Also

Other Resources

Management of Tuning Data
Speech Application Data Analysis
Build a Data Warehouse