8.2.9.2 Custom dataset creation

In order to view the extended custom attributes or entities in a staging or results table and view their logical names, user can create a Dataset and generate reports in the Data Visualization using Oracle Analytics interface using Create Dataset Option available on top right. But before that user will need to Refresh Views first.

Steps to Refresh the views for newly created catalog extensions via Reporting Object Publish window:

1. On the DFCS Home page, click the My Profile icon and select Administration.
2. Click Reporting Object Publish.
3. You will see the history of reporting objects publish.
4. Click Refresh Catalog Extensions which will refresh the reporting objects as per the catalog extension changes.

   (Button will be enabled only when there is catalog extension post last reporting object creation executed time. No of objects created, modified and total no of objects will be also be shown.)

Steps to create a dataset and view the custom attributes in staging tables in the Data Visualization canvas in DFCS, complete the following steps:

1. On the Home page, click the Create icon and then click Dataset.
2. The Dataset page is displayed.
   1. Click Create and select Dataset from the available list.

      The Create Dataset window is displayed with the list of available connections.

   2. Double click on the DS Connection and the New Dataset page is displayed.
   3. From the LHS menu, double click on the Manual Query, the Manual Query button is displayed.
   4. Double click on the Manual Query button, and enter the SQL query under the Statement window.
   5. Click Get Preview Data to preview the data of the entered query.
   6. Click Save and the Save Dataset As window is displayed.
   7. Enter the Name and Description of the dataset and click OK.

You can view the list of extended columns in the staging table.

Note:

Refer to “Data Visualization via Custom Dataset” section of this user guide , for further details about New Dataset creation.