Essbase - Data Prep Editor

About

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

_

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

_

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

Powered by ComboStrap