One of the sample Data Visualization projects demonstrates the Data Mashup capabilities of Oracle Business Intelligence (OBI) 12c. In order to use this sample, upload an additional data file for use as a data source.
Note: This Data Mashup sample is designed specifically to work with the sample Primavera Data Warehouse schema and is for demonstration purposes only.
To upload the Data Mashup sample spreadsheet, complete the following steps:
- Sign in to OBI with an account as a member of the WebLogic BIAdministrator group:
http://<server>:<port>/va
where
<server> is the server name or IP address of the server where OBI is installed and running.
<port> is the listening port number for OBI.
/va is the default context for the Data Visualization component of OBI 12c.
- At the top of the screen, click the Data Sources icon.
- At the upper right of the screen, click Add XSA.
- Click Select File.
- Go to <Primavera Analytics unzipped directory>\obi\12c\catalog\dv.
- Select sample_wo_list.xlsx.
- In the Upload a File form, click Add XSA.
- At the top of the screen, click the Home icon.
- At the left of the screen, under the Display menu, click VA Projects.
- Click the Data Mashup Example VA Project.
- At the upper left of the screen, click the Data Sources icon.
- At the lower left of the screen, click Source Diagram.
- In the pop-up window, click on the circle in the middle of the line linking the Primavera – Activity subject area and the sample_wo_list data sources.
- In the Connect Sources form:
- Leave the This connection will set to Extend a Dimension.
- Click Add Another Match.
- Under Primavera – Activity, click the Select Column drop-down menu.
- Click the Activity folder to expand it
- Click the General – (Activity) sub-folder to expand it.
- Select the Activity ID column.
- Click OK to connect the data sources.
- At the top right of the screen, click the Canvas Settings icon and select Refresh Data.