Hyperion® DIM Adapter for Essbase®

This document describes sample files that are provided to help you learn about this release of Oracle’s Hyperion^® Data Integration Management Adapter for Essbase^®. Review this information thoroughly before attempting to use the sample files.

Top of Document

About Data Integration Management Release 11.1.1.1

Data Integration Management is integrated with Informatica PowerCenter. It provides a way of uniting disparate sources of data across an enterprise. For example, it can integrate data stored in multiple warehouses and data marts, relational database management systems (RDBMS), and on-line analytical processing (OLAP) stores.

Data Integration Management includes these components:

· PowerCenter applications:

· PowerCenter Client

· PowerCenter Server

Top of Document

Data Integration Management Adapters

When you have installed and configured Data Integration Management 11.1.1.1, you can install and configure adapters that enable you to retrieve and write data for these other Hyperion products:

· Oracle’s Hyperion Data Integration Management Adapter for Hyperion Enterprise

· Oracle’s Hyperion Data Integration Management Adapter for Essbase

· Oracle’s Hyperion Data Integration Management Adapter for Financial Management

· Oracle’s Hyperion Data Integration Management Adapter for Planning

· Oracle’s Hyperion Data Integration Management Adapter for Performance Scorecard

· Oracle’s Hyperion Data Integration Management Adapter for Translation Manager

Top of Document

Installing the Sample Files

Sample files for use with DIM for Essbase are available in the sample directory.

The sample files contains the following directories:

|--- sample (directory)

---data (directory): This folder contains data files to be used for data load or dimension building samples.

---rules (directory): This folder contains rules files used for dimension building samples.

---mappings (directory): This folder contains xml files for Sample mappings

To install the sample files:

1. Ensure that Repository Server is running.

2. Open Power Center Designer.

3. Connect to the repository.

4. Import the mapping file from the Samples folder.

5. Save the mapping.

Top of Document

Using the Sample Files

Sample 1: Type 1 Data Extraction

This sample extracts data in type 1 format from an Essbase application and writes it to a flat file.

Essbase Source

· Application: Sample

· Database: Basic

Target

Flat file

Files

Mapping: m_HAS_to_FF_SampleBasicType1.xml

Instructions

1. Import the mapping in Designer and save it.

2. Create as session task for this mapping in Workflow Manager.

3. Configure Connection property for the HAS _SampleBasicType1 source.

4. Make appropriate changes for the output directory name and file name (optional).

5. Create a workflow with the session task and execute it.

Top of Document

Sample 2: Type 1 Data Load

This sample reads data in type 1 format from a flat file and loads it into the Essbase application.

Data Source

Flat file

Essbase Target

· Application: Sample

· Database: Basic

Files

· Mapping: m_FF_to_HAS_SampleBasicType1.xml

· Data: FF_SampleBasicType1.dat

Instructions

1. Import the mapping in Designer and save it.

2. Create as session task for this mapping in Workflow Manager.

3. Make appropriate changes in the source directory name and file name property to point to the above data file.

4. Configure Connection property for the HAS _SampleBasicType1 target.

5. Create a workflow with the session task and execute it.

Top of Document

Sample 3: Type 2 Data Extraction

This sample extracts data in type 2 format from an Essbase application and writes it in a flat file.

Essbase Source

· Application: Sample

· Database: Basic

Target

Flat file

Files

Mapping: m_HAS_to_FF_SampleBasicType2.xml

Instructions

1. Import the mapping in Designer and save it.

2. Create as session task for this mapping in Workflow Manager.

3. Configure Connection property for the HAS_SampleBasicType2 source.

4. Make appropriate changes for the output directory name and file name (optional).

5. Create a workflow with the session task and execute it.

Top of Document

Sample 4: Type 2 Data Load

This sample reads data in type 2 format from a flat file and loads it into the BSO application in Essbase.

Data Source

Flat file

Essbase Target

· Application: Sample

· Database: Basic

Files

· Mapping: m_FF_to_HAS_SampleBasicType2.xml

· Data: FF_SampleBasicType2.dat

Instructions

1. Import the mapping in Designer and save it.

2. Create as session task for this mapping in Workflow Manager.

3. Make appropriate changes in the source directory name and file name property to point to the above data file.

4. Configure Connection property for the HAS _SampleBasicType2 target.

5. Create a workflow with the session task and execute it.

Top of Document

Sample 5: Type 3 Metadata Extract to Flat File

This sample extracts the members for a standard dimension in an Essbase application and writes it a flat file.

Essbase Source

· Application: Sample

· Database: Basic

· Dimension: Measures

Target

Flat file

Files

Mapping: m_HAS_to_FF_SampleBasicMeasuresType3.xml

Instructions

1. Import the mapping in Designer and save it.

2. Create as session task for this mapping in Workflow Manager.

3. Configure Connection property for the HAS _SampleBasicType3 source.

4. Make appropriate changes for the output directory name and file name (optional).

5. Create a workflow with the session task and execute it.

Top of Document

Sample 6: Type 3 Dynamic Dimension Building from Flat File

This sample reads the members hierarchy from a flat file and build the standard dimension in an Essbase application.

Data Source

Flat file

Essbase Target

· Application: Sample

· Database: Basic1

· Dimension: Measures

Files

· Mapping: m_FF_to_HAS_SampleBasic1MeasuresType3.xml

· Rules: SampleBasicMesureAll.rul

· Data: FF_SampleBasicMeasuresType3.dat

Instructions

1. Import the mapping in Designer and save it.

2. Using Administration UI create the Standard dimension Measure.

3. Copy the SampleBasicMeasureAll.rul file into the <AnalyticServicesHome>\AppSample\Basic1 directory.

4. Create a session task for this mapping in Workflow Manager.

5. Make appropriate changes in the source directory name and file name property to point to the above data file.

6. Configure Connection property for the HAS _SampleBasicType3 target.

7. Create a workflow with the session task and execute it.

Sample 7: Metadata Extract and Dynamic Dimension Building (Copying Outline HAS to HAS)

This sample extracts the hierarchy of a standard dimension from an Essbase application and builds the dimension hierarchy in the target Essbase application. It shows how to handle multiple UDAs and associated attribute dimension members while building the hierarchy.

Essbase Source

· Application: Sample

· Database: Basic

· Dimension: Market

Oracle^® Essbase Target

· Application: Sample

· Database: Basic1

· Dimension: Market

Files

· Mapping: m_HAS_to_HAS_SampleBasic1MarketType3.xml

· Rules: SampleBasicMarket.rul

Instructions