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:
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:
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. |
<CatalogLink … inColumnRef="" outColumnRef=""> <Description /> </CatalogLink>
<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>
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. |
translationKey |
The value of the translation key, 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. |
<TargetLevel … hasDispName="" dispName="" hasDispDescription="" dispDescription="" translationKey="" primaryQLIRef="" primaryCatalogRef="" staticSegmentCatalogRef="" staticSegmentTargetColumnRef="" staticSegmentNodeColumnRef="" staticSegmentPhysicalTableRef="" staticSegmentConnectionPoolRef=""> <Description /> <HeaderSQL … /> <DelHeaderSQL … /> <DelDataSQL … /> </TargetLevel>
<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>
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.
<ListCatalog … presentationCatalogRef=""> <Description /> </ListCatalog>
<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>
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. |
<QualifiedListItem … cacheTable="" cacheCatalogRef="" cacheConnPoolRef="" cacheTargetColumnRef="" cacheNodeColumnRef="" cachePhysicalTableRef=""> <DeleteSQL> <!CDATA[[…]]> </DeleteSQL> </QualifiedListItem>
<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>
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. |
<QualifyingKey … listCatalogRef="" segmentationCatalogRef="" keyColumnRef="" qualifiedListItemRef=""> <Description /> </QualifyingKey>
<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>
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. |
<SamplingTable … factor="" targetLevelRef="" physicalTableRef=""> <Description /> </SamplingTable>
<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>
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. |
<SegCatalog … targetLevelRef="" presentationCatalogRef=""> <Description /> </SegCatalog>
<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>
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:
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:
|
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. |
<Variable name="" securityMask="" isSessionVar="" initBlockRef=""> <Description /> <Expr> <ExprText>...</ExprText> <ExprTextDesc>...</ExprTextDesc> <ObjectRefList> <RefObject objectRef="" …/> <RefObject objectRef="" …/> </ObjectRefList> </Expr> </Variable>
<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>
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 |
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 |
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.
<LDAPServer … hostName="" port="" baseDN="" bindDN="" userNameAttrType="" domainID="" password="" timeout="" cacheExpiry="" entities="" isADSI="" useSSL="" keyFile="" keyPassword="" version="" cacheEntries=""> <Description /> </LDAPServer>
<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>
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 |
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 |
RefPredecessors |
References the initialization blocks, if any, that are initialized before this initialization block Each initialization block is contained in a sub-element called |
RefVariables |
References the variables that are associated with this initialization block. Each variable is contained in a sub-element called |
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 This element is only used if the data source type for this initialization block is LDAP. |
<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>
<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>
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.
<CustomAuthenticator … isDefaultReadable="" cacheExpiry="" path="" configParam="" hiddenParam="" cacheEntries="" initBlockRef=""> <Description /> </CustomAuthenticator>
<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>
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: |
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:
|
<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>
<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>
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:
This attribute can contain the following other values: |
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 |
<ObjectPrivilege … type="" privilegePackageRef=""> <Description /> <RefObjects> <RefObject objectRef="" …/> <RefObject objectRef="" …/> </RefObjects> </ObjectPrivilege>
<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>
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:
|
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:
|
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:
|
execPhysicalPrivilege |
Specifies whether direct database requests can be executed by default. Valid values are:
|
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: |
<QueryPrivilege … maxExecTime="" maxExecTimePrivilege="" maxRows="" maxRowsPrivilege="" populatePrivilege="" execPhysicalPrivilege=""> <Description /> <ExecTimeTableItem allow="" startTime="" endTime=""/> </QueryPrivilege>
<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>
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 |
DBSignOnListMapping |
References database login user names and passwords, along with the corresponding database, if this user has database-specific logins defined. Contains two attributes: |
<User … fullName="" loggingLevel="" guid=""> <Description /> <RefGroups> <RefGroup groupRef="" …/> <RefGroup groupRef="" …/> </RefGroups> <DBSignOnListMapping dbSignOnRef="" databaseRef="" /> </User>
<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>
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 |
<Group … displayName="" guid=""> <Description …/> <RefChildGroups> <RefGroup groupRef="" …/> <RefGroup groupRef="" …/> </RefChildGroups> </Group>
<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>
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.
<DBSignOn … user="" password=""> <Description /> </DBSignOn>
<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>
The elements described in this section are miscellaneous elements that do not fit into any other category. These elements include:
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 |
RefFactTables |
References the logical fact tables that belong to the project. Each fact table is contained in a sub-element called |
RefGroups |
References the application roles that belong to the project. Each application role is contained in a sub-element called |
RefUsers |
References the users that belong to the project. Each user is contained in a sub-element called |
RefVariables |
References the variables that belong to the project. Each variable is contained in a sub-element called |
RefInitBlocks |
References the initialization blocks that belong to the project. Each initialization block is contained in a sub-element called |
RefListCatalogs |
References the list catalogs that belong to the project. Each list catalog is contained in a sub-element called |
RefTables |
References the presentation tables that belong to the project. Each presentation table is contained in a sub-element called |
RefColumns |
References the presentation columns that belong to the project. Each presentation column is contained in a sub-element called |
RefHierarchies |
References the presentation hierarchies that belong to the project. Each presentation hierarchy is contained in a sub-element called |
RefLevels |
References the presentation levels that belong to the project. Each presentation level is contained in a sub-element called |
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 |
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 |
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 |
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 |
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 |
The project tag does not include any attributes.
<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>
<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>
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.
<QueryObject …> <Description /> <QueryString …/> </QueryObject>
<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>