Can we load custom excel data via rules files in Essbase 21c?
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?
Version (include the version you are using, if applicable):