12 Physical Elements

Physical elements are typically those elements that are exposed in the Physical layer, or in other words, the elements that appear in the right-hand pane of the Administration Tool.

This chapter contains the following topics:

Section 12.1, "Database"
Section 12.2, "Physical Catalog"
Section 12.3, "Physical Schema"
Section 12.4, "Physical Display Folder"
Section 12.5, "Physical Table"
Section 12.6, "Physical Column"
Section 12.7, "Connection Pool"
Section 12.8, "Physical Key"
Section 12.9, "Physical Foreign Key"
Section 12.10, "Complex Join"
Section 12.11, "Cube Table"
Section 12.12, "Physical Dimension"
Section 12.13, "Physical Hierarchy"
Section 12.14, "Physical Level"
Section 12.15, "Cube Column"
Section 12.16, "Analytic Workspace"
Section 12.17, "AW Cube"
Section 12.18, "AW Dimension"
Section 12.19, "AW Hierarchy"
Section 12.20, "AW Level"
Section 12.21, "AW Column"

12.1 Database

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

The database tag includes the following attributes:

Table 12-1 Database Tag Attributes

Attribute Name Description

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.

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.

The database tag includes the following child elements:

Table 12-2 Database Child Elements

Element Name Description

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).
PersistConnPool	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 persist connection pool is contained in a sub-element called `RefConnectionPool`.
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`.

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).

PersistConnPool

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 persist connection pool is contained in a sub-element called RefConnectionPool.

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.

Syntax

<Database …
     type=""
     dbFlag="">
   <Description />
   <Features>
     <Feature name="" value=""/>
     <Feature name="" value=""/>
     ...
   </Features>
   <PersistConnPool>
     <RefConnectionPool …/>
   </PersistConnPool>
   <DisplayFolders>
     <RefPhysicalDisplayFolder …/>
     <RefPhysicalDisplayFolder …/>
   </DisplayFolders>
</Database>

Example

<Database name="Paint" id="3023:205" uid="161"
     type="XMLDirect">
   <Description />
   <Features>
     <Feature name="LEFT_OUTER_JOIN_SUPPORTED" value="false" /> 
     <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="false" /> 
     <Feature name="COUNT_DISTINCT_SUPPORTED" value="false" /> 
...
     <Feature name="SORT_ORDER_LOCALE" value="english-usa" /> 
     <Feature name="COMMENT_START" /> 
     <Feature name="COMMENT_END" /> 
   </Features>
</Database>

12.2 Physical Catalog

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

The physical catalog tag includes the following child elements:

Table 12-3 Physical Catalog Child Elements

Element Name Description

Element Name	Description
DynamicName	If a session variable is being used to specify the name of this physical catalog, this element references that session variable. The session variable is contained in a sub-element called `RefVariable`.

DynamicName

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

The session variable is contained in a sub-element called RefVariable.

The physical catalog element does not include any attributes.

Syntax

<PhysicalCatalog …>
   <DynamicName>
     <RefVariable …/>
   </DynamicName>
</PhysicalCatalog>

Example

<PhysicalCatalog name="my_catalog" parentName="&quot;SQLDB&quot;"
   parentId="3023:3035" id="3025:3063" uid="2147485024">
   <Description></Description>
</PhysicalCatalog>

12.3 Physical Schema

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

The physical schema tag includes the following child elements:

Table 12-4 Physical Schema Child Elements

Element Name Description

Element Name	Description
DynamicName	If a session variable is being used to specify the name of this physical schema, this element references that session variable. The session variable is contained in a sub-element called `RefVariable`.

DynamicName

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

The session variable is contained in a sub-element called RefVariable.

The physical schema element does not include any attributes.

Syntax

<Schema …>
   <DynamicName>
     <RefVariable …/>
   </DynamicName>
</Schema>

Example

<Schema name="dbo" parentName="&quot;SQLDB&quot;.&quot;my_catalog&quot;"
     parentId="3025:3063"
     id="3027:3068" uid="2147485027">
   <Description></Description>
</Schema>

12.4 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 child elements:

Table 12-5 Physical Display Folder Child Elements

Element Name Description

Element Name	Description
DynamicName	If a session variable is being used to specify the name of this physical display folder, this element references that session variable. The session variable is contained in a sub-element called `RefVariable`.
Tables	References the physical tables that belong to this physical display folder. Each physical table is contained in a sub-element called `RefPhysicalTable`.

DynamicName

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

The session variable is contained in a sub-element called RefVariable.

Tables

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

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

The physical display folder element does not include any attributes.

Syntax

<PhysicalDispFolder …>
   <DynamicName>
     <RefVariable …/>
   </DynamicName>
</Schema>

Example

<PhysicalDisplayFolder name="Aliases" parentName="&quot;SQLDB&quot;"
   parentId="3023:3035" id="3037:6088" uid="2147535305">
   <Description></Description>
   <Tables>
     <RefPhysicalTable id="3001:3190" qualifiedName="&quot;SQLDB&quot;.&quot;my_
     catalog&quot;.&quot;dbo&quot;.&quot;Cross Sell Categories&quot;"/>
     <RefPhysicalTable id="3001:3194" qualifiedName="&quot;SQLDB&quot;.&quot;my_
     catalog&quot;.&quot;dbo&quot;.&quot;Cross Sell OrderDetails&quot;"/>
     <RefPhysicalTable id="3001:3200" qualifiedName="&quot;SQLDB&quot;.&quot;my_
     catalog&quot;..&quot;dbo&quot;.&quot;Cross Sell Orders&quot;"/>
     <RefPhysicalTable id="3001:3216" qualifiedName="&quot;SQLDB&quot;.&quot;my_
     catalog&quot;..&quot;&quot;dbo&quot;.&quot;Cross Sell Products&quot;"/>
   </Tables>
</PhysicalDisplayFolder>

12.5 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 12-6 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.

The physical table tag includes the following child elements:

Table 12-7 Physical Table Child Elements

Element Name	Description
SourceTable	For alias tables only. References the physical table that is being used as the source for this alias table. The physical table is contained in a sub-element called `RefPhysicalTable`.
DBMap	Stores the value of database-specific strings. The `<DBMap>` element contains an `<Item>` tag, which in turn contains a `<Value>` tag, as follows: <Item name=""> <Value /> </Item>
AggrConnPool	If this physical table is an aggregate table, this element references the connection pool used for the aggregate. The connection pool is contained in a sub-element called `RefConnectionPool`.
RefVariable	If a session variable is being used to specify the name of this physical table, this element references that session variable.

Syntax

<PhysicalTable …
     type=""
     isCacheable=""
     cacheExpiry=""
     isCacheEventTable=""
     isOverrideCacheProp=""
     pollFreq=""
     x=""
     y=""
     rowCount=""
     lastUpdated=""
     uri=""
     xslPath=""
     maxConn=""
     xmlRefreshInterval=""
     scriptPath=""
     hints=""
     isExtGatewayInProcess=""
     extGatewayDelimiter=""
     isSysGen=""
     isDDLAggr=""
     isDeployedView="">
   <SourceTable>
     <RefPhysicalTable …/>
   </SourceTable>
   <DBMap>
     <Item name="">
       <Value …/>
     </Item>
   </DBMap>
   <AggrConnPool>
     <RefConnectionPool …/>
   </AggrConnPool>
   <RefVariable …/>
</PhysicalTable>

Example

<PhysicalTable name="Product" parentName="&quot;Paint&quot;..&quot;&quot;"
     parentId="3023:205"
     id="3001:601"
     uid="656"
     type="none"
     x="191"
     y="436"
     rowCount="91.0"
     lastUpdated="2000-08-14 09:12:14"
     uri="VALUEOF(BI_EE_HOME)/server/Sample/paint/Product.xml"
     maxConn="0"
     extName="Product">
   <Description /> 
</PhysicalTable>

12.6 Physical Column

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

The physical column tag includes the following attributes:

Table 12-8 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.

The physical column tag includes the following child elements:

Table 12-9 Physical Column Child Elements

Element Name Description

Element Name	Description
DynamicName	If a session variable is being used to specify the name of this physical column, this element references that session variable. The session variable is contained in a sub-element called `RefVariable`.
SourceColumn	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 is contained in a sub-element called `RefPhysicalColumn`.
PicklistColumns	A list of physical columns to which the picklist is mapped. Each physical column is contained in a sub-element called `RefPhysicalColumn`.

DynamicName

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

The session variable is contained in a sub-element called RefVariable.

SourceColumn

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 is contained in a sub-element called RefPhysicalColumn.

PicklistColumns

A list of physical columns to which the picklist is mapped.

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

Syntax

<PhysicalColumn …
     extName=""
     dataType=""
     length=""
     nullable=""
     precision=""
     scale=""
     rowCount=""
     lastUpdated=""
     valueType=""
     mappedColumn=""
     MVLinkName=""
     specialType="">
   <DynamicName>
     <RefVariable …/>
   </DynamicName>
   <SourceColumn>
     <RefPhysicalColumn …/>
   </SourceColumn>
   <PicklistColumns>
     <RefPhysicalColumn …/>
   </PicklistColumns>
</PhysicalColumn>

Example

<PhysicalColumn name="DOLLARS"
     parentName="&quot;Forecast&quot;...&quot;Forecast&quot;"
     parentId="3001:681"
     id="3003:685"
     uid="765"
     dataType="DOUBLE"
     scale="0"
     precision="0"
     nullable="true"
     extName="//Table/FORECAST/DOLLARS"
     lastUpdated="2001-01-01 00:00:00">
   <Description />
</PhysicalColumn>

12.7 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 12-10 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.
shareStatus	This attribute is not used.
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.

The connection pool tag includes the following child elements:

Table 12-11 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.
RelationalConnPool	This child element is reserved for a future release.
RelationalDataFolder	This child element is reserved for a future release.
SQLBypassDB	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 database object is contained in a sub-element called `RefDatabase`.

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="">
   <Description /> 
   <AfterQueryString flag="">
     <Value …/>
   </AfterQueryString>
   <BeforeQueryString flag="">
     <Value …/>
   </BeforeQueryString>
   <PostConnectString flag="">
     <Value …/>
   </PostConnectString>
   <PreDisconnectString flag="">
     <Value …/>
   </PreDisconnectString>
   <SQLBypassDB>
     <RefDatabase …/>
   </SQLBypassDB>
</ConnectionPool>

Example

<ConnectionPool name="Sample Sales XML B" 
     parentName="&quot;B - Sample Fcst Data&quot;"
     parentId="3023:760"
     parentUid="69265"
     id="3029:762"
     uid="69266"
     password="D7EDED84BC624A917F5B462A4DCA05CDCE256EEEEEDC97D5AC4D07C3A079829F"
     timeout="300"
     maxConnDiff="10"
     maxConn="10"
     dataSource="VALUEOF(BI_EE_HOME)/sample/sample_app/xml_data"
     type="Default"
     reqQualifedTableName="false"
     isSharedLogin="false"
     isConcurrentQueriesInConnection="false"
     isCloseAfterEveryRequest="true"
     xmlRefreshInterval="4294967295"
     outputType="xml"
     bulkInsertBufferSize="0"
     transactionBoundary="0"
     xmlaUseSession="false"
     multiThreaded="false"
     supportParams="false"
     isSiebelJDBSecured="false">
   <Description /> 
</ConnectionPool>

12.8 Physical Key

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

The physical key tag includes the following child elements:

Table 12-12 Physical Key Child Elements

Element Name Description

Element Name	Description
Columns	References the column that defines this physical key. The column is contained in a sub-element, either `RefPhysicalColumn` or `RefCubeColumn`.

Columns

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 />
   <Columns>
     <RefPhysicalColumn …/>
     <RefPhysicalColumn …/>
   </Columns>
</PhysicalKey>

Example

     <PhysicalKey name="FactKey" parentName="&quot;Paint&quot;...&quot;Fact&quot;"
     parentId="3001:550"
     id="3008:556"
     uid="566">
   <Description />
   <Columns>
     <RefPhysicalColumn id="3003:551" qualifiedName="&quot;Paint&quot;...
     &quot;Fact&quot;.&quot;MktKey&quot;" /> 
     <RefPhysicalColumn id="3003:552" qualifiedName="&quot;Paint&quot;...
     &quot;Fact&quot;.&quot;ProdKey&quot;"
      /> 
     <RefPhysicalColumn id="3003:553" qualifiedName="&quot;Paint&quot;...
     &quot;Fact&quot;.&quot;PerKey&quot;" /> 
   </Columns>
</PhysicalKey>

12.9 Physical Foreign Key

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

The physical foreign key tag includes the following attributes:

Table 12-13 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.

The physical foreign key tag includes the following child elements:

Table 12-14 Physical Foreign Key Child Elements

Element Name Description

Element Name	Description
Columns	References the physical columns in the table that the foreign key references. Each physical column is contained in a sub-element called either `RefPhysicalColumn` or `RefCubeColumn`.
CounterPartKey	References the corresponding primary key. Each primary key is contained in a sub-element called `RefPhysicalKey`.

Columns

References the physical columns in the table that the foreign key references.

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

CounterPartKey

References the corresponding primary key.

Each primary key is contained in a sub-element called RefPhysicalKey.

Syntax

<PhysicalForeignKey …
     hints="">
   <Columns>
     <RefPhysicalColumn …/>
     <RefPhysicalColumn …/>
   </Columns>
   <CounterPartKey>
     <RefPhysicalKey …/>
   </CounterPartKey>
</PhysicalForeignKey>

Example

<PhysicalForeignKey name="Forecast_FKey#2"
     parentName="&quot;Forecast&quot;...&quot;Forecast&quot;"
     parentId="3001:681"
     id="3006:687"
     uid="769">
   <Description /> 
   <Columns>
     <RefPhysicalColumn id="3003:683" qualifiedName="&quot;Forecast&quot;...
     &quot;Forecast&quot;.&quot;PERKEY&quot;" /> 
   </Columns>
   <CounterPartKey>
     <RefPhysicalKey id="3008:600" qualifiedName="&quot;Paint&quot;...
     &quot;Period&quot;.&quot;Period_Key&quot;" /> 
   </CounterPartKey>
</PhysicalForeignKey>

12.10 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 12-15 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.

The complex join tag includes the following child elements:

Table 12-16 Complex Join Child Elements

Element Name Description

Element Name	Description
Tables	References the physical tables in the join. Each physical table is contained in a sub-element called `RefPhysicalTable` or `RefCubeTable`. Note that the `RefAWCube` and `RefAWDimension` sub-elements are reserved for a future release.
Expr	Contains the expression that defines the relationship between the two tables.
ExternalExpr	Contains the external expression used for ADF Business Component data sources.

Tables

References the physical tables in the join. Each physical table is contained in a sub-element called RefPhysicalTable or RefCubeTable.

Note that the RefAWCube and RefAWDimension sub-elements are reserved for a future release.

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="">
   <Tables>
     <RefPhysicalTable …/>
     <RefPhysicalTable …/>
   </Tables>
   <Expr> … </Expr>
   <ExternalExpr> … </ExternalExpr>
</ComplexJoin>

Example

<ComplexJoin name="10 Dim Rolling Time Mth_09 Fact Rolling Time Mth#1"
     id="3012:1275"
     uid="2160747203">
   <Description /> 
   <Tables>
     <RefPhysicalTable uid="2160748027" id="3001:104" qualifiedName=
     "&quot;1 - Sample App Data&quot;...&quot;D04 Time Rolling Mth&quot;" />
     <RefPhysicalTable uid="2160748004" id="3001:102" qualifiedName=
     "&quot;1 - Sample App Data&quot;...&quot;F12 Facts Rolling Time Mth&quot;" />
   </Tables>
   <Expr>
     <![CDATA[ "1 - Sample App Data"."".""."D04 Time Rolling Mth"."Mth_Key"
     >= "1 - Sample App Data"."".""."F12 Facts Rolling Time Mth"."Mth_Key"  ]]> 
     </Expr>
 </ComplexJoin>

12.11 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 12-17 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.
isSystemGenerated	If set to true, indicates that an internal utility has generated this physical cube table.
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 cube table is an aggregate table.
memberReference	For Essbase data sources only. Indicates the cube property (for example, Member Name).

The cube table tag includes the following child elements:

Table 12-18 Cube Table Child Elements

Element Name Description

Element Name	Description
Aliases	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). Each alias is represented by a sub-element called `AliasTableVar`, which contains a sub-element called `RefVariable`.
CubeVars	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).

Aliases

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).

Each alias is represented by a sub-element called AliasTableVar, which contains a sub-element called RefVariable.

CubeVars

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).

Syntax

<CubeTable …
     extName=""
     type=""
     isCacheable=""
     cacheExpiry=""
     isCacheEventTable=""
     pollFreq=""
     x=""
     y=""
     rowCount=""
     lastUpdated=""
     scriptPath=""
     isSystemGenerated=""
     isOverrideCacheProp=""
     isDDLAggr=""
     memberReference="">
   <Aliases>
     <AliasTableVar>
       <RefVariable …/>
       <RefVariable …/>
     </AliasTableVar>
   </Aliases>
   <CubeVars>
     <CubeVar …/>
     <CubeVar …/>
   </CubeVars>
</CubeTable>

Example

<CubeTable name="Budget" parentName="&quot;FoodMart&quot;..&quot;&quot;"
     parentId="3023:3038"
     id="3039:4280"
     uid="2147510222"
     type="none"
     extName="Budget">
<Description></Description>
</CubeTable>

12.12 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 12-19 Physical Dimension Tag Attributes

Attribute Name	Description
defaultMember	The default member for this physical dimension.

The physical dimension tag includes the following child elements:

Table 12-20 Physical Dimension Child Elements

Element Name Description

Element Name	Description
Hierarchies	References the hierarchies that belong to this physical dimension.Each hierarchy is contained in a sub-element called `RefPhysicalHierarchy`.
UserAttributes	References the dimension properties for this physical dimension. Each dimension property is contained in a sub-element called `RefCubeColumn`.
AlternateHierarchyNames	For Essbase physical dimension objects, lists the names of any alternate hierarchies that belong to this dimension. Each hierarchy name is listed in a sub-element called `Name`.

Hierarchies

References the hierarchies that belong to this physical dimension.Each hierarchy is contained in a sub-element called RefPhysicalHierarchy.

UserAttributes

References the dimension properties for this physical dimension.

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

AlternateHierarchyNames

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

Each hierarchy name is listed in a sub-element called Name.

Syntax

<PhysicalDimension …
     defaultMember="">
   <Hierarchies>
     <RefPhysicalHierarchy …/>
   </Hierarchies>
   <UserAttributes>
     <RefCubeColumn …/>
   </UserAttributes>
   <AlternateHierarchyNames>
     <Name …/>
   </AlternateHierarchyNames>
</PhysicalDimension>

Example

<PhysicalDimension name="Calendar Months" parentName=
     "&quot;2 - Sampl App ESSBASE&quot;.&quot;BISAMPLE&quot;..&quot;Sample&quot;"
     parentId="3039:16617" parentUid="2160773306" id="3064:16467"
     uid="2160773156">
   <Description /> 
   <Hierarchies>
     <RefPhysicalHierarchy uid="2160773085" id="3041:16396" qualifiedName=
     "&quot;2 - Sampl App ESSBASE&quot;.&quot;BISAMPLE&quot;..
     &quot;Sample&quot;.&quot;Calendar Months&quot;" />
   </Hierarchies>
   <UserAttributes>
     <RefCubeColumn uid="2160773353" id="3043:16664" qualifiedName=
     "&quot;2 - Sampl App ESSBASE&quot;.&quot;BISAMPLE&quot;..
     &quot;Sample&quot;.&quot;Calendar Months Memnor&quot;" />
   </UserAttributes>
</PhysicalDimension>

12.13 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 12-21 Physical Hierarchy Tag Attributes

Attribute Name	Description
memberType	Indicates whether the ALL member has been designated as the default. This option corresponds to Default member type ALL in the Physical Hierarchy dialog in the Administration Tool.
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.

The physical hierarchy tag includes the following child elements:

Table 12-22 Physical Hierarchy Child Elements

Element Name	Description
Columns	For parent-child (value) hierarchies. References the set of cube columns that belong to this physical hierarchy. Each cube column is contained in a sub-element called `RefCubeColumn`.
MemberKey	For parent-child (value) hierarchies. References the cube column that is the member key for this hierarchy. The member key column is contained in a sub-element called `RefCubeColumn`.
ParentKey	For parent-child (value) hierarchies. References the cube column that is the parent key for this hierarchy. The parent key column is contained in a sub-element called `RefCubeColumn`.
Levels	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`.

Syntax

<PhysicalHierarchy …
     memberType=""
     extName=""
     type=""
     dimType=""
     rowCount=""
     isTimeDim=""
     dimUniqueName=""
     isMemberAliasUnique="">
   <Columns>
     <RefCubeColumn …/>
   </Columns>
   <MemberKey>
     <RefCubeColumn …/>
   </MemberKey>
   <ParentKey>
     <RefCubeColumn …/>
   </ParentKey>
   <Levels>
     <RefPhysicalLevel …/>
   </Levels>
</PhysicalHierarchy>

Example

<PhysicalHierarchy name="Time"
     parentName="&quot;FoodMart&quot;...&quot;Sales&quot;"
     parentId="3039:4260"
     id="3041:4200"
     uid="2147487210"
     extName="Time"
     type="FULLY BALANCED"
     dimUniqueName="Time">
   <Description></Description>
</PhysicalHierarchy>

12.14 Physical Level

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

The physical level tag includes the following attributes:

Table 12-23 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.

The physical level tag includes the following child elements:

Table 12-24 Physical Level Child Elements

Element Name Description

Element Name	Description
LevelKey	References the key column for this physical level. The key column is contained in a sub-element called `RefCubeColumn`.

LevelKey

References the key column for this physical level.

The key column is contained in a sub-element called RefCubeColumn.

Syntax

<PhysicalLevel …
     levelNumber=""
     extName=""
     rowCount="">
   <LevelKey>
     <RefCubeColumn …/>
   </LevelKey>
</PhysicalLevel>

Example

<PhysicalLevel name="Year"
     parentName="&quot;FoodMart&quot;...&quot;Sales&quot;.&quot;Time&quot;"      parentId="3041:4200"
     id="3045:5791"
     uid="2147496776"
     levelNum="0"
     extName="Year">
   <Description></Description>
   <LevelKey>
     <RefCubeColumn id="3043:4261" qualifiedName="&quot;FoodMart&quot;...
     &quot;Sales&quot;.&quot;Year&quot;"/>
   </LevelKey>
</PhysicalLevel>

12.15 Cube Column

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

The cube column tag includes the following attributes:

Table 12-25 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.

The cube column tag includes the following child elements:

Table 12-26 Cube Column Child Elements

Element Name Description

Element Name	Description
AttributeHierarchy	References the physical hierarchy to which this cube column belongs. The hierarchy is contained in a sub-element called `RefPhysicalHierarchy`.
PhysicalLevel	References the physical level to which this cube column belongs. The level is contained in a sub-element called `RefPhysicalLevel`.

AttributeHierarchy

References the physical hierarchy to which this cube column belongs.

The hierarchy is contained in a sub-element called RefPhysicalHierarchy.

PhysicalLevel

References the physical level to which this cube column belongs.

The level is contained in a sub-element called RefPhysicalLevel.

Syntax

<CubeColumn …
     extName=""
     aggrType=""
     dataType=""
     nullable=""
     precision=""
     rowCount=""
     lastUpdated=""
     scale="">
   <AttributeHierarchy>
     <RefPhysicalHierarchy …/>
   </AttributeHierarchy>
   <PhysicalLevel>
     <RefPhysicalLevel …/>
   </PhysicalLevel>
</CubeColumn>

Example

<CubeColumn name="Year" parentName="&quot;FoodMart&quot;...&quot;Sales&quot;"
     parentId="3039:4260"
     id="3043:4261"
     uid="2147487198"
     extName="Year"
     dataType="VARCHAR"
     scale="0"
     precision="8"
     nullable="false">
<Description></Description>
</CubeColumn>