Loading Smartlists into PBCS using FDMEE Cloud

FDMEE PBCS

Disclaimer: The writing and musings of the author do not necessarily reflect the views of his employer.

Roadmap

During the last FDMEE Summit held in the beginning of May 2016, Oracle gave us a peek at what is to come. Key upcoming features included:

  • Metadata Loading
  • Support for additional EPM Cloud Services
  • Limited scripting with Groovy
  • Convert to Outline Load Utility (OLU) for data loading (this will provide users the ability to load textual data like Smartlist)

Workaround

As you can see, the ability to load textual data (Smartlists) into PBCS is on the roadmap. However, if you need to load Smartlists into PBCS now, what do you do? Simple — navigate to Presentations under the Learning By Example section and check out the presentation entitled Loading Smartlists into PBCS using FDMEE Cloud. This presentation will walk you through the necessary steps to load Smartlists into PBCS using SQL Mapping since we are unable to use Jython or ODI.