Renaming Subject Area in Oracle Analytics

Amarpreet Nagra-Oracle

If you’re using the Semantic Modeler and would like to rename the subject areas in the report XML from an alternative name to a new name, you can leverage the following Python script. The script does these two things:

1. It generates an input XML file based on the semantic model provided during the execution. 
2. It then runs the runcat command to update the report XML with the new name.

Disclaimer - This script is provided as an example, and its use is at your discretion. Oracle cannot guarantee its execution or support its output in your environment.

Modify and Execute the Script

Disclaimer - This script is provided as an example, and its use is at your discretion. Oracle cannot guarantee its execution or support its output in your environment.

#location for runcat.sh/cmd

catalogPath='/u01/AdminTool/bi/bitools/bin'

#OAC URL WebSerivce URL - https://xxxx-yyyy-ia.analytics.ocp.oraclecloud.com/analytics-ws

oacURL="https://oac2-env-region.analytics.ocp.oraclecloud.com/analytics-ws"

#OAC LOGIN - details

userName="user.name@company.com"

password="Password"

#Provide a path for SME Zip file

smodel='/u01/dir/SME.zip'

#This is where SME will be extracted.

workDir='/u01/dir/WorkDir

Requirements:

• PYTHON 3.6
• Oracle Analytics Client Tools

Disclaimer - This script is provided as an example, and its use is at your discretion. Oracle cannot guarantee its execution or support its output in your environment.

renameSA.txt

Please check out the following blog for more detailed information on this topic.

https://blogs.oracle.com/analytics/post/renaming-subject-area-in-the-catalog