ARCS Extract in OTBI

Select "Data model" from the 'New' drop-down menu.

The properties of the data model will be shown on the left-hand side of the window. We can customize the data model, for instance adding parameter selections.

Click on the "+" sign on the top-left corner in the 'Diagram' tab to create the new data set. Then select "SQL query". A window will pop-up to create the script.

For the data source, select "ApplicationDB_FSCM" and "Standard SQL" for Type of SQL selection. Name the data model the way you want.

For the ARCS profile extract, there are a lot of columns we need in order to build successful profiles in ARCS. But the most important columns that need to be focused are:

• Profile Segment 1
• Profile Segment 2
• Profile Segment 3
• Profile Segment 4
• Account Name
• Description

The other columns can be set as default.

Apply all the filters to take away the unwanted intersections to avoid them from showing up in the report. This step can be based on the mapping in Data Management. After that, click 'OK'.

Below are the tables showing all the columns needed for an ARCS extraction report, also the tables which contain the value and the key IDs used to extract data.

After completing the script, click on the save icon in the top-right corner, input the name, and select the folder you want to save it into.

Before we can start creating the report layout, we need to generate a set of sample data so that it can be used while building the report layout. Click on "Data" tab and select how many numbers of rows to display (there are options to show from 5 up to 200 rows). The purpose of this step is usually to validate the data. Click "View" to proceed and select the "Table View". Then click "Save As Sample Data" if this data set is okay and ready to build the report layout.

In the report editor, click on the "insert" tab, then drag and drop "Data Table" to the sheet. This will create a table area where you can place the columns.

Under the "Data Source" on the left-hand side, all columns built in the data model will show up. Drag and drop the columns to the table area and adjust the width to fit the page and content.