Use Self-Service Analytics

You can use self-service analytics to create datasets for reports.

In Oracle Analytics, you can upload data from a variety of sources (for example, spreadsheets, CSV files, and many databases) to your system, explore your data to find correlations, discover patterns, and see trends.

Use the Dataset editor to capture the analyzed data in datasets that include tables and joins. You can use these self-service datasets and data flows to generate online reports and offline reports (scheduled reports).

Note:

After you import a self-service dataset in Publisher, if you change the structure of the self-service dataset, you must manually edit and refresh theself-service dataset. You can’t import the expressions and user-calculated elements from a self-service dataset to a Publisher data model. You can’t link between datasets.

Make sure the JDBC connection to Oracle BI EE data source includes the BI Consumer role in the allowed roles list.

Create a Dataset Using a Self-Service Dataset

You can use self-service datasets that contain one or more tables to create datasets.

1. On the component pane of the data model editor, select Dataset and select DV Data.
   The Datasets tab lists all the self-service datasets.
2. In the Datasets tab, select the dataset you want to use for pixel-perfect reporting.
3. Select the columns of each table you want use in the dataset for reporting.
4. Click Next.
5. Enter a name for the dataset.
6. If you want to configure parameters, perform these steps for each parameter:
   1. Click Add Parameter.
   2. Select a column from the Column Name list.
   3. If you want to change the name of the parameter, edit the name in the Parameter field.
7. Click Finish.

Create a Dataset Using a Self-Service Data Flow

You can use self-service flows to create datasets.

You can't use these types of data flows to create datasets:

• Data flows created with the Save Model option.
• Data flows with branched datasets.

1. Select Datasets, click New Dataset in the Diagram tab, and then select DV Data.
2. In the Data Flows tab, select a data flow you want to use and click Next.
3. Enter a name for the dataset.
4. If you want to configure parameters, perform these steps for each parameter:
   1. Click Add Parameter.
   2. Select a column from the Column Name list.
   3. If you want to change the name of the parameter, edit the name in the Parameter field.
5. Click Finish.