Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
DATAEXPORT - level 0 with upper level sparse members — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DATAEXPORT - level 0 with upper level sparse members

Accepted answer
8
Views
1
Comments
edited Oct 1, 2018 6:22PM in Essbase 1 comment

Summary

Need assistance on extracting data with upper level sparse members

Content

Hi all,

Is it possible to extract data with DATAEXPORT and fixing on two dynamically calc'd parent level members (MED_All_Final and MED_Total Plan in example below) of two sparse dimensions? Every time I run the rule I get their level 0 children. If not possible, any suggestions on how I can have the two parent members in my extract? Thanks in advance!

Here's what I have:

SET DATAEXPORTOPTIONS

{

DataExportLevel All;

DataExportDynamicCalc ON;

DataExportNonExistingBlocks OFF;

DataExportDecimal 2;

DataExportPrecision 16;

DataExportColFormat ON;

DataExportColHeader Period;

DataExportDimHeader ON;

DataExportRelationalFile OFF;

DataExportOverwriteFile ON;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!