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

2 MDS XML Logical Elements

This chapter provides MDS XML reference information for logical elements. Logical elements typically correspond to objects in the Business Model and Mapping layer of the Oracle BI repository, or in other words, the objects that appear in the center pane of the Oracle BI Administration Tool.

This chapter contains the following topics:

2.1 MDS XML Elements: Logical Column

The logical column element corresponds to the logical column object in the Business Model and Mapping layer.

The logical column element is not a top-level element - it appears as a child element of the logical table element.

The logical column tag includes the following attributes:

Table 2-1 Logical Column Tag Attributes

Attribute Name Description

isDerived

When set to true, indicates that the logical column is based on a user-defined expression (for example, another logical column, a constant value, or a variable).

IsWriteable

When set to true, indicates that write back has been enabled for this column. This feature is typically used with ADF Business Component data sources. This option is called Writeable in the Administration Tool.

customSortOrderRef

If the sort order for this logical column is based on a different logical column, this attribute references that logical column.

descriptorIDRef

When multilingual columns are based on a lookup function, it is common to specify the non-translated lookup key column as the descriptor ID column of the translated column. This attribute references the descriptor ID column.


The logical column tag includes the following child elements:

Table 2-2 Logical Column Child Elements

Element Name Description

Expr

Contains the expression from which the logical column should be derived. This element is only used when the isDerived attribute is set to true.

MeasureDefn

Contains the measure definition for a measure column. See Section 2.11, "MDS XML Elements: Measure Definition" for more information.

AttrDefn

Specifies the internal object to cache the logical column's mapping to the physical layer.


Syntax

<LogicalColumn …
     isDerived=""
     isWriteable="
     customSortOrderRef=""
     descriptorIDRef="">
   <Description />
   <Expr>...</Expr>
   <MeasureDefn />
   <AttrDefn />
</LogicalColumn>

Example

<LogicalColumn mdsid="m8030eac4-07d6-0000-714b-e31d00000000" 
   name="Days Closed Category"
   isDerived="true"
   isWriteable="false">
   <Description>
     <![CDATA[ "Days Closed Category by number of days closed.
        Categories are, A: <= 5, B: 6 - 30, and C: 31+" ]]> 
   </Description>
   <Expr>
     <ExprText>
       <![CDATA[ CASE WHEN "%1" IS NULL THEN 'A: <=5' 
        WHEN "%1" <= 5 THEN 'A: <= 5' 
        WHEN "%1" <= 30 THEN 'B: 6 - 30' 
        ELSE 'C: 31+' END ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ CASE 
        WHEN "Contact List"."Service Request"."Days Closed" IS NULL THEN 'A: <=5'
        WHEN "Contact List"."Service Request"."Days Closed" <= 5 THEN 'A: <= 5'
        WHEN "Contact List"."Service Request"."Days Closed" <= 30 THEN 'B: 6 - 30'
        ELSE 'C: 31+' END ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m8030eac4-07d6-0000-714b-e31d00000000-m8030eac2-07d6-
          0000-714b-e31d00000000"
         objectTypeId="2006"
         objectRef="/oracle/bi/server/base/LogicalTable/Service Request_8030ea6a-
          07f3-0000-714b-e31d00000000.xml#m8030eac2-07d6-0000-714b-e31d00000000"/> 
     </ObjectRefList>
   </Expr>
</LogicalColumn>

2.2 MDS XML Elements: Business Model

The business model element corresponds to the business model object in the Business Model and Mapping layer.

The business model tag includes the following attributes:

Table 2-3 Business Model Tag Attributes

Attribute Name Description

isClassicStar

If set to true, indicates that the business model follows a star schema. Star schemas have one-to-many relationships between the logical dimension tables and the logical fact table.

isAvailable

If set to true, indicates that the corresponding business model is available for queries.


The business model tag includes the following child elements:

Table 2-4 Business Model Child Elements

Element Name Description

RefDisplayFolders

References the display folders that belong to this business model.

Each display folder is contained in a sub-element called RefLogicalDisplayFolder.


Syntax

<BusinessModel …
     isClassicStar=""
     isAvailable="">
   <Description />
   <RefDisplayFolders>
     <RefLogicalDisplayFolder logicalDisplayFolderRef="" …/>
     <RefLogicalDisplayFolder logicalDisplayFolderRef="" …/>
   </RefDisplayFolders>
</BusinessModel>

Example

<BusinessModel mdsid="m1d08ed10-0bf4-1000-806e-0a9716a80000" 
   name="Real-Time Activity" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository"
   isClassicStar="false"
   isAvailable="true">
   <RefDisplayFolders>
     <RefLogicalDisplayFolder refId="m1d08ed10-0bf4-1000-806e-0a9716a80000-
        m1d0ae8e0-0bf4-1000-806e-0a9716a80000"
       logicalDisplayFolderRef="/oracle/bi/server/base/LogicalDisplayFolder/F1_
        1d0ae8e0-0bf4-1000-806e-0a9716a80000.xml#m1d0ae8e0-0bf4-1000-806e-
        0a9716a80000" />
     <RefLogicalDisplayFolder refId="m1d08ed10-0bf4-1000-806e-0a9716a80000-
        m4edbf441-0bf9-1000-a1a7-0a970e580000"
       logicalDisplayFolderRef="/oracle/bi/server/base/LogicalDisplayFolder/F2_
        4edbf441-0bf9-1000-a1a7-0a970e580000.xml#m4edbf441-0bf9-1000-a1a7-
        0a970e580000" /> 
   </RefDisplayFolders>
</BusinessModel>

2.3 MDS XML Elements: Logical Complex Join

The logical complex join element corresponds to the logical join object in the Business Model and Mapping Layer.

The logical complex join tag includes the following attributes:

Table 2-5 Logical Complex Join Tag Attributes

Attribute Name Description

type

The type of join. Valid values are Inner, LeftOuter, RightOuter, FullOuter, and FullOuterStitch.

drivingTableRef

If a driving table has been specified for the key, this attribute references that logical table.

logicalTable1Ref

References the first logical table of the join.

multiplicity1

multiplicity1 and multiplicity2 indicate the multiplicity of the tables in the join. Valid values are ([0-9])* TO ([0-9])*, ZERO TO ONE, ZERO TO MANY, ONE TO ONE, ONE TO MANY, and UNKNOWN.

isAggregate1

isAggregate1 and isAggregate2 indicate whether the corresponding table is an aggregate.

logicalTable2Ref

References the second logical table of the join.

multiplicity2

(See Description for multiplicity1.)

isAggregate2

(See Description for isAggregate1.)


Syntax

<LogicalComplexJoin …
     type=""
     drivingTableRef=""
     logicalTable1Ref=""
     multiplicity1=""
     isAggregate1=""
     logicalTable2Ref=""
     multiplicity2=""
     isAggregate2="">
   <Description />
</LogicalComplexJoin>

Example

<LogicalComplexJoin mdsid="m80e70525-07d4-0000-714b-e31d00000000"
   name="Relationship_2004:9974601258446906"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository"
   type="Inner"
   logicalTable1Ref="/oracle/bi/server/base/LogicalTable/Dim Rating Model 80d6
    3a05-07f3-0000-714b-e31d00000000.xml#m80d63a05-07f3-0000-714b-e31d00000000"
   multiplicity1="0..1" 
   isAggregate1="false" 
   logicalTable2Ref="/oracle/bi/server/base/LogicalTable/Fact Performance Rating_
    80d12881-07f3-0000-714b-e31d00000000.xml#m80d1288107f3-0000-714b-e31d00000000"
   multiplicity2="0..n" 
   isAggregate2="false">
</LogicalComplexJoin>

2.4 MDS XML Elements: Logical Level

The logical level element corresponds to the logical level object contained in the dimensions in the Business Model and Mapping layer.

The logical level element is not a top-level element - it appears as a component element of the dimension element.

The logical level tag includes the following attributes:

Table 2-6 Logical Level Tag Attributes

Attribute Name Description

isUniqueSourceKey

If set to true, indicates that this level is associated with the logical column or columns that comprise the logical key of the dimension table (or in other words, that this level is the lowest level of the dimension).

isGTA

If set to true, indicates that this level is the Grand Total level, which is a special level representing the grand total for a dimension. Each dimension can have just one Grand Total level. A grand total level does not contain dimensional attributes and does not have a level key.

Note: GTA stands for Grand Total Alias.

isFDUC

If set to true, indicates that the logical level rolls up to its parent. This option is called Supports rollup to higher level of aggregation in the Administration Tool.

Note: FDUC stands for FullDrillUpCoverage.

levelConst

The star schema level constant.

memberCount

The number of elements that exist at this logical level.


The logical level tag includes the following child elements:

Table 2-7 Logical Level Child Elements

Element Name Description

Logical Key

References the parent key for this level (for dimensions with parent-child hierarchies only).

The parent key is contained in a sub-element called RefColumns. For details, see Section 2.8, "MDS XML Elements: Logical Key."

RefChildLevels

References the child levels that have been defined for this logical level.

Each child level is contained in a sub-element called RefLogicalLevel.

RefPreferredDrillDown

If a drill path has been defined that is outside the normal drill path defined by the dimension level hierarchy, this element references the level to which users should drill.

The preferred drill level is contained in a sub-element called RefLogicalLevel.

RefLogicalColumns

References the logical columns associated with this logical level.

Each logical column is contained in a sub-element called RefLogicalColumn.


Syntax

The syntax here includes the summary child element entry for the logical key element. The full syntax for the logical key element appears in Section 2.8, "MDS XML Elements: Logical Key."

<LogicalLevel …
     isUniqueSourceKey=""
     isGTA=""
     isFDUC=""
     levelConst=""
     memberCount="">
   <Description />
   <LogicalKey />
   <RefChildLevels>
     <RefLogicalLevel logicalLevelRef="" …/>
   </RefChildLevels>
   <RefPreferredDrillDown>
     <RefLogicalLevel logicalLevelRef="" …/>
   </RefPreferredDrillDown>
   <RefLogicalColumns>
     <RefLogicalColumn logicalColumnRef="" …/>
   </RefLogicalColumns>
</LogicalLevel>

Example

<LogicalLevel mdsid="m80334c74-07e9-0000-714b-e31d00000000" 
   name="Year" 
   isGTA="false" 
   isFDUC="true" 
   memberCount="1" 
   levelConst="'Year'">
   <LogicalKey mdsid="m80334d04-07d8-0000-714b-e31d00000000" 
     name="Last Login Year" 
     isPrimary="true" 
     isForDrillDown="true">
     <RefColumns>
       <RefLogicalColumn refId="m80334d04-07d8-0000-714b-e31d00000000-m80334ca2-
          07d6-0000-714b-e31d00000000"
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/Dim Last Login 
          Date_80334c8e-07f3-0000-714b-e31d00000000.xml#m80334ca2-07d6-0000-714b-
          e31d00000000" /> 
     </RefColumns>
   </LogicalKey>
   <RefChildLevels>
     <RefLogicalLevel refId="m80334c74-07e9-0000-714b-e31d00000000_m80334c75-
        07e9-0000-714b-e31d00000000"
       logicalLevelRef="/oracle/bi/server/base/LogicalLevel/Quarter_80334c75-
        07e9-0000-714b-e31d00000000.xml#m80334c75-07e9-0000-714b-e31d00000000" /> 
   </RefChildLevels>
   <RefLogicalColumns>
       <RefLogicalColumn refId="m80334c74-07e9-0000-714b-e31d00000000-m80334ca2-
          07d6-0000-714b-e31d00000000"
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/Dim Last Login Date
          _80334c8e-07f3-0000-714b-e31d00000000.xml#m80334ca2-07d6-0000-714b-
          e31d00000000" /> 
   </RefLogicalColumns>
</LogicalLevel>

2.5 MDS XML Elements: Dimension

The dimension element corresponds to the dimension object in the Business Model and Mapping layer.

The dimension tag includes the following attributes:

Table 2-8 Dimension Tag Attributes

Attribute Name Description

isTimeDim

If set to true, indicates that this dimension is a time dimension.

isRagged

If set to true, indicates that this dimension hierarchy is unbalanced. An unbalanced hierarchy is one that contains levels that are not at the same depth.

isSkipped

If set to true, indicates that this dimension hierarchy is a skip-level hierarchy. A skip-level hierarchy is one in which there are members that do not have a value for a particular parent level.

isValueBased

If set to true, indicates that this object is a dimension with parent-child hierarchies. A parent-child hierarchy is a hierarchy of members that all have the same type. In a parent-child hierarchy, the inter-member relationships are parent-child relationships between dimension members.

defaultRootLevelRef

References the default root level of this dimension. When there are many root levels in a dimension, the default root level is the one that is used for drilldown.

subjectAreaRef

References the business model of this dimension.


The dimension tag includes the following child elements:

Table 2-9 Dimension Child Elements

Element Name Description

LogicalLevel

References the logical levels for this dimension.

For details, see Section 2.4, "MDS XML Elements: Logical Level."


Syntax

The syntax here includes the summary child element entry for the logical level element. The full syntax for the logical level element appears in Section 2.4, "MDS XML Elements: Logical Level."

<Dimension …
     isTimeDim=""
     isRagged=""
     isSkipped=""
     isValueBased=""
     defaultRootLevelRef=""
     subjectAreaRef="">
   <Description />
   <LogicalLevel />
</Dimension>

Example

<Dimension mdsid="m80be897c-07e3-0000-714b-e31d00000000"
   name="Time"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository" 
   isValueBased="false" 
   isRagged="false" 
   isSkipped="false" 
   defaultRootLevelRef="/oracle/bi/server/base/Dimension/80be897c-07e3-
    0000-714b-e31d00000000.xml#m80be8d55-07e9-0000-714b-e31d00000000"
   subjectAreaRef="/oracle/bi/server/base/BusinessModel/80be895f-07e3-
    0000-714b-e31d00000000.xml#m80be895f-07d0-0000-714b-e31d00000000">
   <LogicalLevel mdsid="m80be8d55-07e9-0000-714b-e31d00000000" 
     name="Year" isGTA="false" isFDUC="true" 
     memberCount="1" levelConst="&apos;Year&apos;">
     <LogicalKey mdsid="m80be9271-07d8-0000-714b-e31d00000000" 
       name="Year" isPrimary="true" isForDrillDown="true">
       <RefColumns>
         <RefLogicalColumn refId="m80be9271-07d8-0000-714b-e31d00000000-m80be8ba5-
            07d6-0000-714b-e31d00000000"
           logicalColumnRef="/oracle/bi/server/base/LogicalTable/80be8ba4-07f3-
            0000-714b-e31d00000000.xml#m80be8ba5-07d6-0000-714b-e31d00000000"/>
       </RefColumns>
     </LogicalKey>
     <RefChildLevels>
       <RefLogicalLevel refId="m80be8d55-07e9-0000-714b-e31d00000000_m80be8d56-
          07e9-0000-714b-e31d00000000_1"
         logicalLevelRef="/oracle/bi/server/base/Dimension/80be897c-07e3-
          0000-714b-e31d00000000.xml#m80be8d56-07e9-0000-714b-e31d00000000"/>
     </RefChildLevels>
     <RefLogicalColumns>
       <RefLogicalColumn refId="m80be8d55-07e9-0000-714b-e31d00000000-m80be8ba5-
          07d6-0000-714b-e31d00000000"
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/80be8ba4-
          07f3-0000-714b-e31d00000000.xml#m80be8ba5-07d6-0000-714b-e31d00000000"/>
     </RefLogicalColumns>
   </LogicalLevel>
   <LogicalLevel mdsid="m80be8d56-07e9-0000-714b-e31d00000000" 
     name="Quarter" isGTA="false" isFDUC="true" 
     memberCount="1" levelConst="&apos;Quarter&apos;">
     <LogicalKey mdsid="m80be9273-07d8-0000-714b-e31d00000000" 
       name="Quarter" isPrimary="true" isForDrillDown="true">
       <RefColumns>
         <RefLogicalColumn refId="m80be9273-07d8-0000-714b-e31d00000000-m80be8ba5-
            07d6-0000-714b-e31d00000000"
           logicalColumnRef="/oracle/bi/server/base/LogicalTable/80be8ba4-07f3-
            0000-714b-e31d00000000.xml#m80be8ba5-07d6-0000-714b-e31d00000000"/>
         <RefLogicalColumn refId="m80be9273-07d8-0000-714b-e31d00000000-m80be8ba6-
            07d6-0000-714b-e31d00000000"
           logicalColumnRef="/oracle/bi/server/base/LogicalTable/80be8ba4-07f3-
            0000-714b-e31d00000000.xml#m80be8ba6-07d6-0000-714b-e31d00000000"/>
       </RefColumns>
     </LogicalKey>
     <RefLogicalColumns>
       <RefLogicalColumn refId="m80be8d56-07e9-0000-714b-e31d00000000-m80be8ba6-
          07d6-0000-714b-e31d00000000"
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/80be8ba4-07f3-
          0000-714b-e31d00000000.xml#m80be8ba6-07d6-0000-714b-e31d00000000"/>
     </RefLogicalColumns>
   </LogicalLevel>
</Dimension>

2.6 MDS XML Elements: Logical Table

The logical table element corresponds to the logical table object in the Business Model and Mapping layer.

The logical table tag includes the following attributes:

Table 2-10 Logical Table Tag Attributes

Attribute Name Description

isLookupTable

If set to true, indicates that this logical table is a lookup table.

Lookup tables are typically used to store fields that contain translations in several languages. Queries that require multilingual data join the base table and lookup table to obtain the translated values for each row in the base table.

x

The x coordinate of the table when it is shown in the business model diagrams.

y

The y coordinate of the table when it is shown in the business model diagrams.

subjectAreaRef

References the business model for this logical table.

levelColumnRef

References the column that is used in the level that corresponds to this logical table.


The logical table tag includes the following child elements:

Table 2-11 Logical Table Child Elements

Element Name Description

LogicalColumn

Specifies the logical column that belongs to this logical table. For details, see Section 2.1, "MDS XML Elements: Logical Column."

LogicalKey

References the logical columns in this logical table that make up the logical key.

Each logical column is referenced in a sub-element called RefColumns. For details, see Section 2.8, "MDS XML Elements: Logical Key."

LogicalForeignKey

References the logical key in an external logical table and the logical columns in this logical table that together make up the logical foreign key.

Each logical column is referenced in a sub-element called RefColumns.

For details, see Section 2.7, "MDS XML Elements: Logical Foreign Key."

RefTableSources

References the logical table sources for this logical table.

Each logical table source is contained in a sub-element called RefLogicalTableSource.


Syntax

The syntax here includes summary child element entries for the logical column, logical key, and logical foreign key elements. The full syntax for each child element appears in the appropriate section listed in the following table:

Table 2-12 References to Child Elements of Logical Table Element

Child Element Entry Section Containing Child Element Syntax

LogicalColumn

MDS XML Elements: Logical Column

LogicalKey

MDS XML Elements: Logical Key

LogicalForeignKey

MDS XML Elements: Logical Foreign Key


<LogicalTable …
     isLookupTable=""
     x=""
     y=""
     subjectAreaRef=""
     levelColumnRef="">
   <Description /> 
   <LogicalColumn />
   <LogicalKey />
   <LogicalForeignKey />
   <RefTableSources …>
     <RefLogicalTableSource logicalTableSourceRef="" …/>
     <RefLogicalTableSource logicalTableSourceRef="" …/>
   </TableSources>
</LogicalTable>

Example

<LogicalTable mdsid="me406bc22-0bf1-1000-b290-0ae593200000" 
   name="SalesPlan" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository" 
   x="170" 
   y="97" 
   subjectAreaRef="/oracle/bi/server/base/BusinessModel/SnowflakeSales_e406baec-
    0bf1-1000-b290-0ae593200000.xml#me406baec-0bf1-1000-b290-0ae593200000">
   <LogicalColumn mdsid="me406bc23-0bf1-1000-b290-0ae593200000" 
     name="Category ID" isWriteable="false">
   </LogicalColumn>
   <LogicalColumn mdsid="me406bc24-0bf1-1000-b290-0ae593200000" 
     name="Country" isWriteable="false">
   </LogicalColumn>
   <LogicalColumn mdsid="me406bc25-0bf1-1000-b290-0ae593200000" 
     name="Year" isWriteable="false">
   </LogicalColumn>
   <LogicalColumn mdsid="me406bc26-0bf1-1000-b290-0ae593200000" 
     name="PlanRevenue" isWriteable="false">
   </LogicalColumn>
   <LogicalKey mdsid="me4070952-0bf1-1000-b290-0ae593200000" 
     name="Category ID, Country, Year" 
     isPrimary="true" isForDrillDown="true">
     <RefColumns>
       <RefLogicalColumn refId="me4070952-0bf1-1000-b290-0ae593200000-me406bc23-
          0bf1-1000-b290-0ae593200000" 
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
          0bf1-1000-b290-0ae593200000.xml#me406bc23-0bf1-1000-b290-0ae593200000"/>
       <RefLogicalColumn refId="me4070952-0bf1-1000-b290-0ae593200000-me406bc24-
          0bf1-1000-b290-0ae593200000" 
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
          0bf1-1000-b290-0ae593200000.xml#me406bc24-0bf1-1000-b290-0ae593200000"/>
       <RefLogicalColumn refId="me4070952-0bf1-1000-b290-0ae593200000-me406bc25-
          0bf1-1000-b290-0ae593200000" 
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
          0bf1-1000-b290-0ae593200000.xml#me406bc25-0bf1-1000-b290-0ae593200000"/>
     </RefColumns>
   </LogicalKey>
   <LogicalForeignKey mdsid="me4070a81-0bf1-1000-b290-0ae593200000" 
     name="SalesPlan_FKey" type="Inner" 
     counterPartKeyRef="/oracle/bi/server/base/LogicalTable/Year_e406bbff-0bf1-
      1000-b290-0ae593200000.xml#me407094c-0bf1-1000-b290-0ae593200000">
     <RefColumns>
       <RefLogicalColumn refId="me4070a81-0bf1-1000-b290-0ae593200000-me406bc25-
          0bf1-1000-b290-0ae593200000" 
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
          0bf1-1000-b290-0ae593200000.xml#me406bc25-0bf1-1000-b290-0ae593200000"/> 
     </RefColumns>
   </LogicalForeignKey>
   <LogicalForeignKey mdsid="me4070a82-0bf1-1000-b290-0ae593200000" 
     name="SalesPlan_FKey1" type="Inner" 
     counterPartKeyRef="/oracle/bi/server/base/LogicalTable/Category_e406bbb2-
      0bf1-1000-b290-0ae593200000.xml#me407093e-0bf1-1000-b290-0ae593200000">
     <RefColumns>
       <RefLogicalColumn refId="me4070a82-0bf1-1000-b290-0ae593200000-me406bc23-
          0bf1-1000-b290-0ae593200000" 
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
          0bf1-1000-b290-0ae593200000.xml#me406bc23-0bf1-1000-b290-0ae593200000"/>
     </RefColumns>
   </LogicalForeignKey>
   <LogicalForeignKey mdsid="me4070a83-0bf1-1000-b290-0ae593200000" 
     name="SalesPlan_FKey2" type="Inner" 
     counterPartKeyRef="/oracle/bi/server/base/LogicalTable/EmployeeCountry_
      e406bbee-0bf1-1000-b290-0ae593200000.xml#me4070949-0bf1-1000-b290-
      0ae593200000">
     <RefColumns>
       <RefLogicalColumn refId="me4070a83-0bf1-1000-b290-0ae593200000-me406bc24-
          0bf1-1000-b290-0ae593200000" 
         logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
          0bf1-1000-b290-0ae593200000.xml#me406bc24-0bf1-1000-b290-0ae593200000"/>
     </RefColumns>
   </LogicalForeignKey>
   <RefTableSources>
     <RefLogicalTableSource refId="me406bc22-0bf1-1000-b290-0ae593200000-me4077d88
        -0bf1-1000-b290-0ae593200000" 
       logicalTableSourceRef="/oracle/bi/server/base/LogicalTableSource/SalesPlan_
        e4077d88-0bf1-1000-b290-0ae593200000.xml#me4077d88-0bf1-1000-b290-
        0ae593200000" /> 
   </RefTableSources>
</LogicalTable>

2.7 MDS XML Elements: Logical Foreign Key

The logical foreign key element corresponds to the logical foreign key object in the Business Model and Mapping layer.

The logical foreign key element is not a top-level element - it appears as a component element of the logical table element.

The logical foreign key tag includes the following attributes:

Table 2-13 Logical Foreign Key Tag Attributes

Attribute Name Description

type

The type of join. Valid values are Inner, LeftOuter, RightOuter, FullOuter, and FullOuterStitch.

counterPartKeyRef

References the logical key in the primary key table that matches the RefColumns of this foreign key.

drivingTableRef

If a driving table has been specified for this logical foreign key, this element references that logical table.


The logical foreign key tag includes the following child elements:

Table 2-14 Logical Foreign Key Child Elements

Element Name Description

RefColumns

References the logical columns (in the logical table that contains the foreign key) that match counterPartKeyRef.

Each logical column is contained in a sub-element called RefLogicalColumn.


Syntax

<LogicalForeignKey …
     type=""
     counterPartKeyRef=""
     drivingTableRef="">
   <Description />
   <RefColumns>
     <RefLogicalColumn logicalColumnRef="" …/>
     <RefLogicalColumn logicalColumnRef="" …/>
   </RefColumns>
</LogicalForeignKey>

Example

<LogicalForeignKey mdsid="me4070a83-0bf1-1000-b290-0ae593200000" 
   name="SalesPlan_FKey2" type="Inner" 
   counterPartKeyRef="/oracle/bi/server/base/LogicalTable/EmployeeCountry_
    e406bbee-0bf1-1000-b290-0ae593200000.xml#me4070949-0bf1-1000-b290-
    0ae593200000">
   <RefColumns>
     <RefLogicalColumn refId="me4070a83-0bf1-1000-b290-0ae593200000-me406bc24-
        0bf1-1000-b290-0ae593200000" 
       logicalColumnRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406bc22-
        0bf1-1000-b290-0ae593200000.xml#me406bc24-0bf1-1000-b290-0ae593200000" /> 
   </RefColumns>
</LogicalForeignKey>

2.8 MDS XML Elements: Logical Key

The logical key element corresponds to the logical key object in the Business Model and Mapping layer.

The logical key element is not a top-level element - it appears as a child element of the logical level and logical table elements.

The logical key tag includes the following attributes:

Table 2-15 Logical Key Tag Attributes

Attribute Name Description

isPrimary

If set to true, indicates that this key is the logical primary key for the table.

isForDrillDown

If set to true, indicates that this key is the key that is displayed when a user clicks to drill down.

isChronKey

If set to true, indicates that this key is a chronological key for a time dimension.

logicalLevelRef

References the logical level for this logical key.


The logical key tag includes the following child elements:

Table 2-16 Logical Key Child Elements

Element Name Description

RefColumns

References the logical columns that define the key of the logical table.

Each logical column is contained in a sub-element called RefLogicalColumn.


Syntax

<LogicalKey …
     isPrimary=""
     isForDrillDown=""
     isChronKey=""
     logicalLevelRef="">
   <Description />
   <RefColumns …>
     <RefLogicalColumn logicalColumnRef="" …/>
     <RefLogicalColumn logicalColumnRef="" …/>
   </RefColumns>
</LogicalKey>

Example

<LogicalKey mdsid="m80334d04-07d8-0000-714b-e31d00000000" 
   name="Last Login Year" 
   isPrimary="true" 
   isForDrillDown="true">
   <RefColumns>
     <RefLogicalColumn refId="m80334d04-07d8-0000-714b-e31d00000000-m80334ca2-
        07d6-0000-714b-e31d00000000"
       logicalColumnRef="/oracle/bi/server/base/LogicalTable/Dim Login_880334c8e-
        07f3-0000-714b-e31d00000000.xml#m80334ca2-07d6-0000-714b-e31d00000000" />
   </RefColumns>
</LogicalKey>

2.9 MDS XML Elements: Logical Table Source

The logical table source element corresponds to the logical table source object in the Business Model and Mapping layer. See also the column mapping element, described in Section 2.9.1, "Column Mapping."

The logical table source tag includes the following attributes:

Table 2-17 Logical Table Source Attributes

Attribute Name Description

isDistinct

This attribute is used if the values for the logical table source are unique. In the Administration Tool, this option is called Select distinct values in the Content tab of the Logical Table Source dialog.

isDimOnly

This attribute is not used.

isSysGen

If set to true, indicates that an internal utility such as the Aggregate Persistence Wizard has generated this logical table source.

canCombine

If set to true, indicates that this logical table source can be combined with other logical table sources to provide a full set of results. In the Administration Tool, this option is called This source should be combined with other sources at this level in the Content tab of the Logical Table Source dialog.

isActive

If set to true, indicates that this logical table source is active. In the Administration Tool, this attribute corresponds with the Disabled option in the General tab of the Logical Table Source dialog.

priorityGroup

Indicates the priority group number of this logical table source. Logical table source priority group numbers are assigned to indicate which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.

allowUnmappedTable

Determines if the logical table source can have physical tables which are not mapped to logical columns.

This can occur with a snowflake of physical tables A->B->C, where a logical table maps to columns in A and C, but B needs to be included in the logical table source because it is in the join path between A and C.

isJoinRestricted

This attribute is not used.

logicalTableRef

References the logical table for this logical table source.

closureTableRef

References the parent-child table, if any.


The logical table source tag includes the following child elements:

Table 2-18 Logical Table Source Child Elements

Element Name Description

ColumnMapping

For details, see Section 2.9.1, "Column Mapping."

Link

References the set of physical elements (physical tables, cube tables, AW cubes, or AW dimensions) to which the logical table source is mapped. These links are references to the physical joins that already exist. In the Administration Tool, this element corresponds with the Map to these tables section in the General tab of the Logical Table Source dialog.

Each Link child element contains two sub-elements:

  • The startNodeTableRef attribute references the physical element identified by this link. This can be a Cube Table, Physical Table, AW Dimension, or AW Cube, depending on your data source type.

  • The Joins sub-element defines the joins for this link. It contains different sub-elements, depending on the type of join. For example:

    RefCubeTable, RefPhysicalTable, RefAWCube, or RefAWDimension

    RefPhysicalForeignKey or RefComplexJoin

    DrivingTable, which contains a sub-element RefPhysicalTable

    The Joins sub-element has two attributes: type (Inner, LeftOuter, RightOuter, FullOuter, or FullOuterStitch) and cardinality (ONE TO ONE, ZERO OR ONE TO ONE, ONE TO ZERO OR ONE, ZERO OR ONE TO ZERO OR ONE, ONE TO MANY, ZERO OR ONE TO MANY, ZERO OR ONE TO MANY, MANY TO ONE, MANY TO ZERO OR ONE, or MANY TO MANY).

See the syntax for the logical table source element to see the complete hierarchy for the link child element.

WhereClause

If a WHERE clause filter has been defined, contains the WHERE clause expression that limits the number of rows the source uses in the resultant table. The expression is contained in a sub-element called Expr.

In the Administration Tool, this option is called Use this "WHERE clause" filter to limit rows returned (exclude the "WHERE") in the Content tab of the Logical Table Source dialog.

GroupBy

Contains the expression that defines whether the aggregation is grouped by logical level or by column. The expression is contained in a sub-element called Expr.

In the Administration Tool, this option is called Aggregation content, group by in the Content tab of the Logical Table Source dialog.

FragmentContent

Contains the expression that defines how the source is fragmented. The expression is contained in a sub-element called Expr.

This child element is used in conjunction with the canCombine attribute. In the Administration Tool, this option is called Fragmentation content in the Content tab of the Logical Table Source dialog.


Syntax

The syntax here includes the summary child element entry for the column mapping element. The full syntax for the column mapping element appears in Section 2.9.1, "Column Mapping."

<LogicalTableSource …
     isDistinct=""
     isSysGen=""
     canCombine=""
     isActive=""
     priorityGroup=""
     allowUnmappedTable=""
     logicalTableRef=""
     closureTableRef="">
   <Description />
   <ColumnMapping />
   <Link> 
     startNodeTableRef=""
     <Join
         type=""
         cardinality=""
         physicalTable1Ref=""
         physicalTable2Ref=""
         physicalJoinRef="" >
   </Link>
   <WhereClause />
   <GroupBy />
   <FragmentContent />
</LogicalTableSource>

Note:

Each of the summary syntax elements <WhereClause />, <GroupBy />, and <Fragment Content /> have the following sub-elements:

<ExprText>...</ExprText>
<ExprTextDesc>...</ExprTextDesc>
<ObjectRefList>
  <RefObject objectRef="" …/>
  <RefObject objectRef="" …/>
</ObjectRefList>

Example

<LogicalTableSource mdsid="m80e13d0b-07f5-0000-714b-e31d00000000" 
   name="Fact_W_REVN_F_Team_Security_Resource"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.oracle.com/obis/repository"
   isActive="true"
   logicalTableRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Security _u0150 
    Opportunity_80e13d09-07f3-0000-714b-e31d00000000.xml#m80e13d09-07f3-0000-714b-
    e31d00000000">
   <ColumnMapping>
     <LogicalColumnExpr>
       <ExprText>
          <![CDATA[ "%1" ]]> 
       </ExprText>
       <ExprTextDesc>
          <![CDATA[ "Core"."Dim - Security - Opportunity"."Row Wid" ]]> 
       </ExprTextDesc>
       <ObjectRefList>
         <RefObject refId="m80e13d0b-07f5-0000-714b-e31d00000000-m80e13d0d-07d6-
            0000-714b-e31d00000000"
           objectTypeId="2006"
           objectRef="/oracle/bi/server/base/LogicalTable/Dim _u0150 Security 
            _u0150 Opportunity80e13d09-07f3-0000-714b-e31d00000000.xml#m80e13d0d-
            07d6-0000-714b-e31d00000000" /> 
       </ObjectRefList>
     </LogicalColumnExpr>
     <Expr>
       <ExprText>
          <![CDATA[ "%1" ]]> 
       </ExprText>
       <ExprTextDesc>
         <![CDATA[ "Oracle Data Warehouse"."Catalog"."dbo"."Fact_W_REVN_F".
            "ROW_WID" ]]> 
       </ExprTextDesc>
       <ObjectRefList>
         <RefObject refId="m80e13d0b-07f5-0000-714b-e31d00000000-m00228792-0bbb-
            0000-714b-e31d00000000"
           objectTypeId="3003"
           objectRef="/oracle/bi/server/base/PhysicalTable/Fact_W_REVN_F_0022613e-
            0bb9-0000-714b-e31d00000000.xml#m00228792-0bbb-0000-714b-e31d00000000"
            /> 
       </ObjectRefList>
     </Expr>
   </ColumnMapping>
   <ColumnMapping>
...
...
   </ColumnMapping>
   <Link startNodeTableRef="/oracle/bi/server/base/PhysicalTable/Fact_W_REVN_F_
      0022613e-0bb9-0000-714b-e31d00000000.xml#m0022613e-0bb9-0000-714b-
      e31d00000000">
     <Join type="LeftOuter" cardinality="MANY TO ONE"
       physicalTable1Ref="/oracle/bi/server/base/PhysicalTable/Fact_W_REVN_F_00226
        13e-0bb9-0000-714b-e31d00000000.xml#m0022613e-0bb9-0000-714b-e31d00000000"
       physicalTable2Ref="/oracle/bi/server/base/PhysicalTable/Dim_Team_Security_
        Opty_Resource_80e13d20-0bb9-0000-714b-e31d00000000.xml#m80e13d20-0bb9-
        0000-714b-e31d00000000"
       physicalJoinRef="/oracle/bi/server/base/PhysicalTable/Fact_W_REVN_F_
        0022613e-0bb9-0000-714b-e31d00000000.xml#m80e13d24-0bbe-0000-714b-
        e31d00000000" /> 
   </Link>
   <Link startNodeTableRef="/oracle/bi/server/base/PhysicalTable/Dim_Team_Security
      _Opty_Resource_80e13d20-0bb9-0000-714b-e31d00000000.xml#m80e13d20-0bb9-0000-
      714b-e31d00000000">
     <Join type="RightOuter" cardinality="ONE TO MANY"
       physicalTable1Ref="/oracle/bi/server/base/PhysicalTable/Dim_Team_Security_
        Opty_Resource_80e13d20-0bb9-0000-714b-e31d00000000.xml#m80e13d20-0bb9-
        0000-714b-e31d00000000"
       physicalTable2Ref="/oracle/bi/server/base/PhysicalTable/Fact_W_REVN_F_00226
        13e-0bb9-0000-714b-e31d00000000.xml#m0022613e-0bb9-0000-714b-e31d00000000"
       physicalJoinRef="/oracle/bi/server/base/PhysicalTable/Fact_W_REVN_F_
        0022613e-0bb9-0000-714b-e31d00000000.xml#m80e13d24-0bbe-0000-714b-
        e31d00000000" /> 
   </Link>
   <WhereClause>
     <ExprText /> 
     <ExprTextDesc /> 
   </WhereClause>
   <GroupBy>
     <ExprText>
       <![CDATA[ GROUPBYLEVEL("%1") ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ GROUPBYLEVEL("Core"."Security - Opportunity"."Detail") ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m80e13d0b-07f5-0000-714b-e31d00000000-m80e13d12-07e9-
          0000-714b-e31d00000000"
         objectRef="/oracle/bi/server/base/LogicalLevel/Detail_80e13d12-07e9-
          0000-714b-e31d00000000.xml#m80e13d12-07e9-0000-714b-e31d00000000" /> 
     </ObjectRefList>
   </GroupBy>
   <FragmentContent>
     <ExprText /> 
     <ExprTextDesc /> 
   </FragmentContent>
</LogicalTableSource>

2.9.1 Column Mapping

The column mapping element does not correspond to any metadata repository object. It is only used in conjunction with the logical table source element. The column mapping element appears on its own in the MDS XML schema (.xsd file), rather than as part of the logical table source element, so that the column mapping details are easier to read.

The column mapping tag includes the following child elements:

Table 2-19 Column Mapping Child Elements

Element Name Description

LogicalColumnExpr

Contains the expression that identifies the logical column for this column mapping.

Expr

Contains the expression that identifies the physical column for this column mapping.


The column mapping tag does not include any attributes.

Syntax

<ColumnMapping>
   <LogicalColumnExpr />
   <Expr />
</ColumnMapping>

Note:

Both of the summary syntax elements <Expr /> and <LogicalColumnExpr /> have the following sub-elements:

<ExprText>...</ExprText>
<ExprTextDesc>...</ExprTextDesc>
<ObjectRefList>
  <RefObject objectRef="" …/>
  <RefObject objectRef="" …/>
</ObjectRefList>

Example

<ColumnMapping>
   <LogicalColumnExpr>
     <ExprText>
       <![CDATA[ "%1" ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ "Core"."Fact - CRM - Employee"."# Employees" ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m0022522d-07f5-0000-714b-e31d00000000-m00221e5b-07d6-
          0000-714b-e31d00000000" 
         objectTypeId="2006" 
         objectRef="/oracle/bi/server/base/LogicalTable/Fact Employee_00224fc8-
          07f3-0000-714b-e31d00000000.xml#m00221e5b-07d6-0000-714b-e31d00000000"
           /> 
     </ObjectRefList>
   </LogicalColumnExpr>
   <Expr>
     <ExprText>
       <![CDATA[ "%1" ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ "Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_EMPLOYEE_D".
         "ROW_WID" ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m0022522d-07f5-0000-714b-e31d00000000-m00228946-0bbb-
          0000-714b-e31d00000000" 
         objectTypeId="3003" 
         objectRef="/oracle/bi/server/base/PhysicalTable/Dim_W_EMPLOYEE_D_
          00226151-0bb9-0000-714b-e31d00000000.xml#m00228946-0bbb-0000-714b-
          e31d00000000" /> 
     </ObjectRefList>
   </Expr>
</ColumnMapping>

2.10 MDS XML Elements: Logical Source Folder

The logical source folder element corresponds to the logical source folder object in the Business Model and Mapping layer. Logical source folders contain logical table sources.

The logical source folder tag includes the following attributes:

Table 2-20 Logical Source Folder Tag Attributes

Attribute Name Description

logicalTableRef

References the logical table for this logical source folder.


Syntax

<LogicalSourceFolder …
   logicalTableRef="">
   <Description />
</LogicalSourceFolder>

Example

<LogicalSourceFolder mdsid="m00090a43-07fe-0000-714b-e31d00000000" 
   name="Sources" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   logicalTableRef="/oracle/bi/server/base/LogicalTable/Fact Purchasing 
    Requisition_00090a2f-07f3-0000-714b-e31d00000000.xml#m00090a2f-07f3-0000-
    714b-e31d00000000">
</LogicalSourceFolder>

2.11 MDS XML Elements: Measure Definition

The measure definition element stores the measure definition for a measure column. A measure column is usually in a fact table, can change for each record, and can be added up or aggregated in some way.

The measure definition element is not a top-level element - it appears as a child element of the logical column element.

The measure definition tag includes the following attributes:

Table 2-21 Measure Definition Tag Attributes

Attribute Name Description

isCommutative

If set to true, indicates that the aggregation rule lets the server switch the order if it can increase the performance. For example, the following aggregation function is commutative:

A (B (x)) = B (A (x))

The measure definition tag includes the following child elements:

Table 2-22 Measure Definition Child Elements

Element Name Description

AggrRule

References the aggregation rule for this measure. For details, see Section 2.12, "MDS XML Elements: Aggregation Rule."

OverrideAggrRule

References the override aggregation rule for this measure, if any. For details, see Section 2.13, "MDS XML Elements: Override Aggregation Rule."


Syntax

<MeasureDefn …
     isCommutative="">
   <AggrRule />
   <OverrideAggrRule />
   <Description />
</MeasureDefn>

Example

<MeasureDefn mdsid="m80cb68e2-0800-0000-714b-e31d00000000"
     name="Measure"
     isCommutative="false">
   <AggrRule mdsid="m80cb6c4e-0802-0000-714b-e31d00000000" name="AggRule_
   2050:434541273647807" isDefault="true">
     <Expr mdsid="m00000001-01f4-0000-2a4a-02de00000000" name="Expr">
       <ExprText>
         <![CDATA[ SUM("%1")]]> 
       </ExprText>
       <ExprTextDesc>
         <![CDATA[ SUM("SampleApp Lite"."F1 Targets Base Measures"."Target
         Revenue")]]> 
       </ExprTextDesc>
       <ObjectRefList>
         <RefObject refId="m00000001-01f4-0000-2a4a-02de00000000-m80cb68a4-07d6
         -0000-714b-e31d00000000" objectTypeId="2006" objectRef="/oracle/
         bi/server/base/LogicalTable/80cb68a3-07f3-0000-714b-e31d00000000.xml#
         m80cb68a4-07d6-0000-714b-e31d00000000" /> 
       </ObjectRefList>
     </Expr>
   </AggrRule>
</MeasureDefn>

2.12 MDS XML Elements: Aggregation Rule

The aggregation rule element corresponds to the aggregation rule object in the Business Model and Mapping layer.

The aggregation rule element is not a top-level element - it appears as a child element of the measure definition element.

The aggregation rule tag includes the following attributes:

Table 2-23 Aggregation Rule Tag Attributes

Attribute Name Description

isDefault

If set to true, indicates that this is the default rule for aggregate calculations. This option only applies when there is more than one aggregation rule.

basedOnDimensionRef

If this aggregation rule is specific to a particular dimension, references the dimension for which this aggregation rule applies.


The aggregation rule tag includes the following child elements:

Table 2-24 Aggregation Rule Child Elements

Element Name Description

Expr

Contains the expression on which this aggregation rule is based.


Syntax

<AggrRule …
     isDefault=""
     basedOnDimensionRef="">
   <Description />
   <Expr>
     <ExprText>...</ExprText>
     <ExprTextDesc>...</ExprTextDesc>
     <ObjectRefList>
       <RefObject objectRef="" …/>
       <RefObject objectRef="" …/>
     </ObjectRefList
   </Expr>
</AggrRule>

Example

<AggrRule mdsid="m80cb6c4e-0802-0000-714b-e31d00000000"
     name="AggRule_2050:434541273647807"
     isDefault="true">
   <Expr mdsid="m00000001-01f4-0000-2a4a-02de00000000" name="Expr">
     <ExprText>
       <![CDATA[ SUM("%1")]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ SUM("SampleApp Lite"."F1 Targets Base Measures"."Target
       Revenue")]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m00000001-01f4-0000-2a4a-02de00000000-m80cb68a4-07d6-
       0000-714b-e31d00000000" objectTypeId="2006" objectRef="/oracle/bi/server/
       base/LogicalTable/80cb68a3-07f3-0000-714b-e31d00000000.xml#m80cb68a4-07d6-0
       000-714b-e31d00000000" /> 
     </ObjectRefList>
   </Expr>
</AggrRule>

2.13 MDS XML Elements: Override Aggregation Rule

The override aggregation rule element corresponds to the override aggregation expression for a logical table source in the Business Model and Mapping Layer.

When you select Count Distinct as the default aggregation rule, you can specify an override aggregation expression for specific logical table sources. This option is useful when you have more than one logical table source mapped to a logical column and you want to apply a different aggregation rule to each source.

The override aggregation rule element is not a top-level element - it appears as a child element of the measure definition element.

The override aggregation rule tag includes the following attributes:

Table 2-25 Override Aggregation Rule Tag Attributes

Attribute Name Description

logicalTableSourceRef

References the logical table source for this override aggregation rule.


The override aggregation rule tag includes the following child elements:

Table 2-26 Override Aggregation Rule Child Elements

Element Name Description

Expr

Contains the expression on which this aggregation rule is based.


Syntax

<OverrideAggrRule …
     logicalTableSourceRef="">
   <Description />
   <Expr>
     <ExprText>...</ExprText>
     <ExprTextDesc>...</ExprTextDesc>
     <ObjectRefList>
       <RefObject objectRef="" …/>
       <RefObject objectRef="" …/>
     </ObjectRefList
   </Expr>
</OverrideAggrRule>

Example

<OverrideAggrRule mdsid="m80c95c48-0806-0000-714b-e31d00000000" 
   name="OvAggRule_2054:385771246426812" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   logicalTableSourceRef="/oracle/bi/server/base/LogicalTableSource/Fact_Agg_W_
    RESP_CMPOFR_A_8033657e-07f5-0000-714b-e31d00000000.xml#m8033657e-07f5-0000-
    714b-e31d00000000">
   <Expr>
     <ExprText>
       <![CDATA[ SUM("%1") ]]> 
     </ExprText>
     <ExprTextDesc>
       <![CDATA[ SUM("Core"."Fact - CRM - Response"."# Responses") ]]> 
     </ExprTextDesc>
     <ObjectRefList>
       <RefObject refId="m80c95c48-0806-0000-714b-e31d00000000-m00222110-07d6-
          0000-714b-e31d00000000" 
         objectTypeId="2006" 
         objectRef="/oracle/bi/server/base/LogicalTable/Fact Response_00224ffb-
          07f3-0000-714b-e31d00000000.xml#m00222110-07d6-0000-714b-e31d00000000" 
          /> 
     </ObjectRefList>
   </Expr>
</OverrideAggrRule>

2.14 MDS XML Elements: Logical Display Folder

The logical display folder element corresponds to the logical display folder object in the Business Model and Mapping layer.

The logical display folder tag includes the following attributes:

Table 2-27 Logical Display Folder Tag Attributes

Attribute Name Description

subjectAreaRef

References the business model for this logical display folder.


The logical display folder tag includes the following child elements:

Table 2-28 Logical Display Folder Child Elements

Element Name Description

Dimensions

References the dimensions that belong to this logical display folder.

Each dimension is contained in a sub-element called RefDimension.

Tables

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

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


Syntax

<LogicalDisplayFolder …
   subjectAreaRef="">
   <Description />
   <RefDimensions>
     <RefDimension dimensionRef="" …/>
     <RefDimension dimensionRef="" …/>
   </RefDimensions>
   <RefTables>
     <RefLogicalTable logicalTableRef="" …/>
     <RefLogicalTable logicalTableRef="" …/>
   </RefTables>
</LogicalDisplayFolder>

Example

<LogicalDisplayFolder mdsid="me4070ae0-0bf1-1000-b290-0ae593200000" 
   name="Fact Tables" 
   iconIndex="69" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
   xmlns="http://www.oracle.com/obis/repository" 
   subjectAreaRef="/oracle/bi/server/base/BusinessModel/Time Series_e406baf8-
    0bf1-1000-b290-0ae593200000.xml#me406baf8-0bf1-1000-b290-0ae593200000">
   <RefTables>
     <RefLogicalTable refId="me4070ae0-0bf1-1000-b290-0ae593200000-me406e378-0bf1-
        1000-b290-0ae593200000" 
       logicalTableRef="/oracle/bi/server/base/LogicalTable/SalesFacts_e406e378-
        0bf1-1000-b290-0ae593200000.xml#me406e378-0bf1-1000-b290-0ae593200000" /> 
     <RefLogicalTable refId="me4070ae0-0bf1-1000-b290-0ae593200000-me406e456-0bf1-
        1000-b290-0ae593200000" 
       logicalTableRef="/oracle/bi/server/base/LogicalTable/SalesPlan_e406e456-
        0bf1-1000-b290-0ae593200000.xml#me406e456-0bf1-1000-b290-0ae593200000" /> 
   </RefTables>
</LogicalDisplayFolder>