PBCS Quick Tips – Moving PBCS (Essbase) Cube to On-Premises 7


Writing a series of blog posts covering a complex functionality can be challenging, however it also leads to other posts (that’s why you saw the post about Hierarchy driven Smart lists and this one) 😉

I was researching and writing my follow up post on Groovy in PBCS and noticed some differences in Vision App on PBCS. I’m not sure when those changes made it into PBCS. There were lot of kick outs when I tried to load the data in PBCS from an on-prem Vision app.

Many accounts were removed, Start Year changed from FY09 to FY10.

As you know when metadata changes and you try to load a level 0 data file, it aborts the load when it hits and error and becomes bit frustrating without using a load rule, now this is PBCS data and there is no load rule!!!

What can we do? What can we do?

I did write about a change that was introduced in 16.09 here and if you read the comments Glenn Schwartzberg pointed out that you need to edit the .esm file. ESM file is the Essbase kernel file that manages pointers to data blocks and contains control information used for database recovery,so this file has the Essbase install root directory information and you’ll have to edit that file and update it to your on-premises Essbase install directory. Mine is C drive and here is how it looks like.

You need to repeat this for all the databases.
Once that is done, you can create the following Applications

  1. Vision
  2. Vis1ASO
  3. VisASO

Oh yeah, those are ASO plan types.

Once the applications are created, please stop the apps, so that you can copy the files from Essbase Data LCM folder.

Now that I got my PBCS Vision app as an on-premises Essbase application, I can use my old text file, create a load rule and load them all at once (and ignore the errors).

Now that’s done, how are we going to get this back to PBCS?

Get a level 0 export and import it back, yes this works now. Earlier PBCS versions really didn’t like Essbase level 0 format, however that changed (not sure which release that happened)

P.S you can also do this if you really want to get a level 0 extract of PBCS cube.

P.P.S Long live on-premises 🙂

Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

7 thoughts on “PBCS Quick Tips – Moving PBCS (Essbase) Cube to On-Premises

      • Amith

        Hi Celvin,

        Thanks for the post.

        I understand the above post helps in creating export files of level0 data from essbase and importing our backup files … But are those files not loadable through pbcs ?

        Do we still have data export options in pbcs for calc mgr rules where we run data exports ?? If yes to give path for export file how do we know the path , if we give the path checking esm file.. will it in artefact export or it can be brought through epmautomate ?.

        Thanks
        Amith

        • Celvin Kattookaran Post author

          This is done to migrate PBCS to an on-prem essbase cube. Since there is no level 0 data export in PBCS anymore. You can load level 0 essbase data (for that matter Essbase format data) in PBCS.
          There is not export option in pbcs for Calc Mgr Rule. You can use export jobs to export data. or use a hack I talked about that here

    • Celvin Kattookaran Post author

      You can open that in any text editor however, you’ll be only able to edit what you can read 😉

  • ravi

    have 2 forms asset input & Derp values

    i need to calculate the dep value based on the asset member/usefull and this value should copy to the future members based on the asset service data

    e.g 7711 = 1511/usefull file …this vale needs be copied from feb Fy17 to future months as the service date is jan-Fy17

    Inline image 1

    Inline image 2

    value for 1511 is calculated based on no.of assets * asset value in top form

    post this i need to move the data to a primary planning cube