PK
o@oa, mimetypeapplication/epub+zipPK o@ iTunesMetadata.plisty
Shows the updated repository in the Administration Tool, with details for the new Billed Qty object shown in the Presentation Column dialog.
PKr PK o@ OEBPS/img_text/xml_ex_2.htmShows the Presentation Column dialog in the Administration Tool for the Billed Qty object.
PK' PK o@ OEBPS/img_text/xml_ex_1.htm:Shows the Administration Tool main window with a logical column called 2-01 Billed Qty (Sum All). The image highlights the fact that there is no corresponding presentation column.
PKՀV? : PK o@ OEBPS/img_text/mds_dirs.htm5Shows a directory listing for C:\SampleApp_MDS\oracle\bi\server\base.
Under the Name column, the folder names for the sub-directories are:
Database
BusinessModel
ComplexJoin
ConnectionPool
CubeTable
InitBlock
PhysicalCatalog
PhysicalDimension
PhysicalHierarchy
PhysicalTable
Schema
Variable
Dimension
LogicalLevel
LogicalTable
LogicalSourceFolder
LogicalTableSource
AggrRule
LogicalComplexJoin
MeasureDefn
PresentationCatalog
Group
ObjectPrivilege
PresentationHierarchy
PresentationLevel
PresentationTable
PrivilegePackage
Project
QualifiedListItem
QualifyingKey
QueryPrivilege
SegCatalog
TargetLevel
User
The left-hand side shows a directory hierarchy, starting with the folder oracle.
The folder bi is indented under oracle.
The folder server is indented under bi.
The folder base is indented under server.
Under the folder base, an indented column of sub-directory names appears, with the following folder names:
AggrRule
Business Model (this value is highlighted as white text on a blue background)
ComplexJoin
ConnectionPool
CubeTable
Database
Dimension
Group
InitBlock
LogicalComplexJoin
LogicalLevel
LogicalSourceFolder
LogicalTable (this value is highlighted as white text on a blue background)
LogicalTableSource (this value is highlighted as white text on a blue background)
MeasureDefn
ObjectPrivilege
PhysicalCatalog
PhysicalDimension
PhysicalHierarchy
PhysicalTable
The right-hand side contains three lists of file names, each of which correspond to and show individual file names for one of the highlighted sub-directory names on the left-hand side.
In each file name list, one of the file names is highlighted with a red surrounding box.
From each highlighted sub-directory name on the left-hand side, a red connector line joins the sub-directory name to the red-boxed file name in the corresponding file name list on the right-hand side, as follows:
The BusinessModel sub-directory connects to the file Fusion Order Demo_80cbbdd2-07d0-0000-714b-e31d00000000.xml
The LogicalTable sub-directory connects to the file F2 Coupon Usages_80cbbde8-07f3-0000-714b-e31d00000000.xml
The LogicalTableSource sub-directory connects to the file COUPON_USAGES_80cbc055-07f5-0000-714b-e31d00000000.xml
Shows the Compare repositories dialog, with the two modified connection pool objects shown.
PK4 PK o@ OEBPS/mds_presentation.htm Presentation elements are typically those elements that are exposed in the Presentation layer, or in other words, the elements that appear in the left-hand pane of the Administration Tool.
This chapter contains the following topics:
The presentation catalog element corresponds to the subject area object in the Presentation layer.
The presentation catalog tag includes the following attributes:
Table 4-1 Presentation Catalog Tag Attributes
Attribute Name | Description |
---|---|
isExportKeys |
If set to true, indicates that logical keys for this subject area are exposed to other applications. |
isAutoAggr |
If set to true, indicates that auto aggregation is enabled. Auto aggregation is the process by which the Oracle BI Server infers the GROUP BY from the attributes projected in the query. Typically auto aggregation is always enabled for queries against the presentation layer. |
hasDispName |
Indicates whether this subject area has a custom display name. |
dispName |
The value of the custom display name, if one exists for this subject area. |
hasDispDescription |
Indicates whether this subject area has a custom description. |
dispDescription |
The value of the custom description, if one exists for this subject area. |
containerRef |
References the container for this presentation catalog. |
subjectAreaRef |
References the business model for this subject area. |
defaultFactColRef |
References the implicit fact column for this subject area, if one has been set. This column is used to specify a default join path between dimension tables when there are several possible alternatives or contexts. |
The presentation catalog tag includes the following child elements:
Table 4-2 Presentation Catalog Child Elements
Element Name | Description |
---|---|
Alias |
Lists any aliases that have been defined for this subject area. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias has an attribute called |
RefTables |
References the presentation tables that belong to this subject area. Each presentation table is contained in a sub-element called |
Syntax
<PresentationCatalog … isExportKeys="" isAutoAggr="" hasDispName="" dispName="" hasDispDescription="" dispDescription"" containerRef="" subjectAreaRef="" defaultFactColumnRef=""> <Description /> <Alias name=""/> <RefTables> <RefPresentationTable presentationTableRef="" …/> <RefPresentationTable presentationTableRef="" …/> </RefTables> </PresentationCatalog>
Example
<PresentationCatalog mdsid="m80d0301d-0fa4-0000-714b-e31d00000000" name="Inventory Org Real Time" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository" hasDispName="false" hasDispDescription="false" subjectAreaRef="/oracle/bi/server/base/BusinessModel/Core_0021f84a-07d0-0000- 714b-e31d00000000.xml#m0021f84a-07d0-0000-714b-e31d00000000" defaultFactColumnRef="/oracle/bi/server/base/LogicalTable/Fact _u0150 InvOrg _u 0150 Dummy Fact for dimension browsing_80d55585-07f3-0000-714b-e31d00000000. xml#m80d5558b-07d6-0000-714b-e31d00000000"> <Description> <![CDATA[ Provides information about inventory organization. ]]> </Description> <Alias name="Oracle Inventory Real Time" /> <Alias name="OTBI - Oracle Inventory" /> <RefTables> <RefPresentationTable refId="m80d0301d-0fa4-0000-714b-e31d00000000-m80d0301f- 0fa8-0000-714b-e31d00000000" presentationTableRef="/oracle/bi/server/base/PresentationTable/Inventory Organization 80d0301f-0fa8-0000-714b-e31d00000000.xml#m80d0301f-0fa8-0000- 714b-e31d00000000" /> <RefPresentationTable refId="m80d0301d-0fa4-0000-714b-e31d00000000-m80d030b7- 0fa8-0000-714b-e31d00000000" presentationTableRef="/oracle/bi/server/base/PresentationTable/Subinventory _80d030b7-0fa8-0000-714b-e31d00000000.xml#m80d030b7-0fa8-0000-714b- e31d00000000" /> <RefPresentationTable refId="m80d0301d-0fa4-0000-714b-e31d00000000-m80d031aa- 0fa8-0000-714b-e31d00000000" presentationTableRef="/oracle/bi/server/base/PresentationTable/Locator_ 80d031aa-0fa8-0000-714b-e31d00000000.xml#m80d031aa-0fa8-0000-714b- e31d00000000" /> <RefPresentationTable refId="m80d0301d-0fa4-0000-714b-e31d00000000-m80d65acb- 0fa8-0000-714b-e31d00000000" presentationTableRef="/oracle/bi/server/base/PresentationTable/Fact _u0150 InvOrg _u0150 Dummy Fact for dimension browsing_80d65acb-0fa8-0000-714b- e31d00000000.xml#m80d65acb-0fa8-0000-714b-e31d00000000" /> </RefTables> </PresentationCatalog>
The presentation table element corresponds to the presentation table object in the Presentation layer.
The presentation table tag includes the following attributes:
Table 4-3 Presentation Table Tag Attributes
Attribute Name | Description |
---|---|
hasDispName |
Indicates whether this presentation table has a custom display name. |
dispName |
The value of the custom display name, if one exists for this presentation table. |
hasDispDescription |
Indicates whether this presentation table has a custom description. |
dispDescription |
The value of the custom description, if one exists for this presentation table. |
containerRef |
References the presentation catalog for this presentation table. |
The presentation table tag includes the following child elements:
Table 4-4 Presentation Table Child Elements
Element Name | Description |
---|---|
Alias |
Lists any aliases that have been defined for this presentation table. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias has an attribute called |
PresentationColumn |
References the presentation columns that belong to this presentation table. For details, see Section 4.3, "MDS XML Elements: Presentation Column." |
RefHierarchies |
References the hierarchies for this presentation table. Each hierarchy is contained in a sub-element called |
Syntax
The syntax here includes the summary child element entry for the presentation column element. The full syntax for the presentation column element appears in Section 4.3, "MDS XML Elements: Presentation Column."
<PresentationTable … hasDispName="" dispName="" hasDispDescription="" dispDescription="" containerRef=""> <Description /> <Alias name="" /> <PresentationColumn /> <RefHierarchies> <RefPresentationHierarchy presentationHierarchyRef="" …/> <RefPresentationHierarchy presentationHierarchyRef="" …/> </RefHierarchies> </PresentationTable>
Example
<PresentationTable mdsid="m80ebeef8-0fa8-0000-714b-e31d00000000" name="Class" iconIndex="93" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository" hasDispName="false" hasDispDescription="false" containerRef="/oracle/bi/server/base/PresentationCatalog/OTBI HCM Stock Details_80ebeef7-0fa4-0000-714b-e31d00000000.xml#m80ebeef7-0fa4-0000-714b- e31d00000000"> <Alias name="Dim - Class" /> <PresentationColumn mdsid="m80ebefb7-0faa-0000-714b-e31d00000000" name="Class" hasDispName="false" hasDispDescription="false" overrideLogicalName="false" logicalColumnRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Class_ 80dc7e5c-07f3-0000-714b-e31d00000000.xml#m80dbc57a-07d6-0000-714b- e31d00000000"> </PresentationColumn> <PresentationColumn mdsid="m80ebefb9-0faa-0000-714b-e31d00000000" name="ClassType" hasDispName="false" hasDispDescription="false" overrideLogicalName="false" logicalColumnRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Class_ 80dc7e5c-07f3-0000-714b-e31d00000000.xml#m80dbc580-07d6-0000-714b- e31d00000000"> </PresentationColumn> <RefHierarchies> <RefPresentationHierarchy refId="m80ebeef8-0fa8-0000-714b-e31d00000000- m80ebeef9-0fbc-0000-714b-e31d00000000" presentationHierarchyRef="/oracle/bi/server/base/PresentationHierarchy/ Class_80ebeef9-0fbc-0000-714b-e31d00000000.xml#m80ebeef9-0fbc-0000-714b- e31d00000000" /> </RefHierarchies> </PresentationTable>
The presentation column element corresponds to the presentation column object in the Presentation layer.
The presentation column element is not a top-level element - it appears as a child element of the presentation table element.
The presentation column tag includes the following attributes:
Table 4-5 Presentation Column Tag Attributes
Attribute Name | Description |
---|---|
overrideLogicalName |
Indicates whether the presentation column has been configured to always use the logical column name. This option corresponds to Use Logical Column Name in the Administration Tool. A |
hasDispName |
Indicates whether this presentation column has a custom display name. |
dispName |
The value of the custom display name, if one exists for this presentation column. |
hasDispDescription |
Indicates whether this presentation column has a custom description. |
dispDescription |
The value of the custom description, if one exists for this presentation column. |
logicalColumnRef |
References the logical column upon which this presentation column is based. |
The presentation column tag includes the following child elements:
Table 4-6 Presentation Column Child Elements
Attribute Name | Description |
---|---|
Alias |
Lists any aliases that have been defined for this presentation column. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias has an attribute called |
Syntax
<PresentationColumn … overideLogicalName="" hasDispName="" dispName="" hasDispDescription="" dispDescription="" logicalColumnRef=""> <Description /> <Alias name="" /> </PresentationColumn>
Example
<PresentationColumn mdsid="m80ebefb7-0faa-0000-714b-e31d00000000" name="Class" hasDispName="false" hasDispDescription="false" overrideLogicalName="false" logicalColumnRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Class_ 80dc7e5c-07f3-0000-714b-e31d00000000.xml#m80dbc57a-07d6-0000-714b- e31d00000000"> </PresentationColumn>
The presentation hierarchy element corresponds to the presentation hierarchy object in the Presentation layer.
The presentation hierarchy tag includes the following attributes:
Table 4-7 Presentation Hierarchy Tag Attributes
Attribute Name | Description |
---|---|
hasDispName |
Indicates whether this presentation hierarchy has a custom display name. |
dispName |
The value of the custom display name, if one exists for this presentation hierarchy. |
hasDispDescription |
Indicates whether this presentation hierarchy has a custom description. |
dispDescription |
The value of the custom description, if one exists for this presentation hierarchy. |
containerRef |
References the presentation table for this presentation hierarchy. |
logicalDimensionRef |
References the logical dimension upon which this presentation hierarchy is based. |
The presentation hierarchy tag includes the following child elements:
Table 4-8 Presentation Hierarchy Child Elements
Element Name | Description |
---|---|
RefLevels |
References the presentation levels for this presentation hierarchy. Each presentation level is contained in a sub-element called RefPresentationLevel. |
Alias |
Lists any aliases that have been defined for this presentation hierarchy. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias has an attribute called |
RefDisplayColumns |
For parent-child hierarchies only. This element references the columns designated to be used for display for this parent-child hierarchy. Each display column is contained in a sub-element called |
Syntax
<PresentationHierarchy … hasDisplayName="" displayName="" hasDispDescription="" dispDescription="" containerRef="" logicalDimensionRef=""/> <Description /> <RefLevels> <RefPresentationLevel presentationLevelRef=""/> <RefPresentationLevel presentationLevelRef=""/> </RefLevels> <Alias name="" /> <RefDisplayColumns> <RefPresentationColumn presentationColumnRef="" …/> <RefPresentationColumn presentationColumnRef="" …/> </RefDisplayColumns> </PresentationHierarchy>
Example
<PresentationHierarchy mdsid="m80ebe037-0fbc-0000-714b-e31d00000000" name="Freight Terms" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository" hasDispName="false" hasDispDescription="false" containerRef="/oracle/bi/server/base/PresentationTable/Freight Terms_80ebe021- 0fa8-0000-714b-e31d00000000.xml#m80ebe021-0fa8-0000-714b-e31d00000000" logicalDimensionRef="/oracle/bi/server/base/Dimension/Freight Terms_0015594f- 07e3-0000-714b-e31d00000000.xml#m0015594f-07e3-0000-714b-e31d00000000"> <RefLevels> <RefPresentationLevel refId="m80ebe037-0fbc-0000-714b-e31d00000000-m80ebe049- 0fbe-0000-714b-e31d00000000" presentationLevelRef="/oracle/bi/server/base/PresentationLevel/Dim _u0150 Freight Terms Total_80ebe049-0fbe-0000-714b-e31d00000000.xml#m80ebe049- 0fbe-0000-714b-e31d00000000" /> <RefPresentationLevel refId="m80ebe037-0fbc-0000-714b-e31d00000000-m80ebe04a- 0fbe-0000-714b-e31d00000000" presentationLevelRef="/oracle/bi/server/base/PresentationLevel/Dim _u0150 Freight Terms Detail_80ebe04a-0fbe-0000-714b-e31d00000000.xml#m80ebe04a- 0fbe-0000-714b-e31d00000000" /> </RefLevels> </PresentationHierarchy>
The presentation level element corresponds to the presentation level object in the Presentation layer.
The presentation level tag includes the following attributes:
Table 4-9 Presentation Level Tag Attributes
Attribute Name | Description |
---|---|
hasDispName |
Indicates whether this presentation level has a custom display name. |
dispName |
The value of the custom display name, if one exists for this presentation level. |
hasDispDescription |
Indicates whether this presentation level has a custom description. |
dispDescription |
The value of the custom description, if one exists for this presentation level. |
containerRef |
References the presentation hierarchy to which this presentation level belongs. |
logicalLevelRef |
References the logical level upon which this presentation level is based. |
The presentation level tag includes the following child elements:
Table 4-10 Presentation Level Child Elements
Element Name | Description |
---|---|
RefDrillTo |
References the levels for cross-dimension drill-down operations, as in the case of a Region dimension with a City level that can have a "drill to" level Year in the Time dimension. |
RefDisplayColumns |
References the columns that have been designated to be used for display for this presentation level (on drill-down). Each column is contained in a sub-element called |
Alias |
Lists any aliases that have been defined for this presentation level. Aliases are created when presentation objects are renamed to ensure that any references to the old names still work in logical SQL queries. Each alias has an attribute called |
Syntax
<PresentationLevel … hasDisplayName="" displayName="" hasDispDescription="" dispDescription="" containerRef="" logicalLevelRef=""/> <Description /> <RefDrillTo> <RefPresentationLevel presentationLevelRef="" …/> <RefPresentationLevel presentationLevelRef="" …/> </RefDrillTo> <RefDisplayColumns> <RefPresentationColumn presentationColumnRef="" …/> <RefPresentationColumn presentationColumnRef="" …/> </RefDisplayColumns> <Alias name="" /> </PresentationLevel>
Example
<PresentationLevel mdsid="m80de558f-0fbe-0000-714b-e31d00000000" name="Position Type" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oracle.com/obis/repository" hasDispName="false" hasDispDescription="false" containerRef="/oracle/bi/server/base/PresentationHierarchy/HR Positions_80de 558d-0fbc-0000-714b-e31d00000000.xml#m80de558d-0fbc-0000-714b-e31d00000000" logicalLevelRef="/oracle/bi/server/base/LogicalLevel/Position Type_002e58f1- 07e9-0000-714b-e31d00000000.xml#m002e58f1-07e9-0000-714b-e31d00000000"> <RefDisplayColumns> <RefPresentationColumn refId="m80de558f-0fbe-0000-714b-e31d00000000- m80de5584-0faa-0000-714b-e31d00000000" presentationColumnRef="/oracle/bi/server/base/PresentationTable/HR Position_80de558c-0fa8-0000-714b-e31d00000000.xml#m80de5584-0faa-0000- 714b-e31d00000000" /> <RefPresentationColumn refId="m80de558f-0fbe-0000-714b-e31d00000000- m80de5585-0faa-0000-714b-e31d00000000" presentationColumnRef="/oracle/bi/server/base/PresentationTable/HR Position_80de558c-0fa8-0000-714b-e31d00000000.xml#m80de5585-0faa-0000- 714b-e31d00000000" /> </RefDisplayColumns> </PresentationLevel>
This chapter describes the MDS XML API elements for Oracle Marketing Segmentation objects, security objects, and miscellaneous objects 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. |
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>
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>
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>
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>
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>
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>
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>