Essbase - Data Prep Editor

Essbase Overview

About

Data prep editor permit to edit Essbase - Rules File. When it open, the menu in the Essbase - Administration Services Console change.

Essbase Rules File

The upper screen frame shows the Essbase - Data Source file in its original form.

The lower screen frame shows how Essbase will interpret the data before it gets loaded into your Essbase - Database (cube).

View

Essbase Data Prep Editor Data Field

How to open it ?

From Essbase - Administration Services Console :

  • File > Editors > Data Prep Editor
  • or File > New > Scripts > Rules File

Support

Invalid blank character in name

When you try to open a data load file, you may fire this error :

1030010 - Invalid blank character in name

The message indicate that you have blank character either in the directory or the name of the file and that they are not allowed. Suppress them to have a complete location without space as :

C:\DirectoryWithoutSpace\NameOfTheDataFileWithoutSpace.xls





Discover More
Essbase Data Source Record Fields
Essbase - Delimiters

A file delimiter is the character (or characters) used to separate fields in the data source. You must separate fields from each other with delimiters. By default, a rules file expects fields...
Essbase Overview
Essbase - Outline Creation and Management using Outline Editor

This article provides an overview of creating outline using Outline Editor. For information Outline Editor, see the Oracle Essbase Administration Services Online Help. All examples in this chapter are...
Rules File
Essbase - Rules File

A rules files tells Essbase what changes to make to : the data source to load and the outline to build during : a data load or a dimension build. You have then two type of rules files : ...



Share this page:
Follow us:
Task Runner