Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents and Other Resources
• Conventions

Part I MDS XML Schema Elements

1 About the Oracle BI Server MDS XML API

• 1.1 About the Oracle BI Server MDS XML API
• 1.2 Generating MDS XML
  • 1.2.1 Generating MDS XML from an Existing RPD Using the Administration Tool
  • 1.2.2 Generating MDS XML from an Existing RPD Using a Command-Line Utility
• 1.3 Executing MDS XML
• 1.4 Generic MDS XML Elements and Attributes
  • 1.4.1 About MDS XML Object Identifiers
• 1.5 Example: Analysis of an MDS XML Logical Table Element
• 1.6 Topics of Interest in Other Guides
• 1.7 System Requirements and Certification

2 MDS XML Logical Elements

• 2.1 MDS XML Elements: Logical Column
• 2.2 MDS XML Elements: Business Model
• 2.3 MDS XML Elements: Logical Complex Join
• 2.4 MDS XML Elements: Logical Level
• 2.5 MDS XML Elements: Dimension
• 2.6 MDS XML Elements: Logical Table
• 2.7 MDS XML Elements: Logical Foreign Key
• 2.8 MDS XML Elements: Logical Key
• 2.9 MDS XML Elements: Logical Table Source
  • 2.9.1 Column Mapping
• 2.10 MDS XML Elements: Logical Source Folder
• 2.11 MDS XML Elements: Measure Definition
• 2.12 MDS XML Elements: Aggregation Rule
• 2.13 MDS XML Elements: Override Aggregation Rule
• 2.14 MDS XML Elements: Logical Display Folder

3 MDS XML Physical Elements

• 3.1 MDS XML Elements: Database
• 3.2 MDS XML Elements: Physical Catalog
• 3.3 MDS XML Elements: Physical Schema
• 3.4 MDS XML Elements: Physical Display Folder
• 3.5 MDS XML Elements: Physical Table
• 3.6 MDS XML Elements: Physical Column
• 3.7 MDS XML Elements: Connection Pool
• 3.8 MDS XML Elements: Physical Key
• 3.9 MDS XML Elements: Physical Foreign Key
• 3.10 MDS XML Elements: Complex Join
• 3.11 MDS XML Elements: Cube Table
• 3.12 MDS XML Elements: Physical Dimension
• 3.13 MDS XML Elements: Physical Hierarchy
• 3.14 MDS XML Elements: Physical Level
• 3.15 MDS XML Elements: Cube Column
• 3.16 MDS XML Elements: Analytic Workspace
• 3.17 MDS XML Elements: AW Cube
• 3.18 MDS XML Elements: AW Dimension
• 3.19 MDS XML Elements: AW Hierarchy
• 3.20 MDS XML Elements: AW Level
• 3.21 MDS XML Elements: AW Column

4 MDS XML Presentation Elements

• 4.1 MDS XML Elements: Presentation Catalog
• 4.2 MDS XML Elements: Presentation Table
• 4.3 MDS XML Elements: Presentation Column
• 4.4 MDS XML Elements: Presentation Hierarchy
• 4.5 MDS XML Elements: Presentation Level

5 MDS XML Marketing, Security, and Other Elements

• 5.1 MDS XML Marketing Elements
  • 5.1.1 MDS XML Elements: Catalog Link
  • 5.1.2 MDS XML Elements: Target Level
  • 5.1.3 MDS XML Elements: List Catalog
  • 5.1.4 MDS XML Elements: Qualified List Item
  • 5.1.5 MDS XML Elements: Qualifying Key
  • 5.1.6 MDS XML Elements: Sampling Table
  • 5.1.7 MDS XML Elements: Seg Catalog
• 5.2 MDS XML Security Elements
  • 5.2.1 MDS XML Elements: Variable
  • 5.2.2 MDS XML Elements: LDAP Server
  • 5.2.3 MDS XML Elements: Init Block
  • 5.2.4 MDS XML Elements: Custom Authenticator
  • 5.2.5 MDS XML Elements: Privilege Package
  • 5.2.6 MDS XML Elements: Object Privilege
  • 5.2.7 MDS XML Elements: Query Privilege
  • 5.2.8 MDS XML Elements: User
  • 5.2.9 MDS XML Elements: Group
  • 5.2.10 MDS XML Elements: DB Sign-On
• 5.3 Other MDS XML Elements
  • 5.3.1 MDS XML Elements: Project
  • 5.3.2 MDS XML Elements: Query Object

Part II XML Schema Elements

6 About the Oracle BI Server XML API

• 6.1 About the Oracle BI Server XML API
  • 6.1.1 About Using the Oracle BI Server XML API to Merge and Append Objects
• 6.2 Generating and Executing XML
  • 6.2.1 Generating XML from an Existing RPD
  • 6.2.2 Executing XML in Offline Mode
  • 6.2.3 Executing XML Against the Oracle BI Server
• 6.3 Using the Oracle BI Server XML API
  • 6.3.1 Maintaining Versions of the Metadata
  • 6.3.2 Migrating Metadata from Another System
  • 6.3.3 Applying a Metadata Patch Against a Running Oracle BI Server
  • 6.3.4 Manipulating Metadata Programmatically
    • 6.3.4.1 Example of Programmatically Creating a Repository Object Using XML
  • 6.3.5 Moving from Test to Production Environments
  • 6.3.6 Using XSL to Transform XML Files
• 6.4 Generic XML Elements and Attributes
  • 6.4.1 About Object Identifiers
  • 6.4.2 About Naming Requirements for Repository Objects

7 XML Logical Elements

• 7.1 XML Elements: Logical Column
• 7.2 XML Elements: Business Model
• 7.3 XML Elements: Logical Complex Join
• 7.4 XML Elements: Logical Level
• 7.5 XML Elements: Dimension
• 7.6 XML Elements: Logical Table
• 7.7 XML Elements: Logical Foreign Key
• 7.8 XML Elements: Logical Key
• 7.9 XML Elements: Logical Table Source
  • 7.9.1 Column Mapping
• 7.10 XML Elements: Logical Source Folder
• 7.11 XML Elements: Measure Definition
• 7.12 XML Elements: Aggregation Rule
• 7.13 XML Elements: Override Aggregation Rule
• 7.14 XML Elements: Logical Display Folder

8 XML Physical Elements

• 8.1 XML Elements: Database
• 8.2 XML Elements: Physical Catalog
• 8.3 XML Elements: Physical Schema
• 8.4 XML Elements: Physical Display Folder
• 8.5 XML Elements: Physical Table
• 8.6 XML Elements: Physical Column
• 8.7 XML Elements: Connection Pool
• 8.8 XML Elements: Physical Key
• 8.9 XML Elements: Physical Foreign Key
• 8.10 XML Elements: Complex Join
• 8.11 XML Elements: Cube Table
• 8.12 XML Elements: Physical Dimension
• 8.13 XML Elements: Physical Hierarchy
• 8.14 XML Elements: Physical Level
• 8.15 XML Elements: Cube Column
• 8.16 XML Elements: Analytic Workspace
• 8.17 XML Elements: AW Cube
• 8.18 XML Elements: AW Dimension
• 8.19 XML Elements: AW Hierarchy
• 8.20 XML Elements: AW Level
• 8.21 XML Elements: AW Column

9 XML Presentation Elements

• 9.1 XML Elements: Presentation Catalog
• 9.2 XML Elements: Presentation Schema
• 9.3 XML Elements: Presentation Table
• 9.4 XML Elements: Presentation Column
• 9.5 XML Elements: Presentation Hierarchy
• 9.6 XML Elements: Presentation Level

10 XML Marketing, Security, and Other Elements

• 10.1 XML Marketing Elements
  • 10.1.1 XML Elements: Catalog Link
  • 10.1.2 XML Elements: Target Level
  • 10.1.3 XML Elements: List Catalog
  • 10.1.4 XML Elements: Qualified List Item
  • 10.1.5 XML Elements: Qualifying Key
  • 10.1.6 XML Elements: Sampling Table
  • 10.1.7 XML Elements: Seg Catalog
• 10.2 XML Security Elements
  • 10.2.1 XML Elements: Variable
  • 10.2.2 XML Elements: LDAP Server
  • 10.2.3 XML Elements: Init Block
  • 10.2.4 XML Elements: Custom Authenticator
  • 10.2.5 XML Elements: Privilege Package
  • 10.2.6 XML Elements: Object Privilege
  • 10.2.7 XML Elements: Query Privilege
  • 10.2.8 XML Elements: User
  • 10.2.9 XML Elements: Group
  • 10.2.10 XML Elements: DB Sign-On
  • 10.2.11 XML Elements: FMW Security
• 10.3 Other XML Elements
  • 10.3.1 XML Elements: Project
  • 10.3.2 XML Elements: Query Object

Glossary

Index