Resolving Essbase Error 1005000 in PBCS Business Rules

Using substitution variables to store folder directories and then referencing the variables in calc scripts/business rules has long been a best practice in the world of on-prem applications. For example, using a variable to store the path to a shared folder for a dataexport command.

DATAEXPORT “File” “|” “&ExportServer/Sample.TXT” “#mi”;

But cloud applications do not have visibility or access to the on-prem servers, folders, shared drives, etc. And so users may encounter the following error when launching a data export rule in PBCS:

Cannot calculate. Essbase Error(1005000): Ascii Backup: Failed to open…

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

Note: The ExportServer substitution variable is set to a directory on an on-prem server.

It’s worth noting that simply validating the rule will NOT identify the error (see below), the rule has to be launched in order to encounter the problem.

The Fix

The rule(s) must be updated to place the export file in the Inbox/Outbox Explorer within PBCS. This can be accomplished by replacing the substitution variable with /u03/lcm/.

The users can download the file from the Inbox/Outbox Explorer and place in the appropriate location. Or better yet, an EPM Automate script can easily be written to facilitate the running of the rule and downloading of the file.

To read more on PBCS Business Rules, click here.