Creating and importing into Decision Data Store Data Sets

5 Tasks

30 mins

Pega Platform '24.2

Pega Platform '24.1 Pega Platform '23

Visible to: All users

Beginner

Pega Platform '24.2

English

Scenario

In the Sample application, Sample-Data-Employees class is available for the exercise. The class contains the data structure for employee data.

Download the SampleEmployees data for the exercise, create a new Decision Data Store Data Set (DDS Data Set), and then complete the given tasks.

Use the following credentials to log in to the exercise system:

Role	User name	Password
System architect	SystemArchitect	rules

Your assignment consists of the following tasks:

Task 1: Download the CSV file to your local drive

The sampleemployees.zip file is available on the system through a binary file Rule. Download the file to your local drive.

Task 2: Create a new DDS Data Set

Create a new DDS Data Set in the Sample-Data-Employees class named EmployeeData.

Add the EmployeeDepartment and EmployeeID fields as keys.

Task 3: Import the data into the Decision Data Store Data Set

Use the downloaded ZIP file to import the records into the DDS Data Set.

Task 4: Preview the data for a specific key

Browse and review the data for the EmployeeDepartment Garden & Industrial.

Task 5: Preview the data for multiple keys

Add EmployeeID to the Data Set query, and preview the data for EmployeeDepartment Garden & Industrial and EmployeeID Employee209.

 

You must initiate your own Pega instance to complete this Challenge.

Initialization may take up to 5 minutes so please be patient.

• Log In

Challenge Walkthrough

Detailed Tasks

1 Download the CSV file to your local drive

1. Log in as the System Architect:
   1. In the User name field, enter SystemArchitect.
   2. In the Password field, enter rules.
2. In the header of Dev Studio, in the search field, enter SampleEmployees, and then click enter.
3. In the list of results, click Employees SampleEmployees ZIP.
   
4. On the Rule form, click Download file to download the file to your local drive.
   

2 Create a new DDS Data Set

1. In the navigation pane of Dev Studio, click App to open the Application Explorer.
2. In the Application Explorer, search for the Sample-Data-Employees class.
3. In the Application Explorer, right-click the Sample-Data-Employees class, then select Create > Data Model > Data Set.
4. On the Create Data Set tab, create a new Data Set:
   1. In the Label field, enter Employees.
   2. In the Type list, select Decision Data Store.
   3. In the upper-right corner, click Create and open.
5. In the Keys section, complete the following details:
   1. In the empty Field list, enter or select .EmployeeDepartment.
   2. Click Add key.
   3. In the empty Field list, enter or select .EmployeeID.
      Note: Once the keys are assigned, they cannot be changed. You must create a new DDS Data Set to add new keys or remove existing keys.
   4. In the upper-right corner, click Save.

6. In the Keys section, click Show details link to determine which Cassandra table the system creates for the DDS Data Set.
   

3 Import the data in the Decision Data Store Data Set

1. On the Data set: Employees tab, in the upper-right corner, click Actions > Import to import the data.
   1. In the Import Data Set dialog, click Choose File, then select the file you downloaded in Task 3.
      
   2. Click Import.
   3. Click Done.

4 Preview the data for a specific key

1. On the Data set: Employees tab, in the upper-right corner, click Actions > Run.
2. In the Run Data Set: Employees window, complete the following details:
   1. In the run context, in the Operation list, select Browse by keys.
   2. In the Key list, select EmployeeDepartment.
   3. In the Value field, enter Garden & Industrial.
   4. In the upper-right corner of the run context, click Run to view the run results. Note that the query returns five results.
      
   5. Close the Data Set Preview window.

5 Preview the data for multiple keys

1. On the Run Data Set: Colors window, click the Add key to add a new key:
   1. In the empty Key list, select EmployeeID.
   2. In the Value field, enter Employee209.
      
2. In the upper-right corner, click Actions > Run.
3. In the Run Data Set: Employees window, complete the following details:
   1. In the run context, in the Operation list, select Browse by keys.
   2. In the Key list, select EmployeeDepartment.
   3. In the Value field, enter Garden & Industrial.
4. In the upper-right corner of the run context, click Run to view the run results.
   Note that the results return the results for the combination of the EmployeeDepartment and EmployeeID keys.
   

---

This Challenge is to practice what you learned in the following Module:

• Data management using Data Sets v2

---

Available in the following mission:

• Decision Management Essentials v3