Oracle Essbase 11 Development Cookbook电子书

Oracle Essbase 11Development Cookbook

Table of Contents

Oracle Essbase 11 Development Cookbook

Credits

About the Author

About the Reviewer

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Understanding and Modifying Data Sources

Introduction

Setting up an Account or Measures dimension with a parent-child reference

Getting ready

How to do it...

How it works...

There's more...

See also

Setting up dimensions with a generation reference

Getting ready

How to do it...

How it works...

See also

Adding columns for outline formulas

Getting ready

How to do it...

How it works...

Adding the solve order column to tables that have ASO formulas

Getting ready

How to do it...

How it works...

Adding and populating the Sort Order Column

Getting ready

How to do it...

How it works...

See also

Adding tables for varying attributes

Getting ready

How to do it...

How it works...

See also

Determining hierarchies in relational tables

Getting ready

How to do it...

How it works...

There's more...

See also

Using the Essbase Outline Extractor to extract dimensions

Getting ready

How to do it...

How it works...

There's more...

Using Star Analytics to build your star schema from existing Essbase cubes

Getting ready

How to do it...

How it works...

See also

2. Using Essbase Studio

Introduction

Advantages of Essbase Studio

Disadvantage of Essbase Studio

Creating TBC sample database and connecting to the data source

Getting ready

How to do it...

How it works...

Adding user-defined tables

Getting ready

How to do it...

How it works...

Building your minischema

Getting ready

How to do it…

How it works...

See also

Setting up joins in a minischema

Getting ready

How to do it...

How it works...

There’s more…

See also

Adding tables to a minischema

Getting ready

How to do it…

How it works…

See also

Using a text file data source

Getting ready

How to do it…

How it works…

Working with Common Platform Language (CPL)

Getting ready

How to do it…

How it works…

Using Sort Order on data elements

Getting ready

How to do it…

How it works...

3. Building the BSO Cube

Introduction

Creating hierarchies using a parent-child reference table

Getting ready

How to do it…

How it works…

See also

Creating hierarchies using a generation reference table

Getting ready

How to do it…

How it works…

Adding attribute dimensions to hierarchies

Getting ready

How to do it…

How it works…

See also...

Building a Calendar dimension

Getting ready

How to do it…

How it works...

Creating date elements

Getting ready

How to do it…

How it works...

Creating Alias tables

Getting ready

How to do it…

How it works...

There's more...

Developing cube schema and an Essbase model

Getting ready

How to do it…

How it works...

There's more...

See also

Setting Essbase properties

Getting ready

How to do it…

How it works...

Deploying a cube

Getting ready

How to do it…

How it works...

Creating an OLAP Model in EIS

Getting ready

How to do it…

How it works...

Creating an OLAP metaoutline in EIS

Getting ready

How to do it…

How it works...

4. Building the ASO Cube

Introduction

Using the Connection Wizard to set up an ASO cube

Getting ready

How to do it...

How it works...

Building a Measures dimension from the fact table

Getting ready

How to do it...

How it works...

There's more...

See also

Creating an ASO Cube Schema and an Essbase Model

Getting ready

How to do it...

How it works...

Understanding Essbase Model properties for the ASO cube

Getting ready

How to do it...

How it works...

There's more...

See also

Designing a drill-through report

Getting ready

How to do it...

How it works

There's more

Using the View dimension for Dynamic Time Series reporting

Getting ready

How to do it...

How it works

5. Using EAS for Development

Introduction

Adding an application and database on an Essbase Server

Getting ready

How to do it...

How it works...

Using the outline editor to add dimensions

Getting ready

How to do it...

How it works...

Using dimension build rules to add the parent-child dimension

Getting ready

How to do it...

How it works...

See also

Creating dimension build rules to add a base and attribute dimensions

Getting ready

How to do it...

How it works...

There's more...

See also

Using dimension build rules to add user-defined attributes and associate dimensions

Getting ready

How to do it...

How it works...

Creating load rules for flat file data loads

Getting ready

How to do it...

How it works...

Creating substitution variables

Getting ready

How it works...

There's more...

There's more...

See also

Using If/Else logic and substitution variables in outline formulas

Getting ready

How to do it...

How it works...

See also

Using Text measures on a BSO cube

Getting ready

How to do it...

How it works...

See also

Using Date measures on a BSO cube

Getting ready

How to do it...

How it works...

See also

Using different outline formula logic at parent level

Getting ready

How to do it...

How it works...

See also

Creating a load rule for SQL data load using substitution variables

Getting ready

How to do it...

How it works...

See also

Using MDX in aggregate storage applications

Getting ready

How to do it...

How it works...

6. Creating Calculation Scripts

Introduction

Using Essbase Set function commands and Calc All to calculate cubes

Getting ready

How to do it...

How it works...

See also

Using control flow commands, conditional, and logical operators

Getting ready

How to do it...

How it works

See also

Using substitution variables in calculations script

Getting ready

How to do it...

How it works...

See also

Using UDAs and Calc Two Pass in calculation scripts

Getting ready

How to do it...

How it works...

There's more...

See also

Using Attributes in calculation scripts

Getting ready

How to do it...

How it works...

See also

Clearing data and using the cross- dimensional operators in a calculation script

Getting ready

How to do it...

How it works

See also

Using allocation functions in calculation scripts

Getting ready

How to do it...

How it works...

See also

Modifying Essbase settings to improve calculation performance

Getting ready

How to do it...

How it works...

See also

Using MDX to calculate Aggregate Storage database

Getting ready

How to do it...

How it works...

7. Using MaxL to Automate Process

Introduction

Setting up folder structure and other files needed for MaxL automation

Getting ready

How to do it...

How it works

There's more...

Executing dimension build rules using MaxL

Getting ready

How to do it...

How it works...

See also

Executing load rules using MaxL

Getting ready

How to do it...

How it works...

See also

Executing calculations using MaxL

Getting ready

How to do it...

How it works...

Executing partitions using MaxL

Getting ready

How to do it...

How it works...

Executing report scripts using MaxL

Getting ready

How to do it...

How it works...

Adding or changing substitution variables with MaxL

Getting ready

How to do it...

How it works...

See also

Using ASO incremental data loads

Getting ready

How to do it...

How it works...

There's more...

Using encryption in MaxL scripts

Getting ready

How to do it...

How it works...

Deploy dimension created in Essbase Studio

Getting ready

How to do it...

How it works...

8. Data Integration

Introduction

Using report script to extract data to a text file

Getting ready

How to do it...

How it works...

See also

Using the DATAEXPORT function to extract data into a text file

Getting ready

How to do it...

How it works...

See also

Using the DATAEXPORT function to extract data into a relational source

Getting ready

How to do it...

How it works...

See also

Exporting data using column format

Getting ready

How to do it...

How it works...

See also

Using MaxL to extract the outline in XML format

Getting ready

How to do it...

How it works...

Using @XREF functions to move data between BSO cubes

Getting ready

How to do it...

How it works...

Partitioning data from BSO to ASO cubes

Getting ready

How to do it...

How it works...

Using MDX for extracting data using API

Getting ready

How to do it...

How it works...

There's more...

9. Provisioning Security Using MaxL Editor or Shared Services

Introduction

Using MaxL editor to add and externalize a user

Getting ready

How to do it...

How it works

There's more...

Using Shared Services to add and provision a user

Getting ready

How to do it...

How it works...

Using MaxL Editor to set up a filter for MetaRead and Write access

Getting ready

How to do it...

How it works...

Using Shared Services to provision filters to a group

Getting ready

How to do it...

How it works...

Using Shared Services to provision calculation scripts to a group

Getting ready

How to do it...

How it works...

Using MaxL to export security file

Getting ready

How to do it...

How it works...

10. Developing Dynamic Reports

Introduction

Creating a connection and using substitution variables in financial reports

Getting ready

How to do it...

How it works...

See also

Using the column templates and formatting reports

Getting ready

How to do it...

How it works...

See also

Retrieving data using UDAs and Attributes

Getting ready

How to do it...

How it works...

See also

Retrieving data using children and descendants member set functions

Getting ready

How to do it...

How it works...

See also

Using User Prompts and the POV to select members

Getting ready

How to do it...

How it works...

See also

Using conditional formatting and suppression in financial reports

Getting ready

How to do it...

How it works...

Adding related content to financial reports

Getting ready

How to do it...

How it works...

Creating a web analysis report

Getting ready

How to do it...

How it works...

Index