Scribd
Upload
6 views2 pages

Data Extraction from SQL Server Guide

This exercise involves extracting additional data from the Cronus SQL Server database into a staging database to enhance a cube with new dimensions. Participants will apply data selection rules to limit the extraction based on specific criteria and test these rules using the 'Preview Table' function. The exercise concludes with deploying and executing the project, followed by reviewing the staging database contents against the data source tables.

Uploaded by

kefey80397
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

Data Extraction from SQL Server Guide

This exercise involves extracting additional data from the Cronus SQL Server database into a staging database to enhance a cube with new dimensions. Participants will apply data selection rules to limit the extraction based on specific criteria and test these rules using the 'Preview Table' function. The exercise concludes with deploying and executing the project, followed by reviewing the staging database contents against the data source tables.

Uploaded by

kefey80397
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Exercise 3

Extraction

Description

In this exercise, we will extract additional data from the Cronus SQL Server database and
transfer it into the staging database. The additional data extracted will be used in a later
exercise to enhance the cube with additional dimensions. Further we will use data selection
rules to limit the extracted data by criteria.

After completing the exercise you will have

 Extracted additional data from the data source into the staging database
 Added a selection rule to limit the data extraction based on a criteria
 Deployed- and executed the project

Page 1 of 2
Tasks
1. Select the following additional data from the data source
Hint: When adding fields to already selected tables check ‘Show Only Active Tables’ box

Table Name Field Name


Country/Region Code
Name
Item Product Group Code
Sales Invoice Line Type

2. Add the following data selection rule on the data source

Table Name Data Selection Rule


Sales Invoice Line Type = 2 & Amount <> 0

3. Test the data selection rules using the ‘Preview Table’ function and the ‘Apply Rules’ button

4. Deselect the following field from the data source

Table Name Field Name


Sales Invoice Line Type

5. Test the data selection rules using the ‘Preview Table’ function and the ‘Apply Rules’ button
Notice how data selection rules can be applied on data source tables, even though they are not
extracted from the table

6. Deploy- and execute the project

7. Review the contents of the tables on the staging database, using the ‘Preview Table’ function
and compare it with the contents of the data source tables

Page 2 of 2

You might also like