Updating Essbase text lists with the Java API

One of the features I've started working with in Essbase are members that store text.

The limitations for this feature are that you can only store 1024 different strings of text and there is no easy way to automate the maintenance of the members you want in this text list.

Since there seems to be no way to increase the limit (and so far the solutions I'm working on don't depend on more than 1000 different options for a single text list) I decided to work on coming up with a way to automate the maintenance of the list using the Java API.




The general goals are that the solution will connect to a database to pull the list from a SQL table and then load that into Essbase.




In order to generate an incremental list of IDs with text well be using an olap function most versions of sql come with--row_number().

UpdateTextList.groovy