Custom Report Window (Views tab)
On the Views tab, you can:
- Set the views used as data sets (Views used as data sets)
- Determine data links (Data links)
To set additional views, used as data sets, follow these steps:
- On the Custom Reports window, click the Views tab.
- In the "Views used as data sets" section click Add to add a new row to the Views list.
- In the "View Name" column, from the drop-down list, select a view. The drop-down list displays the available published data views.
In the "View Type" column, double-click the entry to make the cell editable, and select a view type from the drop-down list. You can only select one view as the main view. The other views are sub-report views.
- In the "Data Set Name" column, double-click the cell to make it editable, and enter the name of the data set to which this view should belong.
- In the "Data Set" Tag column, double-click the cell to make it editable, and enter the tag for the data set.
- To add another view, repeat steps 1 to 5.
You can enter any number of data views for a custom report and group them into data sets.
After you have specified the data views and grouped them into data sets, you can link one data set to another to extract related information from multiple sources.
For translation-related information about Oracle BI Publisher/Oracle Analytics Publisher Reports, see the Unifier General Administration Guide.
Note: For External Data Model based reports, you cannot add or remove views.
You can create only one link level; that is, you can create one "sub-link." You cannot create another link under a sub-link.
To determine data links, follow these steps:
- In the Data links section of the window, click Add to open the Add Link window.
- In the Source Data Set field, select the name of the data set you want to link to another set. The selection list shows the data sets you created in the upper section of the Views tab.
- In the Source Element Name field, select the name of the field on the source data set that you want to map to the target data set.
The element data type must match the data type of the target element; for example, you must match an integer to an integer, a string to a string.
- In the Target Data Set field, select the name of the data set the source data set should link to.
- In the Target Element field, select the name of the field on the target set that the source element field should map to.
- To add another link, click the Add button and repeat steps 2 to 5, or click OK to save the links the exit the Add Link window.
- Click Apply, and click OK to exit the Custom Report window.
Example for creating a data link:
Row | View Name | View Type | Data Set Name | Data Set Tag |
---|---|---|---|---|
0 | Invoices | Main View | inv | inv |
1 | InvoicesLI | Sub Report View | LineItem | LineItem |
At this point, set the relationship between the Main View and the Sub Report View that you have added.
- Go to the Data Links section and click Add.
- Link the ID field from the Invoices Data View to the RECORD_ID field from the Invoices Line Item Data View.
Example
Source Data Set: inv
Source Element Name: INV_ID
Target Data Set: LineItem
Target Element: INV_LI_RECORD_NO
- Click OK to add to add the link.
- Click Apply.
Last Published Tuesday, December 12, 2023