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

4 MDS XML Presentation Elements

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

This chapter contains the following topics:

4.1 MDS XML Elements: Presentation Catalog

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

RefTables

References the presentation tables that belong to this subject area.

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

VisibilityFilter

Contains the expression specified to control the visibility of this object in Answers and BI Composer. This element corresponds to the Hide object if field in the Administration Tool.

The expression is contained in two sub-elements called ExprText and ExprTextDesc.


Syntax

<PresentationCatalog …
     isExportKeys=""
     isAutoAggr=""
     hasDispName=""
     dispName=""
     hasDispDescription=""
     dispDescription""
     containerRef=""
     subjectAreaRef=""
     defaultFactColumnRef="">
   <Description />
   <Alias name=""/>
   <RefTables>
     <RefPresentationTable presentationTableRef="" …/>
     <RefPresentationTable presentationTableRef="" …/>
   </RefTables>
   <VisibilityFilter>
     <ExprText …/>
     <ExprTextDesc …/>
   </VisibilityFilter>
</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>

4.2 MDS XML Elements: Presentation Table

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

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

VisibilityFilter

Contains the expression specified to control the visibility of this object in Answers and BI Composer. This element corresponds to the Hide object if field in the Administration Tool.

The expression is contained in two sub-elements called ExprText and ExprTextDesc.

RefContentFolders

References any child presentation tables that have been designated for this presentation table. Child presentation tables appear as nested folders in Answers and BI Composer.

Note that the folders only appear to be nested - they are not actually nested in terms of drill-down, and the qualified names of the objects remain the same.

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


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>
   <VisibilityFilter>
     <ExprText …/>
     <ExprTextDesc …/>
   </VisibilityFilter>
   <RefContentFolders>
     <RefPresentationTable presentationTableRef="" …/>
   </RefContentFolders>
</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>

4.3 MDS XML Elements: Presentation Column

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 false value for this attribute indicates that this option has been selected.

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

VisibilityFilter

Contains the expression specified to control the visibility of this object in Answers and BI Composer. This element corresponds to the Hide object if field in the Administration Tool.

The expression is contained in two sub-elements called ExprText and ExprTextDesc.


Syntax

<PresentationColumn …
     overideLogicalName=""
     hasDispName=""
     dispName=""
     hasDispDescription=""
     dispDescription=""
     logicalColumnRef="">
   <Description />
   <Alias name="" />
   <VisibilityFilter>
     <ExprText …/>
     <ExprTextDesc …/>
   </VisibilityFilter>
</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>

4.4 MDS XML Elements: Presentation Hierarchy

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

PresentationLevel

References the presentation levels for this presentation hierarchy.

For details, see Section 4.5, "MDS XML Elements: Presentation Level."

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

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

VisibilityFilter

Contains the expression specified to control the visibility of this object in Answers and BI Composer. This element corresponds to the Hide object if field in the Administration Tool.

The expression is contained in two sub-elements called ExprText and ExprTextDesc.


Syntax

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

<PresentationHierarchy …
     hasDisplayName=""
     displayName=""
     hasDispDescription=""
     dispDescription=""
     containerRef=""
     logicalDimensionRef=""/>
   <Description /> 
   <Alias name="" />
   <PresentationLevel />
   <RefDisplayColumns>
     <RefPresentationColumn presentationColumnRef="" …/>
     <RefPresentationColumn presentationColumnRef="" …/>
   </RefDisplayColumns>
   <VisibilityFilter>
     <ExprText …/>
     <ExprTextDesc …/>
   </VisibilityFilter>
</PresentationHierarchy>

Example

<PresentationHierarchy mdsid="m80bee414-0fbc-0000-714b-e31d00000000" 
   name="Product - Category" 
   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/80beb309-
    0fa8-0000-714b-e31d00000000.xml#m80beb309-0fa8-0000-714b-e31d00000000"
   logicalDimensionRef="/oracle/bi/server/base/Dimension/80beaf01-
    07e3-0000-714b-e31d00000000.xml#m80beaf01-07e3-0000-714b-e31d00000000">
   <PresentationLevel mdsid="m80bee419-0fbe-0000-714b-e31d00000000" 
     name="Category" hasDispName="false" hasDispDescription="false"
     containerRef="/oracle/bi/server/base/PresentationHierarchy/80bee414-0fbc-
      0000-714b-e31d00000000.xml#m80bee414-0fbc-0000-714b-e31d00000000"
     logicalLevelRef="/oracle/bi/server/base/Dimension/80beaf01-07e3-
      0000-714b-e31d00000000.xml#m80beafc1-07e9-0000-714b-e31d00000000">
     <RefDisplayColumns>
       <RefPresentationColumn refId="m80bee419-0fbe-0000-714b-e31d00000000-
          m80beb2a7-0faa-0000-714b-e31d00000000"
         presentationColumnRef="/oracle/bi/server/base/PresentationTable/80beb309-
          0fa8-0000-714b-e31d00000000.xml#m80beb2a7-0faa-0000-714b-
          e31d00000000" /> 
       <RefPresentationColumn refId="m80bee419-0fbe-0000-714b-e31d00000000-
          m80beb2a9-0faa-0000-714b-e31d00000000"
         presentationColumnRef="/oracle/bi/server/base/PresentationTable/80beb309-
          0fa8-0000-714b-e31d00000000.xml#m80beb2a9-0faa-0000-714b-
          e31d00000000" /> 
     </RefDisplayColumns>
   </PresentationLevel>
   <PresentationLevel mdsid="m80bee41a-0fbe-0000-714b-e31d00000000"
     name="Product" hasDispName="false" hasDispDescription="false"
     containerRef="/oracle/bi/server/base/PresentationHierarchy/80bee414-0fbc-
      0000-714b-e31d00000000.xml#m80bee414-0fbc-0000-714b-e31d00000000"
     logicalLevelRef="/oracle/bi/server/base/Dimension/80beaf01-07e3-
      0000-714b-e31d00000000.xml#m80beafc3-07e9-0000-714b-e31d00000000">
     <RefDisplayColumns>
       <RefPresentationColumn refId="m80bee41a-0fbe-0000-714b-e31d00000000-
          m80beb295-0faa-0000-714b-e31d00000000"          presentationColumnRef="/oracle/bi/server/base/PresentationTable/80beb309-
          0fa8-0000-714b-e31d00000000.xml#m80beb295-0faa-0000-714b-
          e31d00000000" /> 
       <RefPresentationColumn refId="m80bee41a-0fbe-0000-714b-e31d00000000-
          m80beb297-0faa-0000-714b-e31d00000000"
         presentationColumnRef="/oracle/bi/server/base/PresentationTable/80beb309-
          0fa8-0000-714b-e31d00000000.xml#m80beb297-0faa-0000-714b-
          e31d00000000" /> 
     </RefDisplayColumns>
   </PresentationLevel>
</PresentationHierarchy>

4.5 MDS XML Elements: Presentation Level

The presentation level element corresponds to the presentation level object in the Presentation layer.

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

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

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

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

VisibilityFilter

This child element is not used.


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" 
   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>