24 Edit Semantic Model Files Using Model Administration Tool
Administrators can use Model Administration Tool to edit semantic model files originally built with Oracle Analytics Server and upload the changes to Oracle Analytics Cloud. You can also use Model Administration Tool to create new semantic models for data sources not supported by Semantic Modeler. You can also use command line utilities on Linux to manage data models.
About Editing Semantic Models Using Model Administration Tool
Administrators can use Console to upload semantic models from Oracle Analytics Server to Oracle Analytics Cloud. You can also use command line utilities on Linux to upload and download semantic model files (you can't use Model Administration Tool graphical user-interface on Linux).
Prerequisites
After a semantic model is uploaded, semantic model developers can use Model Administration Tool to edit and deploy their updates to Oracle Analytics Cloud. You can also use Model Administration Tool to create new semantic models for data sources not supported by Semantic Modeler
-
Oracle Analytics Server
-
(On Windows) A Windows 64–bit machine on which to download Oracle Analytics Client Tools and run the Model Administration Tool. See Download and Install Oracle Analytics Client Tools.
Note:
Oracle publishes new Oracle Analytics Client Tools with each Oracle Analytics Cloud update. After Oracle updates your Oracle Analytics Cloud environment, you must always download and start using the latest Oracle Analytics Client Tools. -
A validated semantic model .rpd file.
-
Valid user credentials. A user in the Oracle Cloud identity management system associated with Oracle Analytics Cloud who has administrator permissions in Oracle Analytics Cloud (that is, a user with the BIServiceAdministrator application role).
Your Oracle Analytics Cloud uses one of these Oracle Cloud identity management systems:- Oracle Identity Cloud Service (IDCS): If your Oracle Analytics Cloud federates with Oracle Identity Cloud Service you must connect with Oracle Identity Cloud Service user credentials.
- Oracle Cloud Infrastructure Identity and Access Management (IAM) Identity Domains: If your Oracle Analytics Cloud uses an IAM identity domain for identity management, you must connect with identity domain user credentials.
If you're not sure, ask your cloud service administrator. See About Setting Up Users and Groups.
If Oracle Analytics Cloud uses an external identity provider such as Active Directory for Single Sign-on (SSO) and you try to connect with your SSO user credentials, you see the message "
Connection failed 401: Unauthorized
" when you try to connect. - Check with your cloud service administrator that the required port number is open (that is, port 443 for HTTPS access to Oracle Analytics Cloud, otherwise port 80 for HTTP access ).
Typical Workflow for Using Model Administration Tool to Edit Your Semantic Model
-
(On Windows) Upload your semantic model. See Upload Semantic Models from a .rpd File Using Console.
-
(On Windows) Edit your semantic model. See Edit a Semantic Model in the Cloud.
- (On Windows) Copy analyses and dashboards built in Oracle Analytics Server to Oracle Analytics Cloud. See Uploading Content from a Catalog Archive in Visualizing Data and Building Reports in Oracle Analytics Cloud.
- (On Linux) Use the command line tools
runcat.sh
anddatamodel.sh
to manage semantic models (you can't use Model Administration Tool graphical user-interface on Linux). See Using Oracle Analytics Client Tools on Linux.
Download and Install Oracle Analytics Client Tools
Download and install Oracle Analytics Client Tools to enable remote connections from reporting dashboards and analyses. In addition, you might use Model Administration Tool (one of the client tools available for Microsoft Windows) to edit a semantic model (.rpd file) that isn't supported by Semantic Modeler.
- On Windows, the software pack installs the graphical user-interface version of Model Administration Tool , as well as command line utilities such as runcat.cmd (for catalog management).
- On Linux, the software pack installs
runcat.sh
anddatamodel.sh
command line utilities.
Note:
Oracle updates Oracle Analytics Client Tools with each Oracle Analytics Cloud update. Make sure that you're using the latest update of Oracle Analytics Client Tools.- Navigate to the download page for Oracle Analytics Client Tools.
- Click the latest Oracle Analytics Client Tools <Month Year> Update link to display the Oracle Software Delivery Cloud page.
- Click the Platforms down arrow, click All, then click outside of the drop-down list or press Enter.
- In the Software column of the table, select the download pack for the platform you want.
- For Windows, select Oracle Analytics Client May2023-Win for (Microsoft Windows x64 (64-bit)), <Size in MB>.
- For Linux, select Oracle Analytics Client May2023-Linux for (Linux x86-64), <Size in MB>.
Make sure that other components are de-selected (for example, Data Gateway and Power BI Connector).
- Accept the Oracle Cloud Service License Agreement.
- Click Download to start Oracle Download Manager, and follow the on-screen instructions.
- When the download is complete, click Open Destination.
- Extract and run the Oracle installer from the downloaded ZIP file.
For example, extract and run the installer file
oac_client-<update ID>-win64.exe
, and follow the on-screen instructions.To start the tools on Windows, go to your Windows Start menu, click Oracle Analytics Client Tools, and then select the name of the tool you want to use. For example, to edit your semantic model, click Model Administration Tool.
On Linux, use the
runcat.sh
anddatamodel.sh
command line utilities. See Using Oracle Analytics Client Tools on Linux.
Connect to a Semantic Model in the Cloud
You must enter connection details for Oracle Analytics Cloud before you open, publish, or upload a semantic model to Oracle Analytics Cloud using Model Administration Tool.
Edit a Semantic Model in the Cloud
Use Model Administration Tool to edit a semantic model that you previously uploaded to Oracle Analytics Cloud.
-
Refresh – Use this option to refresh your semantic model with the latest updates. If another developer has modified the semantic model, then you’re prompted to initiate a merge.
-
Discard – Use this option to cancel any changes that you’ve made to the semantic model in the current session.
Upload a Semantic Model to the Cloud
You can use Model Administration Tool to upload a semantic model .rpd file to Oracle Analytics Cloud.
Note:
Administrators can also use the Console to upload semantic model .rpd files. See Upload Semantic Models from a .rpd File Using Console.- In Model Administration Tool, open your semantic model .rpd file.
- From the File menu, click Cloud, then click Upload.
- Enter connection information for Oracle Analytics Cloud.
-
Refresh – Use this option to refresh your semantic model with the latest updates. If another developer has modified the semantic model, then you’re prompted to initiate a merge.
-
Discard – Use this option to cancel any changes that you’ve made to the semantic model in the current session.
Connect to a Data Source Using a Console Connection
Administrators can define database connections for semantic models using the Console in Oracle Analytics Cloud. This includes databases such as Oracle Database Cloud Service, Oracle Autonomous Data Warehouse, and Oracle Autonomous Transaction Processing.
Connect to a Data Source Using a Data Connection
In Oracle Analytics Cloud, users with DV Content Author access can set up connections to a wide range of data sources, and make these data connections available to business modelers building semantic models in Model Administration Tool by setting a connection option called System Connection.
Working with Model Administration Tool
Use these options to manage and publish a semantic model using Model Administration Tool. Model Administration Tool runs on Windows (you can't use Model Administration Tool graphical user-interface on Linux).
When you connect to Oracle Analytics Cloud in Model Administration Tool, you must provide user credentials for a user in the Oracle Cloud identity management system associated with Oracle Analytics Cloud. You won't be able to sign in as a Single Sign-on user from a federated external identity management system. See Prerequisites.
Menu option | Use it to: |
---|---|
File, then Cloud, then Open |
Open a semantic model you uploaded to Oracle Analytics Cloud so you can edit it. |
File, then Cloud, then Publish |
Publish changes that you made to the data model. Users see the changes the next time they sign-in to Oracle Analytics Cloud. |
Using Oracle Analytics Client Tools on Linux
Administrators can manage semantic model files (RPD files) using command line utilities installed with Oracle Analytics Client Tools on Linux. (You can't use Model Administration Tool graphical user-interface on Linux.)
Once you install Oracle Analytics Client Tools Utilities on Linux, access these utilities in <client_install_folder>/bi/bitools/bin
.
runcat.sh
- Useruncat.sh
to manage Oracle Analytics catalogs. This utility supports on-line operations of the runcat utility (you can't use runcat.sh to extract a web catalog from a BAR file).To display online help, use
./runcat.sh -help
.datamodel.sh
- Usedatamodel.sh
to run these commands:listconnectionpool, updateconnectionpool, downloadrpd, uploadrpd
.To display online help, use
./datamodel.sh -h
.
Note: You need a local Oracle Identity Cloud Service user to use runcat.sh
and datamodel.sh
commands (you can't use a federated single-signon user).
Troubleshoot Issues with Model Administration Tool (Oracle Analytics Client Tools)
Here’s some tips on how to troubleshoot issues when you try to connect to Oracle Analytics Cloud from Model Administration Tool. Model Administration Tool is available with the Oracle Analytics Client Tools download.
Access these log files on your client machine:
-
BI_client_domain home\domains\bi\servers\obis1\logs\user_name_NQSAdminTool.log
-
BI_client_domain_home\domains\bi\clients\datamodel\logs\datamodel.log
This table describes some common connection issues and how you can resolve them.
Common Connection Issues | Cause and Resolution |
---|---|
|
The login credentials are invalid.
|
OR
|
This issue has multiple causes:
Use the default JDK key store located in:
|
|
This issue has multiple causes:
|
I can't use Model Administration Tool in SSL mode |
If the default security certificates don't work, import the server security certificates. For example, on the machine where you downloaded and installed Oracle Analytics Client Tools, you might use the Key and Certificate Management Tool (keytool) to execute these commands:
|