OBIEE - biserverxmlgen

Bi Server Architecture With Client

About

Generates an XML from an existing RPD.

With the utility biserverxmlexec, you can generate it back as binary repository (rpd)

Syntax

bi-init must be first started to give the environment variable context

bi_init.sh # or bi_init.bat 
biserverxmlgen

And you will see the usage:

biserverxmlgen  [-P repository_password] -R repository_pathname {-O output_script_pathname | -D dire
ctory_name} [-8] [-M] [-N] [{-Q | -S}]

where:

  • -8 is for UTF-8
  • -M is for generating a MDS XUDML file
  • -D is for generating multiple MDS XUDML documents

Without the M and D flag, this utility will generate an XUDML file.

  • -N is for not generating upgrade id if you want to create a new repository without the old upgrade ids.
  • -Q is for generating script without security objects
  • -S is for generating script for only security objects

If you use both -Q and -S, the second option on the call command takes precedence, and the first is ignored.

  • -H Display this usage information and exit.
  • -? Display this usage information and exit.

Example

XUDML format

one XUDML file

OBIEE 11G - XUDML Format (Oracle BI Server XML API )

biserverxmlgen -P Admin123 -R "Exalytics.rpd" -O Xudml.xml

Output:

XUDML generation was successfull.

Example Output:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<Repository xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<DECLARE>
<Database name="WRITEBACK_COLUMN_NAMES" id="3023:300436" uid="4d5351d0-0c90-1000-8ca6-0a5088c60000" type="Oracle11g" dbName="Oracle 11g">
<Features>
<Feature name="LEFT_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="RIGHT_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="FULL_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="NESTED_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="UNION_SUPPORTED" value="true"/>
<!-- .......... -->

Generating one XUDML file without Upgrade Id for an import

For an import in order to generate a patch file that can be executed with biserverxmlcli

biserverxmlgen -P Admin123 -R "Exalytics.rpd" -O XUdml.xml -N -8

Output:

XUDML generation was successfull.

MDS XML format

OBIEE 11g - MDS XML (Metadata Service XML)

one MDS XML File

biserverxmlgen -P Admin123 -R "Exalytics.rpd" -O MdsXudml.xml -M

Output:

XUDML generation was successfull.

Example output:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<DECLARE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository/admin">
<Database mdsid="m4d5351d0-0c90-1000-8ca6-0a5088c60000" name="WRITEBACK_COLUMN_NAMES" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository" type="Oracle11g" dbName="Oracle 11g">
<Feature name="LEFT_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="RIGHT_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="FULL_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="NESTED_OUTER_JOIN_SUPPORTED" value="true"/>
<Feature name="UNION_SUPPORTED" value="true"/>
<Feature name="UNION_ALL_SUPPORTED" value="true"/>
<Feature name="COUNT_SUPPORTED" value="true"/>
<!-- ...-->

Generating multiple MDS XUDML documents

biserverxmlgen -P Admin123 -R "Exalytics.rpd" -D OutputDirectory

Output:

XUDML generation was successfull.





Discover More
Bi Server Architecture With Client
OBIEE 10G/11G - BI Server Utilities

OBIEE have several executables files which permit you to automate some actions. bi-init.cmd (or bi-init.sh on UNIX) To interact with the repository, the Oracle BI Server has two system management API:...
Bi Server Architecture With Client
OBIEE 11G - XUDML Format (Oracle BI Server XML API )

OBIEE provides utilities to create a generic, XML-based representation of the Oracle BI repository metadata knwon as XUDML file. This XML file version of the repository can be used to programmatically...
Bi Server Architecture With Client
OBIEE 11g - MDS XML (Metadata Service XML)

MDS XUDML is an XML format that is compatible with Oracle Metadata Services and that is supported for the Oracle BI repository. XUDML See Schema element files: File Description xudml_mds_admin.xsd...
Bi Server Architecture With Client
OBIS - (UDML, XML) API

API This section goes over the programmatically manipulation of the repository. The programmatic process is generally straight forward: you transform the binary repository to a text file representation...



Share this page:
Follow us:
Task Runner