File Library

Handling Textual Data in Planning and Essbase: A Starbucks Case
Topic: Webinars
Owner: Rhonda A Brigham
Date: 2017-09-14

Juan Porter, TopDown Consulting and Rhonda Brigham, Starbucks

Handling text data in a Hyperion Planning application is relatively easy and straightforward. Planning metadata is stored in a relational database. This textual information is accessible via web forms, HFR, and Smart View out-of-the-box. On the other hand, managing and reporting on text data is not quite as simple in the Essbase technology. Essbase handles dates and smart lists but can’t handles freeform text values. The situation is further complicated by the fact that your smart lists need to be synchronized between Planning and Essbase for the data transfer to be accurate. In this session Juan Porter, TopDown Consulting, and Rhonda Brigham, Starbucks, will discuss how they used a creative approach to get text data in three different forms–smart lists, dates and freeform text data–to flow from Planning to Essbase. They will discuss the overall project goals, technologies, POCs, and the reason for choosing the solution they did, including design and results.

Download File   091417 A Starbucks Case Study J Porter and R Brigham.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database