Dimension Walkthrough

In this dimension walkthrough, you will learn how to create a dimension that connects a salesperson's id and a salesperson's name in TimeXtender Orchestration and Data Quality. This connection is made with the database AdventureWorks.

Create your dimension

1. Open TimeXtender Orchestration and Data Quality
2. On the left side, you see a tree list.
3. Expand the node General
4. Right-click the Dimensions node
5. Select New... and then Dimension

   

6. In the popup type Sales Persons

SQL query

Our dimension interface should now be open, so our next job is to create a SQL query that returns a row for all our salespersons, both their id as well as their name.

1. Select the data provider AdventureWorks
2. Paste the following SQL query into the textbox

   SELECT [BusinessEntityID] AS SalesPersonID
         ,[FirstName] + ' ' + [LastName] AS FullName
         ,[TerritoryName]
         ,[TerritoryGroup]
   FROM [Sales].[vSalesPerson]

3. Run the SQL query either by pressing F5 or clicking the run button

   

Business Key & Business Value

Next, we want to connect the ID and name of the salesperson together. We do this by setting the SalesPersonID column as our business key and the FullName column as our business value.

1. In the properties window on the right, select SalesPersonID as the business key
2. Select FullName as the business value

   

Now each time our dimension has been executed a connection is created between the business key column and the business value column.

Dimension Attributes

Dimension attributes are filters that allow the TimeXtender Orchestration and Data Quality portal to organize our business keys into a tree list. They are optional, but if you have access to columns such as salesperson‘s store, country or even continent, setting them as attributes can increase the dimension‘s readability.

1. In the properties window on the right, select TerritoryGroup as Attribute 1
2. Select TerritoryName as Attribute 2

   

Final Steps

Now the final step before our dimension is in production is to deploy it.

1. Save and click the Deploy button
2. If the Test environment is enabled, select the correct deploy environment
3. Write a comment detailing the changes being deployed
4. Make sure to check Sales Person in the popup and click Deploy