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
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 🙂
I guess we can use essmove utility as well to change storage location
yeah you can do that as well.
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 ?.
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
Great article, what is the best way to edit the .esm file?
You can open that in any text editor however, you’ll be only able to edit what you can read 😉
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