CHARLES TORRY
  • Main
  • Oracle - Hyperion EPM
  • Links
    • Powershell >
      • List Services & Dependency's
      • Creating an Object / Table Variable
    • ASP.NET >
      • ASP.NET Forms Based Authentication with Active Directory
    • SQL
    • Oracle EPM Doc Links
    • Reset admin password to default

Oracle Hyperion EPM

Updating Essbase text lists with the Java API

10/5/2015

0 Comments

 
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

    
0 Comments

    Author

    Charles Torry

    View my profile on LinkedIn

    Essbase Groovy CDFs

    EPM on Linux - Part 3

    ​EPM on Linux - Part 2

    EPM on Linux - Part 1

    Archives

    September 2016
    November 2015
    October 2015
    April 2012

    Categories

    All
    11.1.2.4
    Application
    Create
    Database
    EPM
    Essbase
    Groovy
    How-To
    Java API
    Linux
    OEL
    Oracle Linux 6
    Planning
    Smart List
    Text List

    RSS Feed

  • Main
  • Oracle - Hyperion EPM
  • Links
    • Powershell >
      • List Services & Dependency's
      • Creating an Object / Table Variable
    • ASP.NET >
      • ASP.NET Forms Based Authentication with Active Directory
    • SQL
    • Oracle EPM Doc Links
    • Reset admin password to default