18.6.4 Creating Dataset to View the Custom Attributes in Data Visualization

In order to view the extended custom attributes in a staging table and view their logical names, you can create a Dataset and generate reports in the Data Visualization using OAS interface.

Navigate to Report Configuration and click Refresh Metadata button before creating a Dataset in the Data Visualization

To create a dataset and view the custom attributes in staging tables in the Data Visualization canvas in AFCS, complete the following steps:

1. On the Home page, click the Navigator icon and then click Data.
   The Dataset page is displayed.
2. Click Create and select Dataset from the available list.
   The Create Dataset window is displayed with the list of available connections.
3. Double click on the Stage Connection and the New Dataset page is displayed.
4. From the LHS menu, double click on the Manual Query, the Manual Query button is displayed.
5. Double click on the Manual Query button, and enter the SQL query under the Statement window.
6. Click Get Preview Data to preview the data of the entered query.
7. Click Save and the Save Dataset As window is displayed.
8. Enter the Name and Descriptionof the dataset and click OK.
   You can view the list of extended columns in the staging table.