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

5 MDS XML Marketing, Security, and Other Elements

This chapter provides MDS XML reference information for Oracle Marketing Segmentation elements, security elements, and miscellaneous Oracle BI repository elements that do not fall in other categories.

This chapter contains the following topics:

5.1 MDS XML Marketing Elements

Marketing elements are typically those elements that are related to features for the Oracle Marketing Segmentation product. For information about features and options related to Oracle Marketing Segmentation, see the administrator documentation for the Oracle Marketing Segmentation application.

Marketing elements include:

5.1.1 MDS XML Elements: Catalog Link

The catalog link element corresponds to the conforming dimension link object in the Marketing metadata. A conforming dimension links a fact that contains target-level IDs to a fact that does not contain target-level IDs by navigating along a dimension that is shared by both fact tables.

The catalog link tag includes the following attributes:

Table 5-1 Catalog Link Tag Attributes

Attribute Name Description

inColumnRef

References the presentation column that represents the primary key of the subject area from which the dimension link originates.

outColumnRef

References the presentation column that represents the primary key of the subject area to which the dimension link points.


Syntax

<CatalogLink …
     inColumnRef=""
     outColumnRef="">
   <Description />
</CatalogLink>

Example

<CatalogLink mdsid="m8033142f-0fac-0000-714b-e31d00000000" 
   name="Customer Profile->Opportunity Contact" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   inColumnRef="/oracle/bi/server/base/PresentationTable/_u0150 Contact Profile_80
    2b468d-0fa8-0000-714b-e31d00000000.xml#m80312fa3-0faa-0000-714b-e31d00000000" 
   outColumnRef="/oracle/bi/server/base/PresentationTable/_u0150 Contact Profile_
    80330ba0-0fa8-0000-714b-e31d00000000.xml#m80330b9e-0faa-0000-714b-e31d00000000 
    ">
   <Description>
     <![CDATA[ Used by Account Target Level to navigate to Opportunity Contact ]]> 
   </Description>
</CatalogLink>

5.1.2 MDS XML Elements: Target Level

The target level element corresponds to the target level object in the Marketing metadata. A target level is the entity that a marketer wants to count, typically customer types like individuals, businesses, or households.

The target level tag includes the following attributes:

Table 5-2 Target Level Tag Attributes

Attribute Name Description

hasDispName

Indicates whether this target level has a custom display name.

dispName

The value of the custom display name, if one exists for this target level.

hasDispDescription

Indicates whether this target level has a custom description.

dispDescription

The value of the custom description, if one exists for this target level.

primaryQLIRef

References the primary qualified list item for this target level.

primaryCatalogRef

References the primary segmentation catalog for this target level.

staticSegmentCatalogRef

References the set of segmentation catalogs for this target level.

staticSegmentTargetColumnRef

References the Target Id presentation column.

staticSegmentNodeColumnRef

References the GUID presentation column.

staticSegmentPhysicalTableRef

References the physical table that stores the result sets for this target level.

staticSegmentConnectionPoolRef

References the connection pool in which this target level is mapped.


The target level tag includes the following child elements:

Table 5-3 Target Level Child Elements

Element Name Description

HeaderSQL

Contains the physical SQL to insert the Saved Result Header. Used when users save a result set.

DelHeaderSQL

Contains the physical SQL to delete the saved result set header. Used when users purge saved result sets.

DelDataSQL

Contains the physical SQL to delete the saved result data set. Used when users purge saved result sets.


Syntax

<TargetLevel …
     hasDispName=""
     dispName=""
     hasDispDescription=""
     dispDescription=""
     primaryQLIRef=""
     primaryCatalogRef=""
     staticSegmentCatalogRef=""
     staticSegmentTargetColumnRef=""
     staticSegmentNodeColumnRef=""
     staticSegmentPhysicalTableRef=""
     staticSegmentConnectionPoolRef="">
   <Description />
   <HeaderSQL … />
   <DelHeaderSQL … />
   <DelDataSQL … />
</TargetLevel>

Example

<TargetLevel mdsid="m802ba17b-0fae-0000-714b-e31d00000000" 
   name="Contacts" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository"
   hasDispName="false"
   primaryQLIRef="/oracle/bi/server/base/QualifiedListItem/Contacts_802ba17c-
    0fb2-0000-714b-e31d00000000.xml#m802ba17c-0fb2-0000-714b-e31d00000000" 
   primaryCatalogRef="/oracle/bi/server/base/PresentationCatalog/Customer Profile_
    segmentation_802b44df-0fa4-0000-714b-e31d00000000.xml#m802b44df-0fa4-0000-
    714b-e31d00000000" 
   staticSegmentTargetColumnRef="/oracle/bi/server/base/PresentationTable/_u0150 
    Contact Results Data_802ba2d1-0fa8-0000-714b-e31d00000000.xml#m802ba2cd-0faa-
    0000-714b-e31d00000000"
   staticSegmentNodeColumnRef="/oracle/bi/server/base/PresentationTable/_u0150 
    Contact Results Data_802ba2d1-0fa8-0000-714b-e31d00000000.xml#m802ba2cf-0faa-
    0000-714b-e31d00000000"
   staticSegmentPhysicalTableRef="/oracle/bi/server/base/PhysicalTable/M_SR_
    CONTACT_802ba200-0bb9-0000-714b-e31d00000000.xml#m802ba200-0bb9-0000-714b-
    e31d00000000">
   <HeaderSQL>
     <![CDATA[ INSERT INTO M_SR_HEADER (GUID, SEGMENT_PATH, SR_CUSTOM_LABEL,
        PRIORITY, NODE_PATH, NODE_LABEL, TARGET_LEVEL, CREATED_BY, "COUNT", DATE_
        TIME, SR_PATH, CONNECTION_POOL) VALUES ('@{guid}', '@{segmentPath}', 
        '@{srCustomLabel}', @{priority}, '@{nodePath}', '@{nodeLabel}', 
        '@{targetLevel}','@{createdBy}', @{count},'@{createdTime}', '@{srPath}', 
        '@{connectionPool}') ]]> 
   </HeaderSQL>
   <DelHeaderSQL>
     <![CDATA[ DELETE FROM M_SR_HEADER WHERE GUID IN (@{guids}) ]]> 
   </DelHeaderSQL>
   <DelDataSQL>
     <![CDATA[ DELETE FROM M_SR_CONTACT WHERE GUID IN (@{guids}) ]]> 
   </DelDataSQL>
</TargetLevel>

5.1.3 MDS XML Elements: List Catalog

The list catalog element corresponds to the list catalog object in the Marketing metadata. A list catalog is an object that is used to generate a list of data at the target level.

The list catalog key tag includes the following attributes:

Table 5-4 List Catalog Tag Attributes

Attribute Name Description

presentationCatalogRef

References the subject area for this list catalog. The name of the subject area is used as the name of the list catalog.


The list catalog tag does not include any child elements.

Syntax

<ListCatalog …
     presentationCatalogRef="">
   <Description />
</ListCatalog>

Example

<ListCatalog mdsid="m8032fe28-0fb0-0000-714b-e31d00000000" 
   name="Marketing Contact List" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   presentationCatalogRef="/oracle/bi/server/base/PresentationCatalog/Marketing 
    Contact List_8031263b-0fa4-0000-714b-e31d00000000.xml#m8031263b-0fa4-0000-
    714b-e31d00000000">
</ListCatalog>

5.1.4 MDS XML Elements: Qualified List Item

The qualified list item element corresponds to the qualified list item object in the Marketing metadata. A qualified list item is an entity that is evaluated against segment criteria so that the information related to that entity can be exported in a list file.

The qualified list item tag includes the following attributes:

Table 5-5 Qualified List Item Tag Attributes

Attribute Name Description

cacheTable

Indicates whether this qualified list item is cached.

cacheCatalogRef

References the subject area for the cache for this qualified list item.

cacheConnPoolRef

References the connection pool for the cached table.

cacheTargetColumnRef

References the Target Id presentation column.

cacheNodeColumnRef

References the GUID presentation column.

cachePhysicalTableRef

References the physical table that stores the cached qualified list item.


The qualified list item tag includes the following child elements:

Table 5-6 Qualified List Item Child Elements

Element Name Description

DeleteSQL

Contains the physical SQL used to delete the cached results.


Syntax

<QualifiedListItem …
     cacheTable=""
     cacheCatalogRef=""
     cacheConnPoolRef=""
     cacheTargetColumnRef=""
     cacheNodeColumnRef=""
     cachePhysicalTableRef="">
   <DeleteSQL>
     <!CDATA[[…]]>
   </DeleteSQL>
</QualifiedListItem>

Example

<QualifiedListItem mdsid="m80331498-0fb2-0000-714b-e31d00000000" 
   name="Ordered Products" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   cacheTable="M_C_GENERIC" 
   cacheCatalogRef="/oracle/bi/server/base/PresentationCatalog/Marketing 
    Segmentation Cache and Saved Results_802ba2ad-0fa4-0000-714b-e31d00000000.
    xml#m802ba2ad-0fa4-0000-714b-e31d00000000" 
   cacheConnPoolRef="/oracle/bi/server/base/ConnectionPool/Oracle Data Warehouse 
    Connection Pool_00238434-0bd5-0000-714b-e31d00000000.xml#m00238434-0bd5-0000-
    714b-e31d00000000" 
   cacheTargetColumnRef="/oracle/bi/server/base/PresentationTable/_u0150 Generic 
    Item Cache_80331490-0fa8-0000-714b-e31d00000000.xml#m8033148e-0faa-0000-714b-
    e31d00000000"
   cacheNodeColumnRef="/oracle/bi/server/base/PresentationTable/_u0150 Generic 
    Item Cache_80331490-0fa8-0000-714b-e31d00000000.xml#m8033148c-0faa-0000-714b-
    e31d00000000" 
   cachePhysicalTableRef="/oracle/bi/server/base/PhysicalTable/M_C_GENERIC_8033
    1468-0bb9-0000-714b-e31d00000000.xml#m80331468-0bb9-0000-714b-e31d00000000">
   <DeleteSQL>
     <![CDATA[ DELETE FROM M_C_GENERIC WHERE GUID = '@{guid}' ]]> 
   </DeleteSQL>
</QualifiedListItem>

5.1.5 MDS XML Elements: Qualifying Key

The qualifying key element corresponds to the qualifying keys that are used in list catalog or segmentation catalog objects in the Marketing metadata. Qualifying keys map qualified list items to presentation columns.

The qualifying key tag includes the following attributes:

Table 5-7 Qualifying Key Tag Attributes

Attribute Name Description

listCatalogRef

References the list catalog to which this qualifying key belongs.

segmentationCatalogRef

References the segmentation catalog to which this qualifying key belongs.

keyColumnRef

References the presentation column for this qualifying key.

qualifiedListItemRef

References the qualified list item for this qualifying key.


Syntax

<QualifyingKey …
     listCatalogRef=""
     segmentationCatalogRef=""
     keyColumnRef=""
     qualifiedListItemRef="">
   <Description />
</QualifyingKey>

Example

<QualifyingKey mdsid="m80c10f04-0fb4-0000-714b-e31d00000000" 
   name="MKTG_QK_4020:4722171188242192" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   segmentationCatalogRef="/oracle/bi/server/base/SegCatalog/Accounts_Pharma Sales 
    Effectiveness_Segmentation_80c10f0a-0fba-0000-714b-e31d00000000.xml#m80c10f0a-
    0fba-0000-714b-e31d00000000" 
   keyColumnRef="/oracle/bi/server/base/PresentationTable/Accounts_80c0ef0d-0fa8-
    0000-714b-e31d00000000.xml#m80c0ef09-0faa-0000-714b-e31d00000000" 
   qualifiedListItemRef="/oracle/bi/server/base/QualifiedListItem/Accounts_802b
    a1a6-0fb2-0000-714b-e31d00000000.xml#m802ba1a6-0fb2-0000-714b-e31d00000000">
</QualifyingKey>

5.1.6 MDS XML Elements: Sampling Table

The sampling table element corresponds to the sampling table object in the Marketing metadata. Sampling tables are created and managed as part of target level objects.

The sampling table tag includes the following attributes:

Table 5-8 Sampling Table Tag Attributes

Attribute Name Description

factor

The sampling factor (for example, 10%).

targetLevelRef

References the target level for the sampling table.

physicalTableRef

References the physical table being used as the sampling table.


Syntax

<SamplingTable … 
     factor=""
     targetLevelRef=""
     physicalTableRef="">
   <Description />
</SamplingTable>

Example

<SamplingTable mdsid="m80342e77-0fb8-0000-714b-e31d00000000" 
   name="M_10A_ASSET_D" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   factor="0.1" 
   targetLevelRef="/oracle/bi/server/base/TargetLevel/Assets_80341f24-0fae-0000-
    714b-e31d00000000.xml#m80341f24-0fae-0000-714b-e31d00000000" 
   physicalTableRef="/oracle/bi/server/base/PhysicalTable/W_ASSET_D_00226101-0bb9-
    0000-714b-e31d00000000.xml#m00226101-0bb9-0000-714b-e31d00000000">
</SamplingTable>

5.1.7 MDS XML Elements: Seg Catalog

The seg catalog element corresponds to the segmentation catalog object in the Marketing metadata. Segmentation catalogs are Oracle BI subject areas that are enabled for segmentation. Segmentation catalogs provides a set of dimensions and fact measures that can be used to create segment criteria.

The seg catalog tag includes the following attributes:

Table 5-9 Seg Catalog Tag Attributes

Attribute Name Description

targetLevelRef

References the target level for the segmentation catalog.

presentationCatalogRef

References the subject area for this segmentation catalog.


Syntax

<SegCatalog …
     targetLevelRef=""
     presentationCatalogRef="">
   <Description />
</SegCatalog>

Example

<SegCatalog mdsid="m802ba19b-0fba-0000-714b-e31d00000000" 
   name="Contacts_Quotes_segmentation" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   targetLevelRef="/oracle/bi/server/base/TargetLevel/Contacts_802ba17b-0fae-
    0000-714b-e31d00000000.xml#m802ba17b-0fae-0000-714b-e31d00000000" 
   presentationCatalogRef="/oracle/bi/server/base/PresentationCatalog/Quotes_
    segmentation_802b5904-0fa4-0000-714b-e31d00000000.xml#m802b5904-0fa4-0000-
    714b-e31d00000000">
</SegCatalog>

5.2 MDS XML Security Elements

Security elements are typically those elements that are related to Oracle Business Intelligence security features, such as those related to variables, authentication, privileges, users, and application roles. Security elements include:

5.2.1 MDS XML Elements: Variable

The variable element corresponds to the variable object in the Physical layer of the repository.

The variable tag includes the following attributes:

Table 5-10 Variable Tag Attributes

Attribute Name Description

securityMask

For session variables only. This attribute stores the value of the following options:

  • Enable any user to set the value. When selected, lets session variables be set after the initialization block has populated the value (at user login) by calling the ODBC store procedure NQSSetSessionValue(). For example, this option lets non-administrators set this variable for sampling.

  • Security Sensitive. When selected, identifies the variable as sensitive to security for virtual private databases (VPDs). When filtering cache table matches, the Oracle BI Server looks at the parent database of each column or table that is referenced in the logical request projection list. If the physical database source is a VPD, the Oracle BI Server matches a list of security-sensitive variables to each prospective cache hit. Cache hits would only occur on cache entries that included and matched all security-sensitive variables.

isSessionVar

If set to true, indicates that this variable is a session variable. Session variables are created and assigned a value when each user logs on, unlike repository variables, which have static values.

initBlockRef

References the init block where this variable is initialized.


The variable tag includes the following child elements:

Table 5-11 Variable Child Elements

Element Name Description

Expr

Contains the expression that forms the definition of this variable.


Syntax

<Variable name="" 
     securityMask=""
     isSessionVar=""
     initBlockRef="">
   <Description />
   <Expr>
     <ExprText>...</ExprText>
     <ExprTextDesc>...</ExprTextDesc>
     <ObjectRefList>
       <RefObject objectRef="" …/>
       <RefObject objectRef="" …/>
     </ObjectRefList>
   </Expr>
</Variable>

Example

<Variable mdsid="m804054aa-0bd7-0000-714b-e31d00000000" 
   name="CURRENT_DAY" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository">
   <Description>
     <![CDATA[ Returns the value of Current Date in the MM/DD/YYYY format. ]]> 
   </Description>
   <Expr>
     <ExprText>
       <![CDATA[ VALUEOF("%1") ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ VALUEOF("Warehouse Refresh Date"."LAST_REFRESH_DT") ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m804054aa-0bd7-0000-714b-e31d00000000-m0023848c-0bd7-
          0000-714b-e31d00000000" 
         objectRef="/oracle/bi/server/base/Variable/LAST_REFRESH_DT_0023848c-0bd7-
          0000-714b-e31d00000000.xml#m0023848c-0bd7-0000-714b-e31d00000000" /> 
     </ObjectRefList>
   </Expr>
</Variable>

5.2.2 MDS XML Elements: LDAP Server

The LDAP server element corresponds to the LDAP server object in the Identity Manager dialog in the Administration Tool.

The LDAP server tag includes the following attributes:

Table 5-12 LDAP Server Tag Attributes

Attribute Name Description

hostName

The host name of the LDAP server.

port

The port number of the LDAP server (for example, 389).

baseDN

The base distinguished name (DN) that identifies the starting point of the authentication search.

bindDN

The optional DN that is required to bind to the LDAP server. This option is required if isADSI is set to true.

userNameAttrType

A value that uniquely identifies a user, such as the user ID, the RDN (relative distinguished name), or (for ADSI) sAMAccountName.

domainID

A domain identifier that uniquely identifies the domain for which the LDAP object is responsible. This is especially useful when there are multiple LDAP objects.

password

The user password associated with the Bind DN. This option is required if isADSI is set to true. Note that passwords are encrypted.

timeout

The time period after which Administration Tool import attempts or Oracle BI Server user authentication attempts against this LDAP server will time out.

cacheExpiry

The interval at which the authentication cache entry in the LDAP cache for a logged on user is refreshed.

This option corresponds to Cache refresh interval in the Repository tab of the Options dialog in the Administration Tool.

isADSI

If set to true, indicates that this is an Active Directory LDAP server.

useSSL

If set to true, indicates that the connection to the LDAP server uses Secure Sockets Layer (SSL).

keyFile

The name of the key file that holds the client certificate and Certificate Authority (CA) certificate. Required if useSSL is set to true.

This option corresponds to Key file name in the Repository tab of the Options dialog in the Administration Tool.

keyPassword

The password that is required to connect to the external LDAP server.

version

The LDAP version number of the LDAP server, either 2 or 3. The default is 3.

cacheEntries

The maximum number of entries in the authentication cache, preallocated when the Oracle BI Server starts. If the number of users exceeds this limit, cache entries are replaced using the LRU algorithm. If this value is 0, then the authentication cache is disabled.

This option corresponds to Number of Cache Entries in the Repository tab of the Options dialog in the Administration Tool.


The LDAP server tag does not include any child elements.

Syntax

<LDAPServer …
     hostName=""
     port=""
     baseDN=""
     bindDN=""
     userNameAttrType=""
     domainID=""
     password=""
     timeout=""
     cacheExpiry=""
     entities=""
     isADSI=""
     useSSL=""
     keyFile=""
     keyPassword=""
     version=""
     cacheEntries="">
   <Description /> 
</LDAPServer>

Example

<LDAPServer mdsid="mbd837790-0bf6-1000-806e-0a97078d0000" 
   name="LDAP01" 
   isDefaultReadable="false" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   hostName="sdacns05" 
   port="389" 
   version="3" 
   baseDN="name1" 
   bindDN="name2" 
   userNameAttrType="sAMAccountName" 
   password="6C6F0BE01FC4111F3AC2236A364D912EEBFE551E0A2AC2F5352A18F9228901AA7D896
    E3DA56ECB22F248B15B1759E26A638B148E7051643B2E72CAAC984A64515B58DEA74F85662056F
    795206529ADEF" 
   timeout="60" 
   cacheExpiry="86400" 
   cacheEntries="1000" 
   isADSI="true" 
   useSSL="false" 
   keyPassword="E3130008E1C4CAD47041E4AE68B048E67C2E35213306F12832914CBE7A9DD9556
    1D771DED06484112B1FC6F27B6D0D58">
</LDAPServer>

5.2.3 MDS XML Elements: Init Block

The init block element corresponds to the initialization block object in the Physical layer. Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.

The init block tag includes the following attributes:

Table 5-13 Init Block Tag Attributes

Attribute Name Description

isSessionVar

If set to true, indicates that this initialization block is a session initialization block. Session initialization blocks are used with session variables.

The default value is false.

refreshPeriod

The refresh interval for this initialization block, in seconds. For repository initialization blocks only.

The default value is 0.

baseTime

The start date and time for this initialization block. For repository initialization blocks only.

The default value is 2001-01-01 00:00:00.

isRowWiseInit

If set to true, indicates that row-wise initialization has been enabled. Row-wise initialization lets you create session variables dynamically and set their values when a session begins. For session initialization blocks only.

The default value is false.

isRowWiseCacheEnabled

If set to true, indicates that the Use caching option has been enabled. This option directs the Oracle BI Server to store the results of the query in a main memory cache. This option is only available if row-wise initialization has been enabled.

The default value is true.

isSuccRequired

Indicates that the Required for Authentication option has been selected for this initialization block in the Administration Tool.

If this option is selected, this initialization block must succeed for users to log in. In other words, users will be denied access to Oracle BI EE if the initialization block fails to execute. Failure to execute can occur if the wrong credentials have been defined in the initialization block, or if there is an error in the default initialization string.

The default value is false.

isEnabled

If set to true, indicates that this initialization block is enabled. For session initialization blocks only.

The default value is true.

isDeferredExecution

If set to true, indicates that deferred execution of this initialization block is enabled.

Deferred execution is used to speed up the server startup time, by preventing the execution of the SQL for the initialization block when the server starts. The SQL is issued and the variables are intialized only when one of the variables is used.

isDBIndependentSQL

If set to true, indicates that database independent SQL is enabled.

The SQL is logical SQL, and it is translated by Oracle BI server to database specific SQL.

connectionPoolRef

References the connection pool for this initialization block.

This element is only used if the data source type for this initialization block is Database or XML.


The init block tag includes the following child elements:

Table 5-14 Init Block 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.

RefPredecessors

References the initialization blocks, if any, that are initialized before this initialization block

Each initialization block is contained in a sub-element called RefInitBlock.

RefVariables

References the variables that are associated with this initialization block.

Each variable is contained in a sub-element called RefVariable.

InitString

The SQL initialization string needed to populate the variables.

This element is only used if the data source type for this initialization block is Database or XML.

RefLDAPServers

References the LDAP servers that are associated with this initialization block.

Each LDAP server is contained in a sub-element called RefLDAPServer.

This element is only used if the data source type for this initialization block is LDAP.


Syntax

<InitBlock …
     isSessionVar=""
     refreshPeriod=""
     baseTime=""
     isRowWiseInit=""
     isRowWiseCacheEnabled=""
     isSuccRequired=""
     isEnabled=""
     isDeferredExecution=""
     isDBIndependentSQL=""
     connectionPoolRef="">
   <Description />
   <DBMapItem name="">
      <Value …/>
   </DBMapItem>
   <RefPredecessors>
     <RefInitBlock predecessorRef="" …/>
     <RefInitBlock predecessorRef="" …/>
   </RefPredecessors>
   <RefVariables>
     <RefVariable variableRef="" …/>
     <RefVariable variableRef="" …/>
   </RefVariables>
   <InitString …/>
   <RefLDAPServers>
     <RefLDAPServer ldapServerRef="" …/>
     <RefLDAPServer ldapServerRef="" …/>
   </RefLDAPServers>
</InitBlock>

Example

<InitBlock mdsid="m002384be-0bd9-0000-714b-e31d00000000" 
   name="Primary Owner ID" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   isSessionVar="true" 
   isRowWiseCacheEnabled="false" 
   isEnabled="false" 
   connectionPoolRef="/oracle/bi/server/base/ConnectionPool/Siebel OLTP Connection 
    Pool_00238431-0bd5-0000-714b-e31d00000000.xml#m00238431-0bd5-0000-714b-
    e31d00000000">
   <DBMapItem name="DefaultMulDB">
     <Value>
       <![CDATA[ 
          select PAR_ROW_ID
          from VALUEOF(TBO).S_USER
          where LOGIN = ':USER' ]]> 
     </Value>
   </DBMapItem>
   <RefPredecessors>
     <RefInitBlock refId="m002384be-0bd9-0000-714b-e31d00000000-m002384ac-0bd9-
        0000-714b-e31d00000000" 
       predecessorRef="/oracle/bi/server/base/InitBlock/Authentication_002384ac-
        0bd9-0000-714b-e31d00000000.xml#m002384ac-0bd9-0000-714b-e31d00000000" /> 
   </RefPredecessors>
   <RefVariables>
     <RefVariable refId="m002384be-0bd9-0000-714b-e31d00000000-m0023845e-0bd7-
        0000-714b-e31d00000000" 
       variableRef="/oracle/bi/server/base/Variable/PR_OWNER_ID_0023845e-0bd7-
        0000-714b-e31d00000000.xml#m0023845e-0bd7-0000-714b-e31d00000000" /> 
   </RefVariables>
   <InitString>
       <![CDATA[ 
          select PAR_ROW_ID
          from VALUEOF(TBO).S_USER
          where LOGIN = ':USER' ]]> 
   </InitString>
</InitBlock>

5.2.4 MDS XML Elements: Custom Authenticator

The Custom Authenticator element corresponds to the Custom Authenticator object in the Identity Manager dialog in the Administration Tool.

The Custom Authenticator tag includes the following attributes:

Table 5-15 Custom Authenticator Tag Attributes

Attribute Name Description

cacheExpiry

The interval at which the authentication cache entry for a logged on user is refreshed for this custom authenticator.

path

The path and name of the authenticator plug-in dll.

configParam

Lists any parameters for this custom authenticator that have been explicitly exposed for configuration.

hiddenParam

Lists any parameters for this custom authenticator that have been encrypted, such as passwords.

cacheEntries

The maximum number of entries in the authentication cache for this custom authenticator, preallocated when the Oracle BI Server starts. If the number of users exceeds this limit, cache entries are replaced using the LRU algorithm. If this value is 0, then the authentication cache is disabled.

csfKey

This attribute is not used.

initBlockRef

References the init block for the custom authenticator.


The Custom Authenticator element does not include any child elements.

Syntax

<CustomAuthenticator …
     isDefaultReadable=""
     cacheExpiry=""
     path=""
     configParam=""
     hiddenParam=""
     cacheEntries=""
     initBlockRef="">
   <Description /> 
</CustomAuthenticator>

Example

<CustomAuthenticator mdsid="mbdf488e1-0bf6-1000-806e-0a97078d0000" 
   name="CA01" 
   isDefaultReadable="false"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository" 
   cacheExpiry="86400" 
   cacheEntries="1000" 
   path="authenticate.dll" 
   configParam="ABC" 
   hiddenParam="D7EDED84BC624A917F5B462A4DCA05CDCE256EEEEEDC97D5D885270569A16AB6">
</CustomAuthenticator>

5.2.5 MDS XML Elements: Privilege Package

The privilege package element is a container for other privileges. It corresponds to a set of permissions that applies to a particular user or application role object in the repository metadata. The privilege package element contains the information available on the Object Permissions, Data Filters, and Query Limits tabs of the User/Application Role Permissions dialog in the Administration Tool.

Because privilege packages can be associated with more than one user or application role, the total number of privilege packages may not equal the total number of users and application roles.

The privilege package tag includes the following attributes:

Table 5-16 Privilege Package Tag Attributes

Attribute Name Description

userRef

References any users that have the privilege package.

roleRef

References any application roles that have the privilege package.

isFineGrainedMode

Reserved for Oracle internal use only.


The privilege package tag includes the following child elements:

Table 5-17 Privilege Package Child Elements

Element Name Description

QueryPrivilegeMapping

References any query privileges that belong to this privilege package, along with the corresponding database.

Contains two attributes: databaseRef, which references the database name, and queryPrivilegeRef, which references the query privilege.

FilterMapping

References any data filters that belong to this privilege package by mapping an object name with the filter expression.

Contains the following attributes and sub-elements:

  • Status. Valid values are Enabled, Disabled, and Ignored

  • objectRef, which references the metadata object name

  • Expr, which contains the filter expression


Syntax

<PrivilegePackage …
     userRef=""
     roleRef=""
     isFineGrainedMode="">
   <Description />
   <QueryPrivilegeMapping
     databaseRef=""
     queryPrivilegeRef="">
   <FilterMapping
     status=""
     objectTypeID=""
     objectRef="">
     <Expr>
       <ExprText>...</ExprText>
       <ExprTextDesc>...</ExprTextDesc>
       <ObjectRefList>
         <RefObject objectRef="" …/>
         <RefObject objectRef="" …/>
       </ObjectRefList>
     </Expr>
   </FilterMapping>
</PrivilegePackage>

Example

<PrivilegePackage mdsid="m808626e7-1071-0000-714b-e31d00000000" 
   name="PrivPack_4209:3417381144981469" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   roleRef="/oracle/bi/server/base/Group/Purchasing Buyer_0041592c-106e-0000-714b-
    e31d00000000.xml#m0041592c-106e-0000-714b-e31d00000000">
   <QueryPrivilegeMapping 
     databaseRef="/oracle/bi/server/base/Database/Oracle Data Warehouse_0023840a-
      0bcf-0000-714b-e31d00000000.xml#m0023840a-0bcf-0000-714b-e31d00000000" 
     queryPrivilegeRef="/oracle/bi/server/base/QueryPrivilege/QueryPriv_4204_
      u0058_3417391144981469_808626e8-106c-0000-714b-e31d00000000.xml#m808626e8-
      106c-0000-714b-e31d00000000" /> 
   <FilterMapping status="disable" objectTypeId="2035" 
     objectRef="/oracle/bi/server/base/LogicalTable/Fact _u0150 Sourcing _u0150 
      Response_80d105ed-07f3-0000-714b-e31d00000000.xml#m80d105ed-07f3-0000-714b-
      e31d00000000">
     <Expr>
       <ExprText>
         <![CDATA[ cast("%1" AS DOUBLE) = valueof(NQ_SESSION.PRC_BU_MANAGE_NEG) 
            AND ("%2" = valueof(NQ_SESSION."%3") OR cast("%1" AS DOUBLE)= 
            valueof(NQ_SESSION.PRC_BU_MANAGE_NEG_ViewOthers)) ]]> 
       </ExprText>
       <ExprTextDesc>
         <![CDATA[ cast("Core"."Dim - Procurement Business Unit"."Key Id" AS 
            DOUBLE) = valueof(NQ_SESSION.PRC_BU_MANAGE_NEG) AND ("Core"."Dim - 
            Purchase Buyer"."Purchase Buyer Login" = valueof(NQ_SESSION."USER") 
            OR cast("Core"."Dim - Procurement Business Unit"."Key Id" AS DOUBLE)= 
            valueof(NQ_SESSION.PRC_BU_MANAGE_NEG_ViewOthers)) ]]> 
       </ExprTextDesc>
       <ObjectRefList>
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m000b17e8-07d6-
            0000-714b-e31d00000000"
           objectTypeId="2006" 
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Procurement 
            Business Unit_000b17df-07f3-0000-714b-e31d00000000.xml#m000b17e8-07d6-
            0000-714b-e31d00000000" /> 
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m80ea6449-07d6-
            0000-714b-e31d00000000" 
           objectTypeId="2006" 
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Purchase 
            Buyer_805fe01a-07f3-0000-714b-e31d00000000.xml#m80ea6449-07d6-0000-
            714b-e31d00000000" /> 
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m00238445-0bd7-
            0000-714b-e31d00000000" 
           objectRef="/oracle/bi/server/base/Variable/USER_00238445-0bd7-0000-
            714b-e31d00000000.xml#m00238445-0bd7-0000-714b-e31d00000000" /> 
       </ObjectRefList>
     </Expr>
   </FilterMapping>
   <FilterMapping status="disable" objectTypeId="2035" 
     objectRef="/oracle/bi/server/base/LogicalTable/Fact _u0150 Sourcing _u0150 
      Negotiation Award_80d105fe-07f3-0000-714b-e31d00000000.xml#m80d105fe-07f3-
      0000-714b-e31d00000000">
     <Expr>
       <ExprText>
         <![CDATA[ cast("%1" AS DOUBLE)= valueof(NQ_SESSION.PRC_BU_MANAGE_NEG) AND 
            ("%2" = valueof(NQ_SESSION."%3") OR cast("%1" AS DOUBLE) = 
            valueof(NQ_SESSION.PRC_BU_MANAGE_NEG_ViewOthers)) ]]> 
       </ExprText>
       <ExprTextDesc>
         <![CDATA[ cast("Core"."Dim - Procurement Business Unit"."Key Id" AS 
            DOUBLE)= valueof(NQ_SESSION.PRC_BU_MANAGE_NEG) AND ("Core"."Dim - 
            Purchase Buyer"."Purchase Buyer Login" = valueof(NQ_SESSION."USER" 
            OR cast("Core"."Dim - Procurement Business Unit"."Key Id" AS DOUBLE) = 
            valueof(NQ_SESSION.PRC_BU_MANAGE_NEG_ViewOthers)) ]]> 
       </ExprTextDesc>
       <ObjectRefList>
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m000b17e8-07d6-
            0000-714b-e31d00000000" 
           objectTypeId="2006" 
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Procurement 
            Business Unit_000b17df-07f3-0000-714b-e31d00000000.xml#m000b17e8-07d6-
            0000-714b-e31d00000000" /> 
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m80ea6449-07d6-
            0000-714b-e31d00000000"
           objectTypeId="2006" 
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Purchase 
            Buyer_805fe01a-07f3-0000-714b-e31d00000000.xml#m80ea6449-07d6-0000-
            714b-e31d00000000" /> 
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m00238445-0bd7-
            0000-714b-e31d00000000"
           objectRef="/oracle/bi/server/base/Variable/USER_00238445-0bd7-0000-
            714b-e31d00000000.xml#m00238445-0bd7-0000-714b-e31d00000000" /> 
       </ObjectRefList>
     </Expr>
   </FilterMapping>
   <FilterMapping status="disable" objectTypeId="2035" 
     objectRef="/oracle/bi/server/base/LogicalTable/Fact _u0150 Sourcing _u0150 
      Negotiation_80d10624-07f3-0000-714b-e31d00000000.xml#m80d10624-07f3-0000-
      714b-e31d00000000">
     <Expr>
       <ExprText>
         <![CDATA[ cast("%1" AS DOUBLE)= valueof(NQ_SESSION.PRC_BU_MANAGE_NEG) AND 
            ("%2" = valueof(NQ_SESSION."%3") OR cast("%1" AS DOUBLE) = 
            valueof(NQ_SESSION.PRC_BU_MANAGE_NEG_ViewOthers)) ]]> 
       </ExprText>
       <ExprTextDesc>
         <![CDATA[ cast("Core"."Dim - Procurement Business Unit"."Key Id" AS 
            DOUBLE)= valueof(NQ_SESSION.PRC_BU_MANAGE_NEG) AND ("Core"."Dim - 
            Purchase Buyer"."Purchase Buyer Login" = valueof(NQ_SESSION."USER") 
            OR cast("Core"."Dim - Procurement Business Unit"."Key Id" AS DOUBLE) = 
            valueof(NQ_SESSION.PRC_BU_MANAGE_NEG_ViewOthers)) ]]> 
       </ExprTextDesc>
       <ObjectRefList>
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m000b17e8-07d6-
            0000-714b-e31d00000000" 
           objectTypeId="2006" 
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Procurement 
            Business Unit_000b17df-07f3-0000-714b-e31d00000000.xml#m000b17e8-07d6-
            0000-714b-e31d00000000" /> 
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m80ea6449-07d6-
            0000-714b-e31d00000000" 
           objectTypeId="2006" 
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Purchase 
            Buyer_805fe01a-07f3-0000-714b-e31d00000000.xml#m80ea6449-07d6-0000-
            714b-e31d00000000" /> 
         <RefObject refId="m808626e7-1071-0000-714b-e31d00000000-m00238445-0bd7-
            0000-714b-e31d00000000"
           objectRef="/oracle/bi/server/base/Variable/USER_00238445-0bd7-0000-
            714b-e31d00000000.xml#m00238445-0bd7-0000-714b-e31d00000000" /> 
       </ObjectRefList>
     </Expr>
   </FilterMapping>
</PrivilegePackage>

5.2.6 MDS XML Elements: Object Privilege

The object privilege element corresponds to the set of object permissions you can apply to metadata objects such as logical or presentation columns. In the Administration Tool, you can set object permissions in the Presentation layer, or in the Object Permissions tab of the User/Application Role Permissions dialog.

The object privilege tag includes the following attributes:

Table 5-18 Object Privilege Tag Attributes

Attribute Name Description

type

Contains the type of privilege applied to the objects. Valid values are:

  • read: corresponds to the Read privilege in theAdministration Tool

  • readWrite: corresponds to the Read/Write privilege in the Administration Tool

  • none: corresponds to the No Access privilege in the Administration Tool

This attribute can contain the following other values: delete, write, grant, and all. These other values are for internal use.

privilegePackageRef

References the privilege package block for the object privilege.


The object privilege tag includes the following child elements:

Table 5-19 Object Privilege Child Elements

Element Name Description

RefObjects

References the set of objects for which this privilege type applies.

Each object is contained in a sub-element called RefObject.


Syntax

<ObjectPrivilege …
     type=""
     privilegePackageRef="">
   <Description />
   <RefObjects>
     <RefObject objectRef="" …/>
     <RefObject objectRef="" …/>
   </RefObjects>
</ObjectPrivilege>

Example

<ObjectPrivilege mdsid="m80343298-05dc-0000-714b-e31d00000000" 
   name="ObjPriv_1500:1678341098389037" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   type="none" 
   privilegePackageRef="/oracle/bi/server/base/PrivilegePackage/PrivPack_4209_
    u0058_1278041021507837_0023e21b-1071-0000-714b-e31d00000000.xml#m0023e21b-
    1071-0000-714b-e31d00000000">
   <RefObjects>
     <RefObject refId="m80343298-05dc-0000-714b-e31d00000000-m80343156-0fa8-0000-
        714b-e31d00000000" 
       objectTypeId="4008" 
       objectRef="/oracle/bi/server/base/PresentationTable/Fact _u0150 Contact_
        80343156-0fa8-0000-714b-e31d00000000.xml#m80343156-0fa8-0000-714b-
        e31d00000000" /> 
     <RefObject refId="m80343298-05dc-0000-714b-e31d00000000-m8034314d-0fa8-0000-
        714b-e31d00000000" 
       objectTypeId="4008" 
       objectRef="/oracle/bi/server/base/PresentationTable/Fact _u0150 Contact_
        8034314d-0fa8-0000-714b-e31d00000000.xml#m8034314d-0fa8-0000-714b-
        e31d00000000" /> 
   </RefObjects>
</ObjectPrivilege>

5.2.7 MDS XML Elements: Query Privilege

The query privilege element corresponds to the set of query privileges you can apply to users or application roles. In the Administration Tool, you can set query privileges in the Query Limits tab of the User/Application Role Permissions dialog.

The query privilege tag includes the following attributes:

Table 5-20 Query Privilege Tag Attributes

Attribute Name Description

maxExecTime

The maximum number of minutes queries can run on a database.

maxExecTimePrivilege

Specifies the status of the maximum query run time limit. Valid values are:

  • Enable: Limits the time to the value specified in maxExecTime.

  • Disable: Disables any limits set in maxExecTime.

  • Warn: Does not enforce limits, but logs queries that exceed the set time limit in the Query log.

  • Ignore: Inherits limits from the parent application role. If there is no time limit to inherit, no limit is enforced.

maxRows

The maximum number of rows for users to retrieve from a database.

maxRowsPrivilege

Specifies the status of the maximum number of rows limit. Valid values are:

  • Enable: Limits the number of rows to the value specified. If the number of rows exceeds the maxRows value, the query is terminated.

  • Disable: Disables any limits set in maxRows.

  • Warn: Does not enforce limits, but logs queries that exceed the set limit in the Query log.

  • Ignore: Inherits limits from the parent application role. If there is no row limit to inherit, no limit is enforced.

populatePrivilege

Specifies whether the Populate privilege is granted or denied for a database. The Populate stored procedure writes the Cache/Saved Result Set value to the database when a criteria block is cached. Valid values are:

  • Allow: Explicitly grants the Populate privilege.

  • Disallow: Explicitly denies the Populate privilege.

  • Ignore: Inherits limits from the parent application role. If there is no limit to inherit, then the Populate privilege is allowed or disallowed based on the property Allow populate queries by default for the database object.

execPhysicalPrivilege

Specifies whether direct database requests can be executed by default. Valid values are:

  • Allow: Explicitly grants the ability to execute direct database requests.

  • Disallow: Explicitly denies the ability to execute direct database requests.

  • Ignore: Inherits limits from the parent application role. If there is no limit to inherit, then direct database requests are allowed or disallowed based on the property Allow direct database requests by default for the database object.


The query privilege tag includes the following child elements:

Table 5-21 Query Privilege Child Elements

Element Name Description

ExecTimeTableItem

If database access has been restricted to particular time periods, lists the time periods and whether access is allowed or disallowed.

Contains three attributes: allow (true or false), startTime, and endTime.


Syntax

<QueryPrivilege …
     maxExecTime=""
     maxExecTimePrivilege=""
     maxRows=""
     maxRowsPrivilege=""
     populatePrivilege=""
     execPhysicalPrivilege="">
   <Description /> 
   <ExecTimeTableItem allow="" startTime="" endTime=""/>
</QueryPrivilege>

Example

<QueryPrivilege mdsid="m803ac151-106c-0000-714b-e31d00000000" 
   name="QueryPriv_4204:1926721120861104" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   maxExecTime="600" 
   maxRows="100000" 
   populatePrivilege="enable">
</QueryPrivilege>

5.2.8 MDS XML Elements: User

The user element corresponds to the user object in the repository. These objects represent the metadata repository copies or versions of externally managed user objects.

The user tag includes the following attributes:

Table 5-22 User Tag Attributes

Attribute Name Description

fullName

The full name of this user.

loggingLevel

The logging level for this user.

logStatisticsStatus

This attribute is not used.

guid

Global unique identifier for a given user, which is independent of the user name.


The user tag includes the following child elements:

Table 5-23 User Child Elements

Element Name Description

RefGroups

References the application roles to which this user belongs.

Each application role is contained in a sub-element called RefGroup.

DBSignOnListMapping

References database login user names and passwords, along with the corresponding database, if this user has database-specific logins defined.

Contains two attributes: dbSignOnRef, which references the database credentials, and databaseRef, which references the database name. Note that database passwords are encrypted.


Syntax

<User …
     fullName=""
     loggingLevel=""
     guid="">
   <Description /> 
   <RefGroups>
     <RefGroup groupRef="" …/>
     <RefGroup groupRef="" …/>
   </RefGroups>
   <DBSignOnListMapping dbSignOnRef="" databaseRef="" />
</User>

Example

<User mdsid="m0021f847-05dd-0000-714b-e31d00000000" 
   name="Administrator" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   guid="B0E8200AE53A11DE8F4643DF3B7A9E29" 
   loggingLevel="6">
   <RefGroups>
     <RefGroup refId="m0021f847-05dd-0000-714b-e31d00000000-m0023e1a2-106e-0000-
        714b-e31d00000000" 
       groupRef="/oracle/bi/server/base/Group/BIAdministrators_0023e1a2-106e-0000-
        714b-e31d00000000.xml#m0023e1a2-106e-0000-714b-e31d00000000" /> 
     <RefGroup refId="m0021f847-05dd-0000-714b-e31d00000000-m0023e1a7-106e-0000-
        714b-e31d00000000" 
       groupRef="/oracle/bi/server/base/Group/Service Analytics Administrator_
        0023e1a7-106e-0000-714b-e31d00000000.xml#m0023e1a7-106e-0000-714b-
        e31d00000000" /> 
     <RefGroup refId="m0021f847-05dd-0000-714b-e31d00000000-m0041592c-106e-0000-
        714b-e31d00000000" 
       groupRef="/oracle/bi/server/base/Group/Purchasing Buyer_0041592c-106e-
        0000-714b-e31d00000000.xml#m0041592c-106e-0000-714b-e31d00000000" /> 
   </RefGroups>
</User>

5.2.9 MDS XML Elements: Group

The group element corresponds to the application role object in the repository metadata.

The group tag includes the following attributes:

Table 5-24 Group Tag Attributes

Attribute Name Description

displayName

The custom Display Name for this application role.

logLevel

This attribute is not used.

logStatisticsStatus

This attribute is not used.

guid

Global unique identifier for a given application role, which is independent of the role name.


The group tag includes the following child elements:

Table 5-25 Group Child Elements

Element Name Description

RefChildGroups

References the set of application roles that belong to this application role.

Each child application role is contained in a sub-element called RefGroup.


Syntax

<Group …
     displayName=""
     guid="">
   <Description …/>
   <RefChildGroups>
     <RefGroup groupRef="" …/>
     <RefGroup groupRef="" …/>
   </RefChildGroups>
</Group>

Example

<Group mdsid="m0023e1d2-106e-0000-714b-e31d00000000" 
   name="Insurance" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository">
   <RefChildGroups>
     <RefGroup refId="m0023e1d2-106e-0000-714b-e31d00000000-m0023e1dc-106e-0000-
        714b-e31d00000000" 
       groupRef="/oracle/bi/server/base/Group/Financial Services Analytics User_
        0023e1dc-106e-0000-714b-e31d00000000.xml#m0023e1dc-106e-0000-714b-
        e31d00000000" /> 
     <RefGroup refId="m0023e1d2-106e-0000-714b-e31d00000000-m0023e1de-106e-0000-
        714b-e31d00000000" 
       groupRef="/oracle/bi/server/base/Group/Insurance Analytics User_0023e1de-
        106e-0000-714b-e31d00000000.xml#m0023e1de-106e-0000-714b-e31d00000000" /> 
   </RefChildGroups>
</Group>

5.2.10 MDS XML Elements: DB Sign-On

The DB sign-on element corresponds to the information provided in the Logons tab of the user object. If the repository has been set up for database-specific login IDs and passwords, you can set up database-specific credentials to allow privileged users to connect to the underlying databases at the level of authority granted to those users in the databases.

The DB sign-on tag includes the following attributes:

Table 5-26 DB Sign-on Tag Attributes

Attribute Name Description

user

The user name for the underlying database.

password

The corresponding password for the underlying database. Note that passwords are encrypted.


The DB sign-on tag does not include any child elements.

Syntax

<DBSignOn … 
     user=""
     password="">
   <Description /> 
</DBSignOn>

Example

<DBSignOn mdsid="me406bac9-0bf1-1000-b290-0ae593200000" 
   name="LOGON_4211:2559932074113" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   user="my_db_user" 
   password="BA0EAAB163">
</DBSignOn>

5.3 Other MDS XML Elements

The elements described in this section are miscellaneous elements that do not fit into any other category. These elements include:

5.3.1 MDS XML Elements: Project

The project element corresponds to the project object in the repository metadata. Projects support multiuser development by enabling developers to work on projects in their area of responsibility.

The project tag includes the following child elements:

Table 5-27 Project Child Elements

Element Name Description

RefCatalogs

References the subject areas that belong to the project.

Each subject area is contained in a sub-element called RefPresentationCatalog.

RefFactTables

References the logical fact tables that belong to the project.

Each fact table is contained in a sub-element called RefLogicalTable.

RefGroups

References the application roles that belong to the project.

Each application role is contained in a sub-element called RefGroup.

RefUsers

References the users that belong to the project.

Each user is contained in a sub-element called RefUser.

RefVariables

References the variables that belong to the project.

Each variable is contained in a sub-element called RefVariable.

RefInitBlocks

References the initialization blocks that belong to the project.

Each initialization block is contained in a sub-element called RefInitBlock.

RefListCatalogs

References the list catalogs that belong to the project.

Each list catalog is contained in a sub-element called RefListCatalog.

RefTables

References the presentation tables that belong to the project.

Each presentation table is contained in a sub-element called RefPresentationTable.

RefColumns

References the presentation columns that belong to the project.

Each presentation column is contained in a sub-element called RefPresentationColumn.

RefHierarchies

References the presentation hierarchies that belong to the project.

Each presentation hierarchy is contained in a sub-element called RefPresentationHierarchy.

RefLevels

References the presentation levels that belong to the project.

Each presentation level is contained in a sub-element called RefPresentationLevel.

RefExcludedCatalogs

References any subject areas that do not belong to the project, but that are mapped to logical objects that do belong to the project.

Each subject area is contained in a sub-element called RefPresentationCatalog.

RefExcludedTables

References any presentation tables that do not belong to the project, but that are mapped to logical objects that do belong to the project.

Each presentation table is contained in a sub-element called RefPresentationTable.

RefExcludedColumns

References any presentation columns that do not belong to the project, but that are mapped to logical objects that do belong to the project.

Each presentation column is contained in a sub-element called RefPresentationColumn.

RefExcludedHierarchies

References any presentation hierarchies that do not belong to the project, but that are mapped to logical objects that do belong to the project.

Each presentation hierarchy is contained in a sub-element called RefPresentationHierarchy.

RefExcludedLevels

References any presentation levels that do not belong to the project, but that are mapped to logical objects that do belong to the project.

Each subject area is contained in a sub-element called RefPresentationLevel.


The project tag does not include any attributes.

Syntax

<Project …>
   <Description />
   <RefCatalogs>
     <RefPresentationCatalog catalogRef="" …/>
   </RefCatalogs>
   <RefFactTables>
     <RefLogicalTable logicalTableRef="" …/>
   </RefFactTables>
   <RefGroups>
     <RefGroup groupRef="" …/>
   </RefGroups>
   <RefUsers>
     <RefUser userRef="" …/>
   </RefUsers>
   <RefVariables>
     <RefVariable variableRef="" …/>
   </RefVariables>
   <RefInitBlocks>
     <RefInitBlock initBlockRef="" …/>
   </RefInitBlocks>
   <RefListCatalogs>
     <RefListCatalog listcatalogRef="" …/>
   </RefListCatalogs>
   <RefTables>
     <RefPresentationTable tableRef="" …/>
   </RefTables>
   <RefColumns>
     <RefPresentationColumn columnRef="" …/>
   </RefColumns>
   <RefHierarchies>
     <RefPresentationHierarchy hierarchyRef="" …/>
   </RefHierarchies>
   <RefLevels>
     <RefPresentationLevel levelRef="" …/>
   </RefLevels>
   <RefExcludedCatalogs>
     <RefPresentationCatalog catalogRef="" …/>
   </RefExcludedCatalogs>
   <RefExcludedTables>
     <RefPresentationTable tableRef="" …/>
   </RefExcludedTables>
   <RefExcludedColumns>
     <RefPresentationColumn columnRef="" …/>
   </RefExcludedColumns>
   <RefExcludedHierarchies>
     <RefPresentationHierarchy hierarchyRef="" …/>
   </RefExcludedHierarchies>
   <RefExcludedLevels>
     <RefPresentationLevel levelRef="" …/>
   </RefExcludedLevels>
</Project>

Example

<Project mdsid="m80c9e2bf-1075-0000-714b-e31d00000000" 
   name="FUSION_Sale Forecasting" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository">
   <RefCatalogs>
     <RefPresentationCatalog refId="m80c9e2bf-1075-0000-714b-e31d00000000-
        m80ca9dbb-0fa4-0000-714b-e31d00000000" 
       catalogRef="/oracle/bi/server/base/PresentationCatalog/Sales Manager 
        Dashboard _u0150 Campaign 80ca9dbb-0fa4-0000-714b-e31d00000000.xml
        #m80ca9dbb-0fa4-0000-714b-e31d00000000" /> 
     <RefPresentationCatalog refId="m80c9e2bf-1075-0000-714b-e31d00000000-
        m80c9a197-0fa4-0000-714b-e31d00000000" 
       catalogRef="/oracle/bi/server/base/PresentationCatalog/Territory Management 
        _u0150 CRM Forecast_80c9a197-0fa4-0000-714b-e31d00000000.xml#m80c9a197-
        0fa4-0000-714b-e31d00000000" /> 
...
   </RefCatalogs>
   <RefFactTables>
     <RefLogicalTable refId="m80c9e2bf-1075-0000-714b-e31d00000000-m00224fba-07f3-
        0000-714b-e31d00000000" 
       logicalTableRef="/oracle/bi/server/base/LogicalTable/Fact _u0150 CRM _u0150 
        Revenue_00224fba-07f3-0000-714b-e31d00000000.xml#m00224fba-07f3-0000-714b-
        e31d00000000" /> 
     <RefLogicalTable refId="m80c9e2bf-1075-0000-714b-e31d00000000-m002250bc-07f3-
        0000-714b-e31d00000000" 
       logicalTableRef="/oracle/bi/server/base/LogicalTable/Fact for Presentation 
        Foldering_002250bc-07f3-0000-714b-e31d00000000.xml#m002250bc-07f3-0000-
        714b-e31d00000000" />
... 
   </RefFactTables>
   <RefGroups>
     <RefGroup refId="m80c9e2bf-1075-0000-714b-e31d00000000-m0023e1a2-106e-0000-
        714b-e31d00000000" 
       groupRef="/oracle/bi/server/base/Group/BIAdministrators_0023e1a2-106e-0000-
        714b-e31d00000000.xml#m0023e1a2-106e-0000-714b-e31d00000000" /> 
   </RefGroups>
   <RefUsers>
     <RefUser refId="m80c9e2bf-1075-0000-714b-e31d00000000-m0021f847-05dd-0000-
        714b-e31d00000000" 
       userRef="/oracle/bi/server/base/User/Administrator_0021f847-05dd-0000-714b-
        e31d00000000.xml#m0021f847-05dd-0000-714b-e31d00000000" /> 
   </RefUsers>
   <RefVariables>
     <RefVariable refId="m80c9e2bf-1075-0000-714b-e31d00000000-m00238445-0bd7-
        0000-714b-e31d00000000" 
       variableRef="/oracle/bi/server/base/Variable/USER_00238445-0bd7-0000-714b-
        e31d00000000.xml#m00238445-0bd7-0000-714b-e31d00000000" /> 
     <RefVariable refId="m80c9e2bf-1075-0000-714b-e31d00000000-m00238451-0bd7-
        0000-714b-e31d00000000" 
       variableRef="/oracle/bi/server/base/Variable/LOCALE_00238451-0bd7-0000-
        714b-e31d00000000.xml#m00238451-0bd7-0000-714b-e31d00000000" /> 
...
   </RefVariables>
   <RefInitBlocks>
     <RefInitBlock refId="m80c9e2bf-1075-0000-714b-e31d00000000-m002384ea-0bd9-
        0000-714b-e31d00000000" 
       initBlockRef="/oracle/bi/server/base/InitBlock/Warehouse Refresh Date_
        002384ea-0bd9-0000-714b-e31d00000000.xml#m002384ea-0bd9-0000-714b-
        e31d00000000" /> 
     <RefInitBlock refId="m80c9e2bf-1075-0000-714b-e31d00000000-m80c606df-0bd9-
        0000-714b-e31d00000000" 
       initBlockRef="/oracle/bi/server/base/InitBlock/Dashboard Currency_80c606df-
        0bd9-0000-714b-e31d00000000.xml#m80c606df-0bd9-0000-714b-e31d00000000" />
... 
   </RefInitBlocks>
   <RefExcludedColumns>
     <RefPresentationColumn refId="m80c9e2bf-1075-0000-714b-e31d00000000-
        m80ec06eb-0faa-0000-714b-e31d00000000" 
       columnRef="/oracle/bi/server/base/PresentationTable/Date_80cf8966-0fa8-
        0000-714b-e31d00000000.xml#m80ec06eb-0faa-0000-714b-e31d00000000" /> 
     <RefPresentationColumn refId="m80c9e2bf-1075-0000-714b-e31d00000000-
        m80ec06ec-0faa-0000-714b-e31d00000000" 
       columnRef="/oracle/bi/server/base/PresentationTable/Date_80cf8966-0fa8-
        0000-714b-e31d00000000.xml#m80ec06ec-0faa-0000-714b-e31d00000000" /> 
... 
   </RefExcludedColumns>
</Project>

5.3.2 MDS XML Elements: Query Object

The query object element corresponds to the saved query object in the repository metadata. You can save a query from the Query Repository dialog in the Administration Tool.

The query object tag includes the following child elements:

Table 5-28 Query Object Child Elements

Element Name Description

QueryString

Contains the query string that qualifies and defines the query.


The query object tag does not include any attributes.

Syntax

<QueryObject …>
   <Description /> 
   <QueryString …/>
</QueryObject>

Example

<QueryObject mdsid="mbd2048f1-0bf6-1000-806e-0a97078d0000" 
   name="Sample Query" 
   isDefaultReadable="false"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository">
   <QueryString>
      <![CDATA[ (128 = "*") AND (6 = Database) AND (189 1 "1")]]> 
   </QueryString>
</QueryObject>