Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Essbase - Data Load — 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

Essbase - Data Load

Received Response
11
Views
6
Comments
edited Aug 2, 2018 2:36AM in Essbase 6 comments

Summary

Essbase - Data Load

Content

I am trying to load a dataset from a flat file with (~) delimited

so e.g.

Dataset

1492~ABC~Country~LOC~123~234~345~456

1493~ABC~Country~LOC~123~234~345~456

1494~ABC~Country~LOC~123~234~345~456

1495~ABC~Country~LOC~123~234~345~456

1492~ABC~Country~LOC~123~~345~

3311~ABC~Country~USD~789~0~345~456

3312~ABC~Country~LOC~789~0~345~456

where as 123, 234, 345 & 456 are data field (Accounts)

The app has 10 dimension, rest all 6 dim are in headers.

when i am trying to load the data, it is loading everything but not the 3312 product line but when i separately do that line only, it loads properly. I do not see any rejections for that line in the error file. It seems Essbase normally processing it but not able to load it. I do have rejection and criteria in the rule file. What else do I need to look in?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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