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

Can we load custom excel data via rules files in Essbase 21c?

Accepted answer
22
Views
1
Comments
edited Aug 25, 2023 9:53PM in Essbase 1 comment

Summary: Hi All, As per Essbase 21c documentation Microsoft excel is listed as one of the data source types supported. Apart from the standard dimension/data import mentioned in application workbook, can we use custom excel workbook (like sheet 2 or 3, etc.) and automate it via rules files?

Can we preview data from individual sheets so that we can do the mapping similar to text files preview/mapping. Our goal is to automate data we are receiving via excel via rules files.

Are there any other alternatives to load excel data to Essbase automatically?

Content (required):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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