Some of the themes within the MVDEMO Sample Data Set are not configured properly for Oracle Business Intelligence 12c. In order to correct this, you will need to import the modified themes using Oracle Map Builder. Oracle Map Builder is a standalone application that allows you to create and manage the mapping metadata (about styles, themes, and base maps) that is stored in the database. For more information on Oracle Map Builder, see https://docs.oracle.com/middleware/1213/core/JIMPV/vis_mapbuilder.htm#JIMPV7000.
To import the modified themes for use with OBI 12c, complete the following steps:
- Open Oracle Map Builder by running the following command:
java –jar mapbuilder.jar
- In the top left section of the screen, click on the Database drop-down menu, and then select Load/Add/Remove.
- In the Load/Add/Remove Database Connections window, click Add.
- In the Add Connection form:
- In the Database drop-down menu, keep ORACLE selected.
- Enter a name in the Connection Name field.
- Enter the User and Password for the MVDEMO schema (for example, mvdemo/mvdemo).
- On the Basic tab, enter the Host, Port, and SID for the MVDEMO database instance.
- Click Test Connection to verify the connection parameters.
- If connection test is successful, click OK.
- Open the Tools menu, and select the Import Metadata menu item.
- Click the File button, and browse to <Primavera Analytics unzipped directory>\obi\12c\mapbuilder.
- Select PrimaveraAnalyticsThemes.dat and click Open.
- Check only the Themes and Overwrite metadata that exists options, ensure all other items are unchecked.
- Click OK to import the themes. Once import has completed, exit Oracle Map Builder.