Oracle Essbase 11 Development Cookbook. Over 90 advanced development recipes to build and take your Oracle Essbase Applications further with this book

Oracle Essbase 11 Development Cookbook. Over 90 advanced development recipes to build and take your Oracle Essbase Applications further with this book - Opis

Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios.This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further.Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes. Spis treści:
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 (...) więcej parent-child reference
Getting ready
How to do it...
How it works...
Theres 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...
Theres 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 mniej