Skip Headers
Oracle® Fusion Middleware XML Schema Reference for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E23950-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 MDS XML Physical Elements

This chapter provides MDS XML reference information for physical elements. Physical elements typically correspond to objects in the Physical layer of the Oracle BI repository, or in other words, the objects that appear in the right-hand pane of the Oracle BI Administration Tool.

This chapter contains the following topics:

3.1 MDS XML Elements: Database

The database element corresponds to the database object in the Physical layer.

The database tag includes the following attributes:

Table 3-1 Database Tag Attributes

Attribute Name Description

type

The type of data source, such as XMLDirect or ODBC20.

dbFlag

Stores the value of the following options:

  • CRM metadata tables: For legacy Siebel Systems sources only. When selected, the Administration Tool import utility looks for the table definition in Oracle's Siebel CRM-specific tables.

  • Virtual Private Database: Identifies the physical database source as a virtual private database (VPD). When a VPD is used, returned data results are contingent on the user's authorization credentials. This option is used with the Security Sensitive option for session variables.

  • Allow populate queries by default: When selected, allows all users to execute POPULATE SQL. If you want most, but not all, users to be able to execute POPULATE SQL, select this option and then limit queries for specific users or groups.

  • Allow direct database requests by default: When selected, allows all users to execute physical queries. The Oracle BI Server will send unprocessed, user-entered, physical SQL directly to an underlying database. If you want most, but not all, users to be able to execute physical queries, select this option and then limit queries for specific users or groups.

containerRef

References the container for this database.

persistConnPoolRef

References the connection pool that is used as the persist connection pool, if one has been assigned. A persist connection pool is a database property that is used for specific types of queries (typically used to support Marketing queries).


The database tag includes the following child elements:

Table 3-2 Database Child Elements

Element Name Description

Features

Lists the SQL features for this database. Each feature is contained in a sub-element called Feature. This sub-element has two attributes:

  • name indicates the name of the feature, such as LEFT_OUTER_JOIN_SUPPORTED.

  • value indicates whether this feature is supported by the database, or provides the actual value of the feature (such as "0" for MAX_COLUMNS_IN_SELECT).

DisplayFolders

References any physical display folders that contain objects in this database. Physical display folders can be used to organize tables in a database. For example, all alias tables can be stored in a display folder called Alias, in addition to being present in the database.

Each display folder is contained in a sub-element called RefPhysicalDisplayFolder.

RefConnectionPools

References the connection pools for this database object.

Each connection pool is contained in a sub-element called RefConnectionPool.

Properties

Custom database properties for Oracle ADF Business Component data sources that are passed to the Administration Tool from Oracle ADF BI view objects.


Syntax

<Database …
     type=""
     dbFlag=""
     containerRef=""
     persistConnectionPoolRef="">
   <Description />
   <Features>
     <Feature name="" value=""/>
     <Feature name="" value=""/>
     ...
   </Features>
   <RefConnectionPools>
     <RefConnectionPool connectionPoolRef="" …/>
     <RefConnectionPool connectionPoolRef="" …/>
   </RefConnectionPools>
   <RefDisplayFolders>
     <RefPhysicalDisplayFolder physicalDisplayFolderRef="" …/>
     <RefPhysicalDisplayFolder physicalDisplayFolderRef="" …/>
   </RefDisplayFolders>
   <Properties>
     <PropertyGroup category="">
       <Property>
          <Name …/>
          <Value …/>
       </Property>
     </PropertyGroup>
   </Properties>
</Database>

Example

<Database mdsid="m80c882ea-0bcf-0000-714b-e31d00000000" 
   name="Loyalty Input Data Source"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository" 
   type="ODBC200">
   <Feature name="LEFT_OUTER_JOIN_SUPPORTED" value="true" /> 
   <Feature name="RIGHT_OUTER_JOIN_SUPPORTED" value="false" /> 
   <Feature name="FULL_OUTER_JOIN_SUPPORTED" value="false" /> 
   <Feature name="NESTED_OUTER_JOIN_SUPPORTED" value="false" /> 
   <Feature name="UNION_SUPPORTED" value="false" /> 
   <Feature name="UNION_ALL_SUPPORTED" value="false" /> 
   <Feature name="COUNT_SUPPORTED" value="true" /> 
   <Feature name="COUNT_DISTINCT_SUPPORTED" value="true" /> 
...
   <Feature name="SORT_ORDER_LOCALE" value="english-usa" /> 
   <Feature name="COMMENT_START" /> 
   <Feature name="COMMENT_END" /> 
   <RefConnectionPools>
     <RefConnectionPool refId="m80c882ea-0bcf-0000-714b-e31d00000000-m80c882ec-
        0bd5-0000-714b-e31d00000000"
       connectionPoolRef="/oracle/bi/server/base/ConnectionPool/Loyalty Input 
        Connection Pool_80c882ec-0bd5-0000-714b-e31d00000000.xml#m80c882ec-0bd5-
        0000-714b-e31d00000000" /> 
   </RefConnectionPools>
</Database>

3.2 MDS XML Elements: Physical Catalog

The physical catalog element corresponds to the physical catalog object in the Physical layer.

The physical catalog tag includes the following attributes:

Table 3-3 Physical Catalog Tag Attributes

Attribute Name Description

containerRef

References the database for this physical catalog.

dynamicNameRef

If a session variable is being used to specify the name of this physical catalog, this element references that session variable.


Syntax

<PhysicalCatalog …
   containerRef=""
   dynamicNameRef="">
   <Description />
</PhysicalCatalog>

Example

<PhysicalCatalog mdsid="m00238422-0bd1-0000-714b-e31d00000000" 
   name="Catalog" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository" 
   containerRef="/oracle/bi/server/base/Database/Forecasting Oracle Data Warehouse
    _00238415-0bcf-0000-714b-e31d00000000.xml#m00238415-0bcf-0000-714b-
    e31d00000000">
</PhysicalCatalog>

3.3 MDS XML Elements: Physical Schema

The physical schema element corresponds to the physical schema object in the Physical layer.

The physical schema tag includes the following attributes:

Table 3-4 Physical Catalog Tag Attributes

Attribute Name Description

containerRef

References the database for this physical schema.

dynamicNameRef

If a session variable is being used to specify the name of this physical schema, this element references that session variable.


Syntax

<Schema …>
   containerRef=""
   dynamicNameRef="">
   <Description />
</Schema>

Example

<Schema mdsid="m80d02084-0bd3-0000-714b-e31d00000000" 
   name="RTDUSER" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   containerRef="/oracle/bi/server/base/Database/RTD Reporting Database_80d02083-
    0bcf-0000-714b-e31d00000000.xml#m80d02083-0bcf-0000-714b-e31d00000000">
</Schema>

3.4 MDS XML Elements: Physical Display Folder

The physical display folder element corresponds to the physical display folder object in the Physical layer.

The physical display folder tag includes the following attributes:

Table 3-5 Physical Display Folder Tag Attributes

Attribute Name Description

databaseRef

References the database for this physical display folder.


The physical display folder tag includes the following child elements:

Table 3-6 Physical Display Folder Child Elements

Element Name Description

RefTables

References the physical tables that belong to this physical display folder.

Each physical table is contained in a sub-element called RefPhysicalTable.


Syntax

<PhysicalDispFolder … >
   databaseRef=""
   <Description />
   <RefTables>
     <RefPhysicalTable tableRef="" …/>
     <RefPhysicalTable tableRef="" …/>
   </RefTables>
</Schema>

Example

<PhysicalDisplayFolder mdsid="me40757e1-0bf1-1000-b290-0ae593200000" 
   name="Opaque Views" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   databaseRef="/oracle/bi/server/base/Database/SQLDB_Northwind_e4070ae5-0bf1-
    1000-b290-0ae593200000.xml#me4070ae5-0bf1-1000-b290-0ae593200000">
   <RefTables>
     <RefPhysicalTable refId="me40757e1-0bf1-1000-b290-0ae593200000-me4072f9e-
        0bf1-1000-b290-0ae593200000" 
       tableRef="/oracle/bi/server/base/PhysicalTable/Employees_Country_e4072f9e-
        0bf1-1000-b290-0ae593200000.xml#me4072f9e-0bf1-1000-b290-0ae593200000" /> 
     <RefPhysicalTable refId="me40757e1-0bf1-1000-b290-0ae593200000-me4072fc7-
        0bf1-1000-b290-0ae593200000" 
       tableRef="/oracle/bi/server/base/PhysicalTable/Population_e4072fc7-0bf1-
        1000-b290-0ae593200000.xml#me4072fc7-0bf1-1000-b290-0ae593200000" /> 
     <RefPhysicalTable refId="me40757e1-0bf1-1000-b290-0ae593200000-me4072fcc-
        0bf1-1000-b290-0ae593200000" 
       tableRef="/oracle/bi/server/base/PhysicalTable/Quarter_e4072fcc-0bf1-1000-
        b290-0ae593200000.xml#me4072fcc-0bf1-1000-b290-0ae593200000" /> 
     <RefPhysicalTable refId="me40757e1-0bf1-1000-b290-0ae593200000-me4072fa0-
        0bf1-1000-b290-0ae593200000" 
       tableRef="/oracle/bi/server/base/PhysicalTable/Year_e4072fa0-0bf1-1000-
        b290-0ae593200000.xml#me4072fa0-0bf1-1000-b290-0ae593200000" /> 
   </RefTables>
</PhysicalDisplayFolder>

3.5 MDS XML Elements: Physical Table

The physical table element corresponds to the physical table object in the Physical layer.

The physical table tag includes the following attributes:

Table 3-7 Physical Table Tag Attributes

Attribute Name Description

type

The type of physical table. Options are as follows:

  • select indicates that this physical table object is a SELECT statement.

  • sp indicates that this physical table is a stored procedure.

  • alias indicates that this physical table is an alias table. An alias table (alias) is a physical table that references a different physical table as its source.

  • none indicates that this physical table is a regular physical table.

isCacheable

If set to true, indicates that this table is included in the Oracle BI Server query cache.

CacheExpiry

How long table entries should persist in the query cache. A value of 0 indicates that cache entries do not expire.

isCacheEventTable

If set to true, indicates that this table has been registered as an Oracle BI Server event polling table.

isOverrideCacheProp

For alias tables only. If set to true, indicates that the alias table has its own cache properties that override the cache properties of the source table.

pollFreq

The polling frequency, in seconds. Only applies if this table is an Oracle BI Server event polling table. The default value is 3600 seconds.

x

The x coordinate of the table when it is shown in the physical diagram.

y

The y coordinate of the table when it is shown in the physical diagram.

rowCount

The latest number of rows retrieved for this physical table.

lastUpdated

The time at which row counts were last updated for this physical table.

uri

For XML data sources only. The resource identifier for the XML data source.

xslPath

For XML data sources only. An XSLT file contains formatting rules written according to the XSLT standard. It defines how an XML file may be transformed.

maxConn

For XML data sources only. The maximum number of connections allowed to the same URL from different users.

xmlRefreshInterval

For XML data sources only. The time interval after which the XML data source is queried again directly, rather than using results in cache.

scriptPath

For XML data sources only. The extended gateway script path.

hints

For Oracle Databases only. Lists any database hints, such as index hints or leading hints, that were specified for this physical table.

isExtGatewayInProcess

For XML data sources only. Indicates that this physical table is the extended gateway part of the process.

extGatewayDelimiter

For XML data sources only. The row delimiter used in the metadata import process, typically the second level element in the XML document.

isSysGen

If set to true, indicates that an internal utility has generated this physical table.

isDDLAggr

Indicates whether this physical table is an aggregate table.

isDeployedView

For relational databases only. If set to true, indicates that this physical table is a deployed (opaque) view. An opaque view is a Physical layer table that consists of a SELECT statement.

containerRef

References the database, schema, or physical catalog for this physical table.

aggrConnPoolRef

If this physical table is an aggregate table, this element references the connection pool used for the aggregate.

sourceTableRef

For alias tables only. References the physical table that is being used as the source for this alias table.

variableRef

If a session variable is being used to specify the name of this physical table, this element references that session variable.

memberKeyRef

Applies to parent-child relationship tables that support parent-child hierarchies on relational sources. The name of the column that uniquely identifies members of the parent-child relationship table.

parentKeyRef

The name of the column that contains the key of the parent or ancestor member. Applies to parent-child relationship tables that support parent-child hierarchies on relational sources.

distanceColumnRef

The name of the column that records the number of levels between the member and the ancestor. Applies to parent-child relationship tables that support parent-child hierarchies on relational sources.

leafColumnRef

The name of the column that indicates whether the member has no child members (1 if the member is a leaf and has no children, 0 if the member is not a leaf and has children). Applies to parent-child relationship tables that support parent-child hierarchies on relational sources.


The physical table tag includes the following child elements:

Table 3-8 Physical Table Child Elements

Element Name Description

DBMapItem

Stores the value of database-specific strings. The <DBMapItem> element contains a <name> attribute and a <Value> sub-element.

PhysicalColumn

Specifies the physical column that belongs to this physical table. For details, see Section 3.6, "MDS XML Elements: Physical Column."

PhysicalKey

References the physical columns in this physical table that make up the physical key.

Each physical column is referenced in a sub-element called RefColumns. For details, see Section 3.8, "MDS XML Elements: Physical Key."

PhysicalForeignKey

References the physical key in an external physical table and the physical columns in this physical table that together make up the physical foreign key.

Each physical column is referenced in a sub-element called RefColumns.

For details, see Section 3.9, "MDS XML Elements: Physical Foreign Key.".

XSLT

For Oracle web service data sources. XSLT stores the XSLT transformation to flatten the web service response into a tabular result set.

XSDSchema

For Oracle web service data sources. XSDSchema stores the XML schema describing the structure of the web service response.

Properties

Contains one or more Property sub-elements, each of which has attributes <name> and <value>. These attributes specify a name-value pair of properties for data source metadata.


Syntax

The syntax here includes summary child element entries for the physical column, physical key, and physical foreign key elements. The full syntax for each child element appears in the appropriate section listed in the following table:

Table 3-9 References to Child Elements of Physical Table Element

Child Element Entry Section Containing Child Element Syntax

PhysicalColumn

MDS XML Elements: Physical Column

PhysicalKey

MDS XML Elements: Physical Key

PhysicalForeignKey

MDS XML Elements: Physical Foreign Key


<PhysicalTable …
     type=""
     isCacheable=""
     cacheExpiry=""
     isCacheEventTable=""
     isOverrideCacheProp=""
     pollFreq=""
     x=""
     y=""
     rowCount=""
     lastUpdated=""
     uri=""
     xslPath=""
     maxConn=""
     xmlRefreshInterval=""
     scriptPath=""
     hints=""
     isExtGatewayInProcess=""
     extGatewayDelimiter=""
     isSysGen=""
     isDDLAggr=""
     containerRef=""
     aggrConnPoolRef=""
     sourceTableRef=""
     variableRef=""
     memberKeyRef=""
     parentKeyRef=""
     distanceColumnRef=""
     leafColumnRef="">
   <Description />
   <DBMapItem name="">
      <Value …/>
   </DBMapItem>
   <PhysicalColumn />
   <PhysicalKey />
   <PhysicalForeignKey />
   <XSLT />
   <XSDSchema />
   <Properties>
     <Property name="" value=""/>
     <Property name="" value=""/>
   </Properties>
</PhysicalTable>

Example

<PhysicalTable mdsid="m00226232-0bb9-0000-714b-e31d00000000"
   name="CONTACTS_PRODUCTS_NOT_ORDERED" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository"
   type="select"
   x="625" 
   y="376" 
   maxConn="0" 
   containerRef="/oracle/bi/server/base/Schema/dbo_00238426-0bd3-0000-714b-
    e31d00000000.xml#m00238426-0bd3-0000-714b-e31d00000000">
   <DBMapItem name="SQLServer70">
     <Value>
       <![CDATA[ 
          select distinct T10.ROW_WID AS CONTACT_WID, T11.ROW_WID AS PRODUCT_WID 
          from VALUEOF(OLAPTBO).W_PERSON_D T10, VALUEOF(OLAPTBO).W_PRODUCT_D T11
          where Not EXISTS ( 
          select * from VALUEOF(OLAPTBO).W_ORDERITEM_F T1 where T1.CONTACT_WID = 
          T10.ROW_WID and T1.PROD_WID = T11.ROW_WID)
          ]]> 
     </Value>
   </DBMapItem>
   <DBMapItem name="DefaultMulDB">
     <Value>
       <![CDATA[ 
          select distinct T10.ROW_WID AS CONTACT_WID, T11.ROW_WID AS PRODUCT_WID 
          from VALUEOF(OLAPTBO).W_PERSON_D T10, VALUEOF(OLAPTBO).W_PRODUCT_D T11
          where Not EXISTS ( 
          select * from VALUEOF(OLAPTBO).W_ORDERITEM_F T1 where T1.CONTACT_WID = 
          T10.ROW_WID and T1.PROD_WID = T11.ROW_WID)
          ]]> 
     </Value>
   </DBMapItem>
   <PhysicalColumn mdsid="m0022ba68-0bbb-0000-714b-e31d00000000" 
     name="CONTACT_WID" 
     dataType="INT" specialType="none">
   </PhysicalColumn>
   <PhysicalColumn mdsid="m0022ba69-0bbb-0000-714b-e31d00000000" 
     name="PRODUCT_WID" 
     dataType="INT" specialType="none">
   </PhysicalColumn>
   <PhysicalKey mdsid="m00238038-0bc0-0000-714b-e31d00000000" 
     name="CONTACT_PRODUCT_KEY">
     <RefColumns>
       <RefColumn refId="m00238038-0bc0-0000-714b-e31d00000000-m0022ba68-0bbb-
          0000-714b-e31d00000000"
         columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
          ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba68-0bbb-0000-
          714b-e31d00000000" /> 
       <RefColumn refId="m00238038-0bc0-0000-714b-e31d00000000-m0022ba69-0bbb-
          0000-714b-e31d00000000"
         columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
          ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba69-0bbb-0000-
          714b-e31d00000000" /> 
     </RefColumns>
   </PhysicalKey>
   <PhysicalForeignKey mdsid="m002377f8-0bbe-0000-714b-e31d00000000"
     name="CONTACTS_PRODUCTS_NOT_ORDERED_FKey"
     counterPartKeyRef="/oracle/bi/server/base/PhysicalTable/Dim_W_PARTY_PER_D_
      Contact_002261ab-0bb9-0000-714b-e31d00000000.xml#m00237fa7-0bc0-0000-714b-
      e31d00000000">
     <RefColumns>
       <RefColumn refId="m002377f8-0bbe-0000-714b-e31d00000000-m0022ba68-0bbb-
          0000-714b-e31d00000000"
         columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
          ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba68-0bbb-0000-
          714b-e31d00000000" /> 
     </RefColumns>
   </PhysicalForeignKey>
   <PhysicalForeignKey mdsid="m002377f9-0bbe-0000-714b-e31d00000000"
     name="CONTACTS_PRODUCTS_NOT_ORDERED_FKey1"
     counterPartKeyRef="/oracle/bi/server/base/PhysicalTable/Dim_W_PRODUCT_D_
      0022612d-0bb9-0000-714b-e31d00000000.xml#m00237f18-0bc0-0000-
      714b-e31d00000000">
     <RefColumns>
       <RefColumn refId="m002377f9-0bbe-0000-714b-e31d00000000-m0022ba69-0bbb-
          0000-714b-e31d00000000"
         columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
          ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba69-0bbb-0000-
          714b-e31d00000000" /> 
     </RefColumns>
   </PhysicalForeignKey>
</PhysicalTable>

3.6 MDS XML Elements: Physical Column

The physical column element corresponds to the physical column object in the Physical layer.

The physical column element is not a top-level element - it appears as a child element of the physical table element.

The physical column tag includes the following attributes:

Table 3-10 Physical Column Tag Attributes

Attribute Name Description

extName

  • The external name for the physical column. This attribute is required if the same name (such as STATE) is used in multiple hierarchies.

  • This attribute is optional for XML documents. For XML, the extName attribute stores the fully qualified name of a column.

dataType

The data type of the physical column, such as VARCHAR. This option is called Type in the Physical Column dialog in the Administration Tool.

nullable

If set to true, indicates that null values are allowed for the column. This allows null values to be returned to the user, which is expected with certain functions and with outer joins.

precision

The precision of the data type of the column.

scale

The scale of the data type of the column.

rowCount

The latest number of rows retrieved for this physical column.

lastUpdated

The time at which row counts were last updated for this physical column.

valueType

Applies to Siebel OM data sources only. Indicates the cardinality of the value of the column. Valid values include:

  • One to One (Default/Unknown/Single-valued)

  • Many to One (Picklist)

  • One to Many (Multi-valued)

  • Many to Many (Multi-valued)

mappedColumn

Applies to Siebel OM data sources only. The name of the mapped column. Corresponds to the field of the same name for the multi-valued group (MVG) business component.

MVLinkName

Applies to Siebel OM data sources only. The name of the link used in the Siebel business component.

specialType

Valid values are LUD or None. LUD stands for "Last Update Date."

This attribute is currently used only for ADF data sources. It is used to indicate that the column should be checked when performing ETL operations.

dynamicNameRef

If a session variable is being used to specify the name of this physical column, this element references that session variable.

sourceColumnRef

For physical columns in an alias table only. References the physical column that is being used as the source for this column.


The physical column tag includes the following child elements:

Table 3-11 Physical Column Child Elements

Element Name Description

Properties

Contains one or more Property sub-elements, each of which has attributes <name> and <value>. These attributes specify a name-value pair of properties for data source metadata.


Syntax

<PhysicalColumn …
     extName=""
     dataType=""
     length=""
     nullable=""
     precision=""
     scale=""
     rowCount=""
     lastUpdated=""
     valueType=""
     mappedColumn=""
     MVLinkName=""
     specialType=""
     dynamicNameRef=""
     sourceColumnRef="">
   <Description />
   <Properties>
     <Property name="" value=""/>
     <Property name="" value=""/>
   </Properties>
</PhysicalColumn>

Example

<PhysicalColumn mdsid="m80e86ae3-0bbb-0000-714b-e31d00000000"
   name="ReportDate"
   dataType="TIMESTAMP" scale="-127" specialType="none"
   sourceColumnRef="/oracle/bi/server/base/PhysicalTable/FscmTopModelAM.Gregorian
    CalendarAM.FndCalDay_80d8ff44-0bb9-0000-714b-e31d00000000.xml#m80d759cf-0bbb-
    0000-714b-e31d00000000">
</PhysicalColumn>

3.7 MDS XML Elements: Connection Pool

The connection pool element corresponds to the connection pool object in the Physical layer.

The connection pool tag includes the following attributes:

Table 3-12 Connection Pool Tag Attributes

Attribute Name Description

bulkInsertBufferSize

Used for limiting the number of bytes each time data is inserted in a database table. The value is given in kilobytes (KB).

transactionBoundary

Controls the batch size for an insert in a database table.

unicodeDB

This attribute is typically set to true when working with columns of an explicit Unicode data type, such as NCHAR, in an Unicode database.

tempTablePrefix

The first two characters in a temporary table name. The default value is TT.

tempTableOwner

Table owner name used to qualify a temporary table name in a SQL statement, for example to create the table owner.tablename.

tempTableDatabase

Database where the temporary table will be created. This property applies only to IBM OS/390, because IBM OS/390 requires the database name qualifier to be part of the CREATE TABLE statement.

tempTableSpace

Tablespace where the temporary table will be created. This property applies only to IBM OS/390, because IBM OS/390 requires the tablespace name qualifier to be part of the CREATE TABLE statement.

user

The user name for the data source.

password

The password for the data source. Note that passwords are encrypted.

timeout

The amount of time that a connection to the data source will remain open after a request completes. During this time, new requests use this connection rather than open a new one (up to the number specified for the maximum connections). The time is reset after each completed connection request.

If you set the timeout to 0 (the default), connection pooling is disabled. In other words, each connection to the data source terminates immediately when the request completes. Any new connections either use another connection pool or open a new connection.

maxConnDiff

The maximum number of total connections allowed to this connection pool across all users.

dataSource

The data source name that is configured to access the database to which you want to connect. The data source name must contain valid logon information for the data source.

reqQualifedTableName

If set to true, indicates that this database requires fully qualified table names. The fully qualified names are based on the physical object names in the repository.

isSharedLogin

If set to true, all users whose queries use the connection pool will access the underlying database using the same user name and password.

isConcurrentQueriesInConnection

An option that enables a single database connection to remain open for the specified time for use by future query requests. If you do not select this option, each query sent to the database opens a new connection.

In the Administration Tool, this option corresponds to a value of "selected" for Enable connection pooling in the General tab of the Connection Pool dialog.

isCloseAfterEveryRequest

If set to true, indicates that the connection pool gets closed after every query.

In the Administration Tool, this option corresponds to a value of "not selected" for Enable connection pooling in the General tab of the Connection Pool dialog.

isAsyncExecution

An option that indicates that the data source supports asynchronous queries.

executeOnCmd

A command that is to be executed by the Oracle BI Server each time a connection is made to the database. The command may be any command accepted by the database.

xslPath

For XML data sources only. An XSLT file contains formatting rules written according to the XSLT standard. It defines how an XML file may be transformed. Specifying the XSLT file in the connection pool applies it to all the XML physical tables in the connection pool. Used when outputType is set to XML.

maxConn

The maximum number of total connections allowed to this connection pool for a given user.

xmlRefreshInterval

For XML data sources only. The time interval after which the XML data source is queried again directly, rather than using results in cache.

scriptPath

The connection method Search script. This option is used for XML Server data sources.

outputType

For XML data sources only. The query output format (delimited, xml, or fixed).

In the Administration Tool, this option is called Query output format in the XML tab of the Connection Pool dialog.

If this option is not set, the query output format is assumed to be a custom format, and the value for convertScriptPath is used.

gwDelim

The delimiting characters for the query output format. Used when outputType is set to delimited.

xpath

An XPath expression is a simple XSLT transformation rule that fits into one line. Used when outputType is set to xml.

convertScriptPath

Used when outputType is not set. The path to the .exe file to be used to convert the query output to a custom output format (such as HTML).

ignoreFirstLine

If set to true, indicates that the first line of the output file is ignored.

xmlHeaderPath

The path to the header file, if any, used as a query input supplement. Used for XML Server data sources.

trailerPath

The path to the trailer file, if any, used as a query input supplement. Used for XML Server data sources.

supportParams

Indicates whether the data source supports parameters. If set to false, and the database features table supports parameters, special code executes that enables the Oracle BI Server to push filters (or calculations) with parameters to the database.

isolationLevel

For ODBC and DB2 gateways. Sets the transaction isolation level on each connection to the back-end database. The isolation level setting controls the default transaction locking behavior for all statements issued by a connection. Options are as follows:

  • default uses the default transaction locking behavior of the data source.

  • readCommitted specifies that shared locks are held while the data is read to avoid dirty reads.

  • readUncommitted implements dirty read (isolation level 0 locking). When this option is set, it is possible to read uncommitted or dirty data, change values in the data, and have rows appear or disappear in the data set before the end of the transaction.

  • repeatableRead places locks on all data that is used in a query, preventing other users from updating the data.

  • serializable places a range lock on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete.

xmlaInfo

The vendor-specific information used to connect to the multidimensional data source.

xmlaCatalog

The list of catalogs available. The cube tables correspond to the catalog you use in the connection pool.

xmlaUseSession

If set to true, causes queries go through a common session.

multiThreaded

If set to true, indicates that the connection pool supports multi-threading, or in other words, that one connection pool can support multiple queries. If this option is set to false, each query is tied to a single database connection.

type

The call interface type.

appServerName

The name of the ADF application server.

appServerPort

The port number of the ADF application server.

appID

The ADF application ID.

appEJBBean

The name of the ADF application Enterprise Java Bean.

javaHostServiceName

The name of the JavaHost service. The JavaHost is used as a connector between the Oracle BI Server and data sources that use Java, such as ADF.

isSiebelJDBSecured

For Siebel OM data sources only. Indicates whether the connection between the Oracle BI Server and the Siebel data source is encrypted.

csfKey

This attribute is not currently used.

isAW

This attribute is not currently used.

useCert

This attribute stands for "Use Certificate." It is used for ADF data sources and indicates whether to use a certificate when securing the connection.

wsServer

Specifies the Oracle database web service host name.

wsWSDL

Specifies the WSDL URL to describe the Oracle database web service.

databaseRef

References the database for this connection pool.

relationalConnectionPoolRef

This attribute is not used.

relationalDataFolderRef

This attribute is not used.

sqlBypassDBRef

For Oracle ADF data sources only. References the SQL Bypass database, if one has been specified.

The SQL Bypass feature directly queries the database so that aggregations and other transformations are pushed down where possible, reducing the amount of data streamed and worked on in Oracle Business Intelligence.


The connection pool tag includes the following child elements:

Table 3-13 Connection Pool Child Elements

Element Name Description

AfterQueryString

Contains a connection script that is executed after the query is run.

BeforeQueryString

Contains a connection script that is executed before the query is run.

PostConnectString

Contains SQL queries executed after the connection is closed.

PreDisconnectString

Contains SQL queries executed before the connection is established.


Syntax

<ConnectionPool …
     bulkInsertBufferSize=""
     transactionBoundary=""
     unicodeDB=""
     tempTablePrefix=""
     tempTableOwner=""
     tempTableDatabase=""
     tempTableSpace=""
     user=""
     password=""
     timeout=""
     maxConnDiff=""
     dataSource=""
     reqQualifedTableName=""
     isSharedLogin=""
     isConcurrentQueriesInConnection=""
     isCloseAfterEveryRequest=""
     isAsyncExecution=""
     executeOnCmd=""
     xslPath=""
     maxConn=""
     xmlRefreshInterval=""
     scriptPath=""
     outputType=""
     gwDelim=""
     xpath=""
     convertScriptPath=""
     ignoreFirstLine=""
     xmlHeaderPath=""
     trailerPath=""
     supportParams=""
     isolationLevel=""
     xmlaInfo=""
     xmlaCatalog=""
     xmlaUseSession=""
     multiThreaded=""
     type=""
     appServerName=""
     appServerPort=""
     appID=""
     appEJBBean=""
     javaHostServiceName=""
     isSiebelJDBSecured=""
     csfKey=""
     useCert=""
     wsServer=""
     wsWSDL=""
     databaseRef=""
     sqlBypassDBRef="">
   <Description /> 
   <AfterQueryString isEnabled="">
     <Value …/>
   </AfterQueryString>
   <BeforeQueryString isEnabled="">
     <Value …/>
   </BeforeQueryString>
   <PostConnectString isEnabled="">
     <Value …/>
   </PostConnectString>
   <PreDisconnectString isEnabled="">
     <Value …/>
   </PreDisconnectString>
</ConnectionPool>

Example

<ConnectionPool mdsid="m80b43a95-0bd5-0000-714b-e31d00000000" 
   name="Oracle EBS OLTP Connection Pool" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   user="VALUEOF(ORA_EBS_OLTP_USER)" 
   password="6C6F0BE01FC4111F3AC2236A364D912E0284EB262305E146621D44D6B80DC27D4E248
    07068A0EA49C11EFF4E9741BB7046FB2852F64F0B86F08378C4012BFA56769A9CF97FA4051F08C
    9679B3C5486E"
   timeout="300" 
   maxConnDiff="10" 
   maxConn="64" 
   dataSource="VALUEOF(ORA_EBS_OLTP_DSN)" 
   type="Default" 
   reqQualifedTableName="false" 
   isSharedLogin="true" 
   isConcurrentQueriesInConnection="false" 
   isCloseAfterEveryRequest="false" 
   outputType="xml" 
   ignoreFirstLine="false" 
   bulkInsertBufferSize="32768" 
   tempTablePrefix="TT" 
   transactionBoundary="10" 
   xmlaUseSession="false" 
   isolationLevel="readUncommitted" 
   isSiebelJDBSecured="false" 
   databaseRef="/oracle/bi/server/base/Database/Oracle EBS OLTP_80b43a93-0bcf-
    0000-714b-e31d00000000.xml#m80b43a93-0bcf-0000-714b-e31d00000000">
   <Description>
     <![CDATA[ 
        User Name is VALUEOF(ORACLE_OLTP_USER)
        Data source name: VALUEOF(ORA_EBS_OLTP_DSN) ]]> 
   </Description>
   <PostConnectString 
     isEnabled="true">
     <Value>
        <![CDATA[ call /* valueof(NQ_SESSION.ACF) */ APP_SESSION.validate_icx_
           session('valueof(NQ_SESSION.ICX_SESSION_COOKIE)') ]]> 
     </Value>
   </PostConnectString>
</ConnectionPool>

3.8 MDS XML Elements: Physical Key

The physical key element corresponds to the physical key object in the Physical layer.

The physical key element is not a top-level element - it appears as a child element of the physical table element.

The physical key tag includes the following child elements:

Table 3-14 Physical Key Child Elements

Element Name Description

RefColumns

References the column that defines this physical key.

The column is contained in a sub-element, either RefPhysicalColumn or RefCubeColumn.


The physical key element does not include any attributes.

Syntax

<PhysicalKey …>
   <Description />
   <RefColumns>
     <RefColumn columnRef="" …/>
     <RefColumn columnRef="" …/>
   </RefColumns>
</PhysicalKey>

Example

<PhysicalKey mdsid="m00238038-0bc0-0000-714b-e31d00000000" 
   name="CONTACT_PRODUCT_KEY">
   <RefColumns>
     <RefColumn refId="m00238038-0bc0-0000-714b-e31d00000000-m0022ba68-0bbb-0000-
        714b-e31d00000000"
       columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
        ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba68-0bbb-0000-
        714b-e31d00000000" /> 
     <RefColumn refId="m00238038-0bc0-0000-714b-e31d00000000-m0022ba69-0bbb-0000-
        714b-e31d00000000"
       columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
        ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba69-0bbb-0000-
        714b-e31d00000000" /> 
   </RefColumns>
</PhysicalKey>

3.9 MDS XML Elements: Physical Foreign Key

The physical foreign key element corresponds to the physical foreign key object in the Physical layer.

The physical foreign key element is not a top-level element - it appears as a child element of the physical table element.

The physical foreign key tag includes the following attributes:

Table 3-15 Physical Foreign Key Tag Attributes

Attribute Name Description

hints

For Oracle Databases only. Lists any database hints, such as index hints or leading hints, that were specified for this physical foreign key.

counterPartKeyRef

References the physical key in the primary key table, that matches the RefColumns of this foreign key.


The physical foreign key tag includes the following child elements:

Table 3-16 Physical Foreign Key Child Elements

Element Name Description

RefColumns

References the physical columns (in the physical table that contains the foreign key) that match counterPartKeyRef.

Each physical column is contained in a sub-element called either RefPhysicalColumn or RefCubeColumn.


Syntax

<PhysicalForeignKey …
     hints=""
     counterPartKeyRef="">
   <Description />
   <RefColumns>
     <RefColumn columnRef="" …/>
     <RefColumn columnRef="" …/>
   </RefColumns>
</PhysicalForeignKey>

Example

<PhysicalForeignKey mdsid="m002377f9-0bbe-0000-714b-e31d00000000"
   name="CONTACTS_PRODUCTS_NOT_ORDERED_FKey1"
   counterPartKeyRef="/oracle/bi/server/base/PhysicalTable/Dim_W_PRODUCT_D_
    0022612d-0bb9-0000-714b-e31d00000000.xml#m00237f18-0bc0-0000-
    714b-e31d00000000">
   <RefColumns>
     <RefColumn refId="m002377f9-0bbe-0000-714b-e31d00000000-m0022ba69-0bbb-0000-
        714b-e31d00000000"
       columnRef="/oracle/bi/server/base/PhysicalTable/CONTACTS_PRODUCTS_NOT_
        ORDERED_00226232-0bb9-0000-714b-e31d00000000.xml#m0022ba69-0bbb-0000-
        714b-e31d00000000" /> 
   </RefColumns>
</PhysicalForeignKey>

3.10 MDS XML Elements: Complex Join

The complex join element corresponds to the complex join object in the Physical layer.

The complex join tag includes the following attributes:

Table 3-17 Complex Join Tag Attributes

Attribute Name Description

hints

For Oracle Databases only. Lists any database hints, such as index hints or leading hints, that were specified for this complex join.

cardinality

Indicates the cardinality of the join. Valid values are: ONE TO ONE, ZERO OR ONE TO ONE, ONE TO ZERO OR ONE, ZERO OR ONE TO ZERO OR ONE, ONE TO MANY, ZERO OR ONE TO MANY, ZERO OR ONE TO MANY, MANY TO ONE, MANY TO ZERO OR ONE, or MANY TO MANY.

extName

The external name for the join.

table1Ref

References the first physical table of the join.

table2Ref

References the second physical table of the join.


The complex join tag includes the following child elements:

Table 3-18 Complex Join Child Elements

Element Name Description

Expr

Contains the expression that defines the relationship between the two tables.

ExternalExpr

Contains the external expression used for ADF Business Component data sources.


Syntax

<ComplexJoin …
     hints=""
     cardinality=""
     extName=""
     table1Ref=""
     table2Ref="">
   <Description />
   <Expr />
   <ExternalExpr />
</ComplexJoin>

Note:

Both of the summary syntax elements <Expr /> and <ExternalExpr /> have the following sub-elements:

<ExprText>...</ExprText>
<ExprTextDesc>...</ExprTextDesc>
<ObjectRefList>
  <RefObject objectRef=""/>
  <RefObject objectRef=""/>
</ObjectRefList>

Example

<ComplexJoin mdsid="m00238388-0bc4-0000-714b-e31d00000000" 
   name="W_ORG_D (Account)_W_PARTY_LOGIN" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   table1Ref="/oracle/bi/server/base/PhysicalTable/W_PARTY_LOGIN _u0040
    Account)_00226660-0bb9-0000-714b-e31d00000000.xml#m00226660-0bb9-0000-714b-
    e31d00000000"
   table2Ref="/oracle/bi/server/base/PhysicalTable/W_PARTY_D _u0040
    Account)_002266ad-0bb9-0000-714b-e31d00000000.xml#m002266ad-0bb9-0000-714b-
    e31d00000000">
   <Expr>
     <ExprText>
       <![CDATA[ "%1" = "%2" ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ "Forecasting Oracle Data Warehouse"."Catalog"."dbo"."W_PARTY_D
          (Account)"."VIS_PR_POS_ID" = "Forecasting Oracle Data Warehouse".
          "Catalog"."dbo"."W_PARTY_LOGIN (Account)"."PARTY_ID" ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m00238388-0bc4-0000-714b-e31d00000000-m00234fdf-0bbb-
          0000-714b-e31d00000000"
         objectTypeId="3003" 
         objectRef="/oracle/bi/server/base/PhysicalTable/W_PARTY_D _u0040
          Account)_002266ad-0bb9-0000-714b-e31d00000000.xml#m00234fdf-0bbb-0000-
          714b-e31d00000000" /> 
       <RefObject refId="m00238388-0bc4-0000-714b-e31d00000000-m00234624-0bbb-
          0000-714b-e31d00000000"
         objectTypeId="3003" 
         objectRef="/oracle/bi/server/base/PhysicalTable/W_PARTY_LOGIN _u0040
          Account)_00226660-0bb9-0000-714b-e31d00000000.xml#m00234624-0bbb-0000-
          714b-e31d00000000" /> 
     </ObjectRefList>
   </Expr>
</ComplexJoin>

3.11 MDS XML Elements: Cube Table

The cube table element corresponds to the physical cube table object in the Physical layer.

The cube table tag includes the following attributes:

Table 3-19 Cube Table Tag Attributes

Attribute Name Description

extName

The external name for the data source.

type

The type of physical cube table. Options are as follows:

  • select indicates that this physical table object is a SELECT statement.

  • sp indicates that this physical cube table is a stored procedure.

  • alias indicates that this physical cube table is an alias table to a logical table source.

  • none indicates that this physical cube table is a regular physical cube table.

isCacheable

If set to true, indicates that this table is included in the Oracle BI Server query cache.

CacheExpiry

How long table entries should persist in the query cache. A value of 0 indicates that cache entries do not expire.

isCacheEventTable

If set to true, indicates that this table has been registered as an Oracle BI Server event polling table.

pollFreq

The polling frequency, in seconds. Only applies if this table is an Oracle BI Server event polling table. The default value is 3600 seconds.

x

The x coordinate of the table when it is shown in the physical diagram.

y

The y coordinate of the table when it is shown in the physical diagram.

rowCount

The latest number of rows retrieved for this physical cube table.

lastUpdated

The time at which row counts were last updated for this physical cube table.

scriptPath

For XML data sources only. The extended gateway script path.

isSysGen

If set to true, indicates that an internal utility has generated this physical cube table.

isOverrideCacheProp

For alias tables only. If set to true, indicates that the alias table has its own cache properties that override the cache properties of the source table.

hints

This attribute is not used.

isDDLAggr

Indicates whether this cube table is an aggregate table.

memberReference

For Essbase data sources only. Indicates the cube property (for example, Member Name).

An Essbase cube can have multiple aliases, and the value of memberReference is one of the alias names. The query engine will generate a query against the alias set for memberReference.

dateFormat

For Essbase only. Defines the format of date member, for example, 'yyyy-MM-dd.' The value is automatically set during import.

isMemberAliasUnique

This is used for query performance. If you know that all the member names in your data source are unique, you can set it to true by selecting the option Use unqualified member name for better performance.

containerRef

References the database for this cube table.

aliasTableVarRef

For Essbase data sources only. Each AliasTableVar represents an Essbase alias table.


The cube table tag includes the following child elements:

Table 3-20 Cube Table Child Elements

Element Name Description

Alias

For Essbase data sources only. For any alias tables for this Essbase cube, lists the alias to use (such as default, LongNames, French, and so on).

DBMapItem

Stores the value of database-specific strings. The <DBMapItem> element contains a <name> attribute and a <Value> sub-element.

CubeVar

For SAP/BW data sources only. Cube variables are used as a means of parameterizing queries.

Each cube variable is contained in a sub-element called CubeVar. This sub-element has the following attributes:

  • name: Name of the cube variable.

  • caption: A description (label or caption) associated with the cube variable, mainly used for display purposes.

  • type: The type of cube variable (SAP_VAR_TYPE_MEMBER, SAP_VAR_TYPE_HIERARCHY, or SAP_VAR_TYPE_NUMERIC).

  • selectionType: The selection type of the cube variable, for cube variables of type SAP_VAR_TYPE_MEMBER (SAP_VAR_SEL_TYPE_VALUE, SAP_SEL_TYPE_INTERVAL, or SAP_VAR_SEL_TYPE_COMPLEX).

  • entryType: Indicates whether replacing variables is optional or mandatory. Values include SAP_VAR_INPUT_TYPE_OPTIONAL, SAP_VAR_INPUT_TYPE_MANDATORY, or SAP_VAR_INPUT_TYPE_MANDATORY_NOT_INITIAL.

  • refDimension: The reference dimension. This column contains a DIMENSION_UNIQUE_NAME for the parameter type SAP_VAR_TYPE_HIERARCHY.

  • refHierarchy: The reference hierarchy. This column contains a HIERARCHY_UNIQUE_NAME for the variable type SAP_VAR_TYPE_MEMBER.

  • defaultLow: Contains a default value for the variable, or is zero.

  • defaultHigh: Contains a default value for the variable, or is zero. This property is only important for variables with the selection type SAP_VAR_SEL_TYPE_INTERVAL and SAP_VAR_SEL_TYPE_SELECTION.

  • overrideLow: The default value for the cube variable (used if defaultLow is zero).

  • overrideHigh: The default value for the cube variable (used if defaultHigh is zero).

CubeColumn

Specifies the cube column that belongs to this cube table. For details, see Section 3.15, "MDS XML Elements: Cube Column."


Syntax

The syntax here includes the summary child element entry for the cube column element. The full syntax for the cube column element appears in Section 3.15, "MDS XML Elements: Cube Column."

<CubeTable …
     extName=""
     type=""
     isCacheable=""
     cacheExpiry=""
     isCacheEventTable=""
     pollFreq=""
     x=""
     y=""
     rowCount=""
     lastUpdated=""
     scriptPath=""
     isSysGen=""
     isOverrideCacheProp=""
     hints=""
     isDDLAggr=""
     memberReference=""
     dateFormat=""
     isMemberAliasUnique=""
     containerRef=""
     aliasTabVarRef="">
   <Description />
   <Alias name="" />
   <CubeVar />
   <DBMapItem name="">
       <Value …/>
   </DBMapItem>
   <CubeColumn />
</CubeTable>

Example

<CubeTable mdsid="me40756b1-0bf1-1000-b290-0ae593200000" 
   name="OpaqueSales" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   type="select" 
   extName="select { [Measures].[Unit Sales], [Measures].[Store Cost] } on 
    COLUMNS, { [Time].[Year].members } on ROWS from [Sales]" 
   isCacheable="false" 
   isMemberAliasUnique="true" 
   containerRef="/oracle/bi/server/base/Database/FoodMart_e4070ae8-0bf1-1000-
    b290-0ae593200000.xml#me4070ae8-0bf1-1000-b290-0ae593200000">
   <DBMapItem name="DefaultMulDB">
     <Value>
       <![CDATA[ select { [Measures].[Unit Sales], [Measures].[Store Cost] } on 
          COLUMNS, { [Time].[Year].members } on ROWS from [Sales] ]]> 
     </Value>
   </DBMapItem>
   <CubeColumn mdsid="me40756b2-0bf1-1000-b290-0ae593200000" 
     name="[Time].[Year]" 
     extName="[Time].[Year]" 
     dataType="VARCHAR" precision="4" nullable="true" dimPropType="none">
   </CubeColumn>
   <CubeColumn mdsid="me40756b3-0bf1-1000-b290-0ae593200000" 
     name="Unit Sales" 
     extName="Unit Sales" dataType="DOUBLE" nullable="true" dimPropType="none">
   </CubeColumn>
   <CubeColumn mdsid="me40756b4-0bf1-1000-b290-0ae593200000" 
     name="Store Cost" 
     extName="Store Cost" dataType="DOUBLE" nullable="true" dimPropType="none">
   </CubeColumn>
</CubeTable>

3.12 MDS XML Elements: Physical Dimension

The physical dimension element corresponds to the physical dimension object in the Physical layer.

The physical dimension tag includes the following attributes:

Table 3-21 Physical Dimension Tag Attributes

Attribute Name Description

defaultMember

The default member for this physical dimension.

cubeTableRef

References the cube table for this physical dimension.


The physical dimension tag includes the following child elements:

Table 3-22 Physical Dimension Child Elements

Element Name Description

RefUserAttributes

References the dimension properties for this physical dimension.

Each dimension property is contained in a sub-element called RefCubeColumn.

AlternateHierarchyName

For Essbase physical dimension objects, lists the names of any alternate hierarchies that belong to this dimension.


Syntax

<PhysicalDimension …
     defaultMember=""
     cubeTableRef="">
   <Description />
   <RefUserAttributes>
     <RefCubeColumn cubeColumnRef="" …/>
     <RefCubeColumn cubeColumnRef="" …/>
   </RefUserAttributes>
   <AlternateHierarchyName …/>
</PhysicalDimension>

Example

<PhysicalDimension mdsid="m80cb9c61-0bf8-0000-714b-e31d00000000" 
   name="Months" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   cubeTableRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-714b-
    e31d00000000.xml#m80cb9c63-0bdf-0000-714b-e31d00000000">
   <RefUserAttributes>
     <RefCubeColumn refId="m80cb9c61-0bf8-0000-714b-e31d00000000-m80cb9cce-0be3-
        0000-714b-e31d00000000" 
       cubeColumnRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-
        714b-e31d00000000.xml#m80cb9cce-0be3-0000-714b-e31d00000000" /> 
     <RefCubeColumn refId="m80cb9c61-0bf8-0000-714b-e31d00000000-m80cb9ccf-0be3-
        0000-714b-e31d00000000" 
       cubeColumnRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-
        714b-e31d00000000.xml#m80cb9ccf-0be3-0000-714b-e31d00000000" /> 
   </RefUserAttributes>
   <AlternateHierarchyName>
     <![CDATA[ Calendar ]]> 
   </AlternateHierarchyName>
   <AlternateHierarchyName>
     <![CDATA[ Fiscal ]]> 
   </AlternateHierarchyName>
</PhysicalDimension>

3.13 MDS XML Elements: Physical Hierarchy

The physical hierarchy element corresponds to the physical hierarchy object in the Physical layer.

The physical hierarchy tag includes the following attributes:

Table 3-23 Physical Hierarchy Tag Attributes

Attribute Name Description

memberType

Values are Unknown, Regular, All, Formula, Measure. Default value is Unknown.

extName

The external name for the physical hierarchy.

type

The type of physical hierarchy. Options include FULLY BALANCED, UNBALANCED, RAGGED BALANCED, and NETWORK.

This option corresponds to the Hierarchy Type option in the Physical Hierarchy dialog in the Administration Tool.

dimType

The dimension type (for example, Measure Dimension) for the dimension to which this hierarchy belongs.

rowCount

The latest number of rows retrieved for this physical hierarchy.

isTimeDim

If set to true, indicates that this physical dimension is a time dimension.

dimUniqueName

The name of the dimension to which this hierarchy belongs.

isMemberAliasUnique

Indicates whether member names (including aliases) are unique in a given hierarchy so that the Oracle BI Server can take advantage of specific MDX syntax to optimize performance.

This option corresponds to the Use unqualified member name for better performance option in the Physical Hierarchy dialog in the Administration Tool.

cubeTableRef

References the cube table for this physical hierarchy.

dimensionRef

References the physical dimension for this physical hierarchy.

memberKeyRef

For parent-child (value) hierarchies. References the cube column that is the member key for this hierarchy.

parentKeyRef

For parent-child (value) hierarchies. References the cube column that is the parent key for this hierarchy.


The physical hierarchy tag includes the following child elements:

Table 3-24 Physical Hierarchy Child Elements

Element Name Description

RefColumns

References the set of cube columns that belong to this physical hierarchy.

Each cube column is contained in a sub-element called RefCubeColumn.

PhysicalLevel

For level-based hierarchies. References the set of physical levels that belong to this physical hierarchy.

Each level is contained in a sub-element called RefPhysical Level.

For more details, see Section 3.14, "MDS XML Elements: Physical Level."


Syntax

The syntax here includes the summary child element entry for the physical level element. The full syntax for the physical level element appears in Section 3.14, "MDS XML Elements: Physical Level."

<PhysicalHierarchy …
     memberType=""
     extName=""
     type=""
     dimType=""
     rowCount=""
     isTimeDim=""
     dimUniqueName=""
     isMemberAliasUnique=""
     cubeTableRef=""
     dimensionRef=""
     memberKeyRef=""
     parentKeyRef="">
   <Description />
   <RefColumns>
     <RefCubeColumn cubeColumnRef="" …/>
     <RefCubeColumn cubeColumnRef="" …/>
   </RefColumns>
   <PhysicalLevel />
</PhysicalHierarchy>

Example

<PhysicalHierarchy mdsid="m80cb9c58-0be1-0000-714b-e31d00000000" 
   name="Employees" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   memberType="all" 
   extName="Employees" 
   type="VALUE" 
   dimType="Other" 
   dimUniqueName="Employees" 
   cubeTableRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-714b-
    e31d00000000.xml#m80cb9c63-0bdf-0000-714b-e31d00000000" 
   dimensionRef="/oracle/bi/server/base/PhysicalDimension/Employees_80cb9c5d-0bf8-
    0000-714b-e31d00000000.xml#m80cb9c5d-0bf8-0000-714b-e31d00000000" 
   memberKeyRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-714b-
    e31d00000000.xml#m80cb9c9c-0be3-0000-714b-e31d00000000" 
   parentKeyRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-714b-
    e31d00000000.xml#m80cb9cda-0be3-0000-714b-e31d00000000">
   <RefColumns>
     <RefCubeColumn refId="m80cb9c58-0be1-0000-714b-e31d00000000-m80cb9c9c-0be3-
        0000-714b-e31d00000000" 
       cubeColumnRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-
        714b-e31d00000000.xml#m80cb9c9c-0be3-0000-714b-e31d00000000" /> 
     <RefCubeColumn refId="m80cb9c58-0be1-0000-714b-e31d00000000-m80cb9c9e-0be3-
        0000-714b-e31d00000000" 
       cubeColumnRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-
        714b-e31d00000000.xml#m80cb9c9e-0be3-0000-714b-e31d00000000" /> 
     <RefCubeColumn refId="m80cb9c58-0be1-0000-714b-e31d00000000-m80cb9c9f-0be3-
        0000-714b-e31d00000000" 
       cubeColumnRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-
        714b-e31d00000000.xml#m80cb9c9f-0be3-0000-714b-e31d00000000" /> 
     <RefCubeColumn refId="m80cb9c58-0be1-0000-714b-e31d00000000-m80cb9cda-0be3-
        0000-714b-e31d00000000" 
       cubeColumnRef="/oracle/bi/server/base/CubeTable/Sample_80cb9c63-0bdf-0000-
        714b-e31d00000000.xml#m80cb9cda-0be3-0000-714b-e31d00000000" /> 
   </RefColumns>
   <PhysicalLevel mdsid="m80cb9d03-0be5-0000-714b-e31d00000000" 
      name="All Employees" 
      levelNum="0" 
      extName="All Employees" 
      levelKeyRef="/oracle/bi/server/base/CubeTable/Sample80cb9c63-0bdf-0000-714b-
       e31d00000000.xml#m80cb9c8d-0be3-0000-714b-e31d00000000">
   </PhysicalLevel>
   <PhysicalLevel mdsid="m80cb9d04-0be5-0000-714b-e31d00000000" 
      name="Employee L1" 
      levelNum="1" 
      extName="Employee L1" 
      levelKeyRef="/oracle/bi/server/base/CubeTable/Sample80cb9c63-0bdf-0000-714b-
       e31d00000000.xml#m80cb9c90-0be3-0000-714b-e31d00000000">
   </PhysicalLevel>
   <PhysicalLevel mdsid="m80cb9d05-0be5-0000-714b-e31d00000000" 
      name="Employee L2" 
      levelNum="2" 
      extName="Employee L2" 
      levelKeyRef="/oracle/bi/server/base/CubeTable/Sample80cb9c63-0bdf-0000-714b-
       e31d00000000.xml#m80cb9c94-0be3-0000-714b-e31d00000000">
   </PhysicalLevel>
   <PhysicalLevel mdsid="m80cb9d06-0be5-0000-714b-e31d00000000" 
      name="Employee L3" 
      levelNum="3" 
      extName="Employee L3" 
      levelKeyRef="/oracle/bi/server/base/CubeTable/Sample80cb9c63-0bdf-0000-714b-
       e31d00000000.xml#m80cb9c98-0be3-0000-714b-e31d00000000">
   </PhysicalLevel>
   <PhysicalLevel mdsid="m80cb9d07-0be5-0000-714b-e31d00000000" 
      name="Employee Names" 
      levelNum="4" 
      extName="Employee Names" 
      levelKeyRef="/oracle/bi/server/base/CubeTable/Sample80cb9c63-0bdf-0000-714b-
       e31d00000000.xml#m80cb9c9c-0be3-0000-714b-e31d00000000">
   </PhysicalLevel>
</PhysicalHierarchy>

3.14 MDS XML Elements: Physical Level

The physical level element corresponds to the hierarchical levels for a physical cube table object in the Physical layer.

The physical level element is not a top-level element - it appears as a child element of the physical hierarchy element.

The physical level tag includes the following attributes:

Table 3-25 Physical Level Tag Attributes

Attribute Name Description

levelNum

Identifies the order of this physical level in the hierarchy.

extName

Fully qualified name for the level.

rowCount

The latest number of rows retrieved for this physical level.

levelKeyRef

References the key column for this physical level.


Syntax

<PhysicalLevel …
     levelNumber=""
     extName=""
     rowCount=""
     levelKeyRef="">
   <Description />
</PhysicalLevel>

Example

<PhysicalLevel mdsid="m80cb9d03-0be5-0000-714b-e31d00000000" 
   name="All Employees"
   levelNum="0" 
   extName="All Employees" 
   levelKeyRef="/oracle/bi/server/base/CubeTable/Sample80cb9c63-0bdf-0000-714b-
    e31d00000000.xml#m80cb9c8d-0be3-0000-714b-e31d00000000">
</PhysicalLevel>

3.15 MDS XML Elements: Cube Column

The cube column element corresponds to the cube column of a physical cube object in the Physical layer.

The cube column element is not a top-level element - it appears as a child element of the cube table element.

The cube column tag includes the following attributes:

Table 3-26 Cube Column Tag Attributes

Attribute Name Description

extName

  • The external name for the cube column. This attribute is required if the same name (such as STATE) is used in multiple hierarchies.

aggrType

The type of aggregation on the column, if any.

dataType

The data type of the cube column, such as VARCHAR.

nullable

If set to true, indicates that null values are allowed for the column. This allows null values to be returned to the user, which is expected with certain functions and with outer joins.

precision

The precision of the data type of the cube column.

scale

The scale of the data type of the column.

rowCount

The latest number of rows retrieved for this cube column.

lastUpdated

The time at which row counts were last updated for this cube column.

dimPropType

For Essbase dimensional columns only. Indicates the property type of the cube column. Valid values are:

  • uda: User Defined Attribute (UDA) type.

  • memnor: Memnor type, used for outline sorts in the logical layer. Imported at the lowest level of each dimension. Called Outline Sort in the Administration Tool.

  • attribute: Attribute type, for attribute dimensions.

  • other: The type is different than those listed, or unknown.

  • none: The column does not have a property type. Note that this type is mapped to Member Alias in the Administration Tool.

  • ancestorRef: References the ancestor of a dimension.

  • memberKey: The column is a member key.

  • levelNumber: The column is the lowest member of the hierarchy. Called Leaf in the Administration Tool.

  • genNumber: The column is the root member of the hierarchy. Called Root in the Administration Tool.

  • parentRef: References the parent of a dimension.

attributeHierarchyRef

References the physical hierarchy to which this cube column belongs.

physicalLevelRef

References the physical level to which this cube column belongs.


Syntax

<CubeColumn …
     extName=""
     aggrType=""
     dataType=""
     nullable=""
     precision=""
     rowCount=""
     lastUpdated=""
     scale="">
     dimPropType=""
     attributeHierarchyRef=""
     physicalLevelRef="">
   <Description />
</CubeColumn>

Example

<CubeColumn mdsid="m80cbf77f-0be3-0000-714b-e31d00000000"
   name="Product Types - Ancestor Ref"
   extName="Ancestor_Names"
   dataType="VARCHAR" precision="128" dimPropType="ancestorRef"
   physicalLevelRef="/oracle/bi/server/base/PhysicalHierarchy/Products_80cbf730-
    0be1-0000-714b-e31d00000000.xml#m80cbf7ef-0be5-0000-714b-e31d00000000">
</CubeColumn>

3.16 MDS XML Elements: Analytic Workspace

The Analytic Workspace element corresponds to the Oracle OLAP Analytic Workspace (AW) object in the Physical layer.

The Analytic Workspace tag includes the following attributes:

Table 3-27 Analytic Workspace Tag Attributes

Attribute Name Description

version

The version of the Analytic Workspace.

containerRef

References the physical catalog for this Analytic Workspace.

dynamicNameRef

If a session variable is being used to specify the name of this Analytic Workspace, this element references that session variable.


Syntax

<AnalyticWorkspace …
     version=""
     containerRef=""
     dynamicNameRef="">
   <Description />
</AnalyticWorkspace>

Example

<AnalyticWorkspace mdsid="m000000ae-0be9-0000-714b-e31d00000000" 
   name="GLOBAL" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository"
   version="10" 
   containerRef="/oracle/bi/server/base/PhysicalCatalog/GLOBAL_000000ad-0bd1-0000-
    714b-e31d00000000.xml#m000000ad-0bd1-0000-714b-e31d00000000">
</AnalyticWorkspace>

3.17 MDS XML Elements: AW Cube

The AW cube element corresponds to the Oracle OLAP cube object in the Physical layer.

The AW cube tag includes the following attributes:

Table 3-28 AW Cube Tag Attributes

Attribute Name Description

extName

The physical name that is used when referencing the cube in physical SQL queries.

isCacheable

If set to true, indicates that this table is included in the Oracle BI Server query cache.

CacheExpiry

How long table entries should persist in the query cache. A value of 0 indicates that cache entries do not expire.

isCacheEventTable

If set to true, indicates that this table has been registered as an Oracle BI Server event polling table.

pollFreq

The polling frequency, in seconds. Only applies if this table is an Oracle BI Server event polling table. The default value is 3600 seconds.

x

The x coordinate of the table when it is shown in the physical diagram.

y

The y coordinate of the table when it is shown in the physical diagram.

rowCount

The latest number of rows retrieved for this Oracle OLAP cube.

lastUpdated

The time at which row counts were last updated for this Oracle OLAP cube.

hints

For Oracle Databases only. Lists any database hints, such as index hints or leading hints, that were specified for this physical table.

isExtGatewayInProcess

For XML data sources only. Indicates that this physical table is the extended gateway part of the process.

isOverrideCacheProperties

For alias tables only. If set to true, indicates that the alias table has its own cache properties that override the cache properties of the source table.

isDDLAggr

Indicates whether this Oracle OLAP cube is an aggregate table.

isSysGen

If set to true, indicates that an internal utility has generated this Oracle OLAP cube.

isPartitioned

If set to true, indicates that the cube is partitioned by one or more dimensions.

densityStatus

For Oracle OLAP 10g cubes only. Indicates whether the cube is dense or sparse. If neither dense nor sparse is specified, the Oracle BI Server assumes the data is sparse.

Valid values are dense, sparse, and unknown.

materializationStatus

For Oracle OLAP 10g cubes only. Indicates whether the cube is fully materialized.

Valid values are fully, not fully, and unknown.

aggrConnPoolRef

If this Oracle OLAP cube is an aggregate table, this element references the connection pool used for the aggregate.

containerRef

References the Analytic Workspace for this AW cube.


The AW cube tag includes the following child elements:

Table 3-29 AW Cube Child Elements

Element Name Description

CompositeInfo

References dimensions for the cube.

Contains the sub-element called Composite, which has one attribute called name and a sub-element called Dimension. Each dimension is contained in the Dimension sub-element.

AWColumn

References the Oracle OLAP columns that belong to this Oracle OLAP cube.

For more details, see Section 3.21, "MDS XML Elements: AW Column."


Syntax

The syntax here includes the summary child element entry for the AW column element. The full syntax for the AW column element appears in Section 3.21, "MDS XML Elements: AW Column."

<AWCube …
     extName=""
     isCacheable=""
     cacheExpiry=""
     isCacheEventTable=""
     pollFreq=""
     x=""
     y=""
     rowCount=""
     lastUpdated=""
     hints=""
     isExtGatewayInProcess=""
     isOverrideCacheProp=""
     isDDLAggr=""
     isSysGen=""
     isPartitioned=""
     densityStatus""
     materializationStatus=""
     aggrConnPoolRef=""
     containerRef="">
   <Description />
   <CompositeInfo>
      <Composite name="">
        <Dimension …/>
     </Composite>
   </CompositeInfo>
   <AWColumn />
</AWCube>

Example

<AWCube mdsid="m000000b0-0bee-0000-714b-e31d00000000" 
   name="Time Channel Cube" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository" 
   extName="Time Channel Cube" 
   isPartitioned="true" 
   containerRef="/oracle/bi/server/base/AnalyticWorkspace/GLOBAL_000000ae-0be9-
    0000-714b-e31d00000000.xml#m000000ae-0be9-0000-714b-e31d00000000">
   <CompositeInfo>
     <Composite name="TIME_CHANNEL_CUBE_102_PRTCOMP">
       <Dimension>
         <![CDATA[ CHANNEL ]]> 
       </Dimension>
     </Composite>
     <Composite name="TIME_CHANNEL_CUBE_119_PRTCOMP">
       <Dimension>
         <![CDATA[ CHANNEL ]]> 
       </Dimension>
     </Composite>
...
...
   </CompositeInfo>
   <AWColumn mdsid="m000000d4-0bf4-0000-714b-e31d00000000" 
     name="Units" 
     extName="TIME_CHANNEL_CUBE_UNITS" 
     dataType="DOUBLE" nullable="true">
   </AWColumn>
   <AWColumn mdsid="m000000d5-0bf4-0000-714b-e31d00000000" 
     name="Sales" 
     extName="TIME_CHANNEL_CUBE_SALES" 
     dataType="DOUBLE" nullable="true">
   </AWColumn>
   <AWColumn mdsid="m000000d6-0bf4-0000-714b-e31d00000000" 
     name="Cost" 
     extName="TIME_CHANNEL_CUBE_COST" 
     dataType="DOUBLE" nullable="true">
   </AWColumn>
   <AWColumn mdsid="m000000d7-0bf4-0000-714b-e31d00000000" 
     name="Measure1" 
     extName="TIME_CHANNEL_CUBE_MEASURE1" 
     dataType="DOUBLE" nullable="true">
   </AWColumn>
   <AWColumn mdsid="m000000d8-0bf4-0000-714b-e31d00000000" 
     name="SALES_5_QUARTERS_AGO" 
     extName="TIME_CHANNEL_CUBE_SALES_5_QUARTERS_AGO" 
     dataType="DOUBLE" nullable="true">
   </AWColumn>
</AWCube>

3.18 MDS XML Elements: AW Dimension

The AW dimension element corresponds to the Oracle OLAP dimension object in the Physical layer.

The AW dimension tag includes the following attributes:

Table 3-30 AW Dimension Tag Attributes

Attribute Name Description

type

The dimension type.

isCacheable

If set to true, indicates that this dimension is included in the Oracle BI Server query cache.

CacheExpiry

If set to true, indicates that this dimension is included in the Oracle BI Server query cache.

isCacheEventTable

How long table entries should persist in the query cache. A value of 0 indicates that cache entries do not expire.

isOverrideCacheProp

For alias tables only. If set to true, indicates that the alias table has its own cache properties that override the cache properties of the source table.

pollFreq

If set to true, indicates that this table has been registered as an Oracle BI Server event polling table.

x

The polling frequency, in seconds. Only applies if this table is an Oracle BI Server event polling table. The default value is 3600 seconds.

y

The x coordinate of the table when it is shown in the physical diagram.

rowCount

The y coordinate of the table when it is shown in the physical diagram.

lastUpdated

The time at which row counts were last updated for this Oracle OLAP dimension.

hints

This attribute is not used.

isSysGen

If set to true, indicates that an internal utility has generated this Oracle OLAP dimension.

isDDLAggr

Indicates whether this Oracle OLAP dimension is an aggregate table.

isTimeDim

If set to true, indicates that this Oracle OLAP dimension is a time dimension.

extName

The physical name that is used when referencing the dimension in physical SQL queries.

aggrConnPoolRef

If this AW dimension is an aggregate table, this element references the connection pool used for the aggregate.

isRagged

If set to true, indicates that this dimension hierarchy is unbalanced. An unbalanced hierarchy is one that contains levels that are not at the same depth.

isSkipped

If set to true, indicates that this dimension hierarchy is a skip-level hierarchy. A skip-level hierarchy is one in which there are members that do not have a value for a particular parent level.

containerRef

References the Analytic Workspace for this AW dimension.


The AW dimension tag includes the following child elements:

Table 3-31 AW Dimension Child Elements

Element Name Description

AWObject

References the Oracle OLAP objects, such a list of hierarchies, associated with this dimension.

The AWObject element includes the following attributes:

  • name

  • type

  • dataType

  • nullable

  • precision

  • scale

AWColumn

References the AW columns that belong to this AW dimension.

For more details, see Section 3.21, "MDS XML Elements: AW Column."


Syntax

The syntax here includes the summary child element entry for the AW column element. The full syntax for the AW column element appears in Section 3.21, "MDS XML Elements: AW Column."

<AWDimension …
     type=""
     isCacheable=""
     cacheExpiry=""
     isCacheEventTable=""
     isOverrideCacheProp=""
     pollFreq=""
     x=""
     y=""
     rowCount=""
     lastUpdated=""
     isSysGen=""
     isDDLAggr=""
     hints=""
     isTimeDim=""
     extName=""
     aggrConnPoolRef=""
     isRagged=""
     isSkipped=""
     containerRef="">
   <Description /> 
   <AWObject name="" type="" dataType=""
     nullable="" precision="" scale="" />
   <AWColumn />
</AWDimension>

Example

<AWDimension mdsid="m000000b2-0bec-0000-714b-e31d00000000" 
   name="Channel" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   type="none" 
   extName="CHANNEL" 
   containerRef="/oracle/bi/server/base/AnalyticWorkspace/GLOBAL_000000ae-0be9-
    0000-714b-e31d00000000.xml#m000000ae-0be9-0000-714b-e31d00000000">
   <AWObject type="HIER_LIST" name="CHANNEL_HIERLIST" 
     dataType="VARCHAR" precision="100" /> 
   <AWObject type="LEVEL_LIST" name="CHANNEL_LEVELLIST" 
     dataType="VARCHAR" precision="100" /> 
   <AWObject type="IN_HIER" name="CHANNEL_INHIER" 
     dataType="VARCHAR" precision="100" /> 
   <AWObject type="PARENT_REL" name="CHANNEL_PARENTREL" 
     dataType="VARCHAR" precision="100" /> 
   <AWObject type="LEVEL_REL" name="CHANNEL_LEVELREL" 
     dataType="VARCHAR" precision="100" /> 
   <AWObject type="FAMILY_REL" name="CHANNEL_FAMILYREL" 
     dataType="VARCHAR" precision="100" /> 
   <AWColumn mdsid="m000000fc-0bf4-0000-714b-e31d00000000" 
     name="Total Channel - Long Description" 
     extName="CHANNEL_LONG_DESCRIPTION" 
     dataType="VARCHAR" precision="100" 
     awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
      714b-e31d00000000.xml#m0000013b-0bf2-0000-714b-e31d00000000">
   </AWColumn>
   <AWColumn mdsid="m000000fd-0bf4-0000-714b-e31d00000000" 
     name="Total Channel - Short Description" 
     extName="CHANNEL_SHORT_DESCRIPTION" 
     dataType="VARCHAR" precision="100" 
     awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
      714b-e31d00000000.xml#m0000013b-0bf2-0000-714b-e31d00000000">
   </AWColumn>
   <AWColumn mdsid="m000000fe-0bf4-0000-714b-e31d00000000" 
     name="Total Channel" 
     extName="CHANNEL" 
     dataType="VARCHAR" precision="100" 
     awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
      714b-e31d00000000.xml#m0000013b-0bf2-0000-714b-e31d00000000">
   </AWColumn>
   <AWColumn mdsid="m000000ff-0bf4-0000-714b-e31d00000000" 
     name="Channel - Long Description" 
     extName="CHANNEL_LONG_DESCRIPTION" 
     dataType="VARCHAR" precision="100" 
     awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
      714b-e31d00000000.xml#m0000013c-0bf2-0000-714b-e31d00000000">
   </AWColumn>
   <AWColumn mdsid="m00000100-0bf4-0000-714b-e31d00000000" 
     name="Channel - Short Description" 
     extName="CHANNEL_SHORT_DESCRIPTION" 
     dataType="VARCHAR" precision="100" 
     awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
      714b-e31d00000000.xml#m0000013c-0bf2-0000-714b-e31d00000000">
   </AWColumn>
   <AWColumn mdsid="m00000101-0bf4-0000-714b-e31d00000000" 
     name="Channel" 
     extName="CHANNEL" 
     dataType="VARCHAR" precision="100" 
     awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
      714b-e31d00000000.xml#m0000013c-0bf2-0000-714b-e31d00000000">
   </AWColumn>
</AWDimension>

3.19 MDS XML Elements: AW Hierarchy

The AW hierarchy element corresponds to the Oracle OLAP hierarchy object in the Physical layer.

The AW hierarchy tag includes the following attributes:

Table 3-32 AW Hierarchy Tag Attributes

Attribute Name Description

type

The type of Oracle OLAP hierarchy (value or level).

isDefault

If set to true, indicates that this is the default hierarchy for the Oracle OLAP dimension.

extName

The physical name that is used when referencing the hierarchy in physical SQL queries.

dataType

The data type of the Oracle OLAP hierarchy, such as VARCHAR.

nullable

If set to true, indicates that null values are allowed for the Oracle OLAP hierarchy. This allows null values to be returned to the user, which is expected with certain functions and with outer joins.

precision

The precision of the data type of the Oracle OLAP hierarchy.

scale

The scale of the data type of the Oracle OLAP hierarchy.

memberKeyRef

References the member key (for parent-child hierarchies).

dimensionRef

References the AW dimension for this Oracle OLAP hierarchy.


The AW hierarchy tag includes the following child elements:

Table 3-33 AW Hierarchy Child Elements

Attribute Name Description

AWLevel

For level-based hierarchies only. References the AW level for this Oracle OLAP dimension.

For more details, see Section 3.20, "MDS XML Elements: AW Level."


Syntax

The syntax here includes the summary child element entry for the AW level element. The full syntax for the AW level element appears in Section 3.20, "MDS XML Elements: AW Level."

<AWHierarchy …
     type=""
     isDefault=""
     extName=""
     dataType=""
     nullable=""
     precision=""
     scale=""
     memberKeyRef=""
     dimensionRef="">
   <Description />
   <AWLevel />
</AWHierarchy>

Example

<AWHierarchy mdsid="m0000012d-0bf0-0000-714b-e31d00000000" 
   name="Calendar Year" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   isDefault="true" 
   extName="CALENDAR_YEAR" 
   dataType="UNKNOWN" 
   dimensionRef="/oracle/bi/server/base/AWDimension/Time_000000b1-0bec-0000-714b-
    e31d00000000.xml#m000000b1-0bec-0000-714b-e31d00000000">
   <AWLevel mdsid="m00000133-0bf2-0000-714b-e31d00000000" 
     name="All Years" 
     extName="ALL_YEARS" 
     dataType="UNKNOWN" 
     levelKeyRef="/oracle/bi/server/base/AWDimension/Time_000000b1-0bec-0000-714b-
      e31d00000000.xml#m000000da-0bf4-0000-714b-e31d00000000"
     awHierarchyRef="/oracle/bi/server/base/AWHierarchy/Calendar Year_0000012d-
      0bf0-0000-714b-e31d00000000.xml#m0000012d-0bf0-0000-714b-e31d00000000">
   </AWLevel>
   <AWLevel mdsid="m00000134-0bf2-0000-714b-e31d00000000" 
     name="Year" 
     extName="YEAR" 
     dataType="UNKNOWN" 
     levelKeyRef="/oracle/bi/server/base/AWDimension/Time_000000b1-0bec-0000-714b-
      e31d00000000.xml#m000000df-0bf4-0000-714b-e31d00000000"
     awHierarchyRef="/oracle/bi/server/base/AWHierarchy/Calendar Year_0000012d-
      0bf0-0000-714b-e31d00000000.xml#m0000012d-0bf0-0000-714b-e31d00000000">
   </AWLevel>
   <AWLevel mdsid="m00000135-0bf2-0000-714b-e31d00000000" 
     name="Quarter" 
     extName="QUARTER" 
     dataType="UNKNOWN" 
     levelKeyRef="/oracle/bi/server/base/AWDimension/Time_000000b1-0bec-0000-714b-
      e31d00000000.xml#m000000e5-0bf4-0000-714b-e31d00000000"
     awHierarchyRef="/oracle/bi/server/base/AWHierarchy/Calendar Year_0000012d-
      0bf0-0000-714b-e31d00000000.xml#m0000012d-0bf0-0000-714b-e31d00000000">
   </AWLevel>
   <AWLevel mdsid="m00000136-0bf2-0000-714b-e31d00000000" 
     name="Month" 
     extName="MONTH" 
     dataType="UNKNOWN" 
     levelKeyRef="/oracle/bi/server/base/AWDimension/Time_000000b1-0bec-0000-714b-
      e31d00000000.xml#m000000eb-0bf4-0000-714b-e31d00000000" 
     awHierarchyRef="/oracle/bi/server/base/AWHierarchy/Calendar Year_0000012d-
      0bf0-0000-714b-e31d00000000.xml#m0000012d-0bf0-0000-714b-e31d00000000">
   </AWLevel>
</AWHierarchy>

3.20 MDS XML Elements: AW Level

The AW level element corresponds to the Oracle OLAP level object in the Physical layer.

The AW level element is not a top-level element - it appears as a child element of the AW hierarchy element.

The AW level tag includes the following attributes:

Table 3-34 AW Level Tag Attributes

Attribute Name Description

extName

The physical name that is used when referencing the level in physical SQL queries.

dataType

The data type of the Oracle OLAP level, such as VARCHAR.

nullable

If set to true, indicates that null values are allowed for the Oracle OLAP level. This allows null values to be returned to the user, which is expected with certain functions and with outer joins.

precision

The precision of the data type of the Oracle OLAP level.

scale

The scale of the data type of the Oracle OLAP level.

levelKeyRef

References the key column for this Oracle OLAP level.

awHierarchyRef

References the AW hierarchy for this Oracle OLAP level.


The AW level tag does not include any child elements.

Syntax

<AWLevel …
     extName=""
     dataType=""
     nullable=""
     precision=""
     scale=""
     levelKeyRef=""
     awHierarchyRef="">
   <Description />
</AWLevel>

Example

<AWLevel mdsid="m00000133-0bf2-0000-714b-e31d00000000" 
   name="All Years" 
   extName="ALL_YEARS" 
   dataType="UNKNOWN" 
   levelKeyRef="/oracle/bi/server/base/AWDimension/Time_000000b1-0bec-0000-714b-
    e31d00000000.xml#m000000da-0bf4-0000-714b-e31d00000000"
   awHierarchyRef="/oracle/bi/server/base/AWHierarchy/Calendar Year_0000012d-
    0bf0-0000-714b-e31d00000000.xml#m0000012d-0bf0-0000-714b-e31d00000000">
</AWLevel>

3.21 MDS XML Elements: AW Column

The AW column element corresponds to the AW column object in the Physical layer.

The AW column element is not a top-level element - it appears as a child element of the AW cube and AW dimension elements.

The AW column tag includes the following attributes:

Table 3-35 AW Column Tag Attributes

Attribute Name Description

extName

The physical name that is used when referencing the column in physical SQL queries.

isParentKey

Indicates whether this Oracle OLAP column is a parent key for a level.

dataType

The data type of the Oracle OLAP column, such as VARCHAR.

scale

The scale of the data type of the Oracle OLAP column.

nullable

If set to true, indicates that null values are allowed for the Oracle OLAP column. This allows null values to be returned to the user, which is expected with certain functions and with outer joins.

precision

The precision of the data type of the Oracle OLAP column.

awHierarchyRef

For value-based hierarchies, references the AW hierarchy for this Oracle OLAP column.

awLevelRef

References the hierarchy level for this Oracle OLAP column.


The AW column tag does not include any child elements.

Syntax

<AWColumn …
     extName=""
     isParentKey=""
     dataType=""
     nullable=""
     precision=""
     scale=""
     awHierarchyRef=""
     awLevelRef=""/>
   <Description />
</AWColumn>

Example

<AWColumn mdsid="m000000fe-0bf4-0000-714b-e31d00000000" 
   name="Total Channel" 
   extName="CHANNEL" 
   dataType="VARCHAR" precision="100" 
   awLevelRef="/oracle/bi/server/base/AWHierarchy/Primary_0000012f-0bf0-0000-
    714b-e31d00000000.xml#m0000013b-0bf2-0000-714b-e31d00000000">
</AWColumn>