Updating the Data Experience (CinchyDXD)

This page outlines Step 4 of Deploying CinchyDXD: Updating the Data Experience

Table of Contents

Table of Contents
Introduction
#1.-table-updates
#2.-query-updates

Introduction

There are a few updates that are required in the Data Experience that has been created in your source environment. You do not want to have to repeat the updates in both the source and target environments. The upcoming section will show how to update the data experience in the source environment so that you can then re-package and reinstall in the target environment.

1. Table Updates

1. Log back into your source environment using the following: URL: <cinchy source url> User ID: <source user id> Password: <source password>

2. Make the following changes to the Currency Exchange Rate table:

Column Details	Values
Column 1	Current Column Name Value = Currency 1 New Column NameValue = From Currency All other settings remain the same
Column 2	Current Column Name Value = Currency 2 New Column NameValue = To Currency All other settings remain the same

3. Save your changes before leaving the table.

2. Query Updates

1. Update the Currency Converter query to reflect column name changes that were made in the Table Updates section above (Image 1).

Image 1: Step 1

Be sure to update the @Currency_1 and @Currency_2 labels to better reflect the input fields

2. Test the query to validate that it is still functioning (Image 2 and 3).

Image 2: Step 2

Image 3: Step 2

3. Save your query.