Download, install and configure Smart View

Here is an easy one. So you were told you have to start using Smart View: instead of using the old Essbase Excel add-in or because your company chose to use Essbase, Planning, HFM… for all their EPM needs. Either way, you’ll have to download, install and configure Smart View. You can download Smartview directly from the Oracle……

Continue reading

Don’t forget the WORKERTHREADS!

Beginning in 11.1.2.4 Essbase, there is a new configuration setting that should not be forgotten – “WORKERTHREADS”. Why is this configuration setting important you may ask. Previously, Essbase operations that could run in parallel (calculations, data loads etc) used dynamically created threads for their work. Administrators need not bother setting thread pools or assigning threads.……

Continue reading

Real World Case Example for ODI Yellow Interface (w/ Dynamic Source and Target)

Until recently, I never encountered a situation where I needed a “yellow interface” in ODI (Oracle Data Integrator). Typical ODI interfaces leverage models that are manually created and point to static objects such as tables or files. On a recent project, I took to ODI to create an automation process that would be used to……

Continue reading