Partitions (MAXL / ESSCMD gurus please...)June 15 2005 at 11:55 AM
No score for this post
from IP address 188.8.131.52
We have two Essbase servers, one production and one development (what a breakthrough idea!). I'll call them PROD and DEV.
The databases on each server are heavily partitioned to one another (one database has over 40 partitions). No partitions cross over to a different server.
These partitions are constantly changing through MAXL scripts that delete, create and modify them every single day. Not all the partitions but a few are sure to change each day.
Needless to say (and yet here I am stating it), synchronizing the PROD and DEV is a pain. I can easily synchronize outlines, data, calc scripts, etc by copying and pasting the APP directory from one server to another. That works perfect for me...
EXCEPT for the partitions. The DDB files from PROD when opened in DEV still point to PROD. When opening them from Application Manager, there's that great dialog box that allows you to "correct the missing half" (or something like that). I could do that, but there's hundreds of partitions (so I'd rather not do it manually).
SO MY QUESTION IS: Does MAXL (or ESSCMD) have a facility to do this "correction"?
The only possible solution I can think of is exporting the partition definitions using ESSCMD (PRINTPARTITIONDEFFILE) into text files, then write some sort of script that will go through those text files and generate MAXL scripts to create the partitions on DEV (replacing "PROD" with "DEV", of course).
I'm about to do that... but, again, I'd rather not.
- i'm lost - chewy on Jun 15, 6:18 PM
- Re: i'm lost - Javier on Jun 15, 7:54 PM
- Dude, that's NUTS! - Tim Faitsch on Jun 15, 10:14 PM
- Dude, it IS nuts - Javier on Jun 16, 10:15 AM
- so... - chewy on Jun 16, 6:37 PM
- FOILED - Javier on Jun 17, 8:18 AM
- Please keep me updated - Jeff McAhren on Jun 17, 8:39 AM
- Local host / Host file - BrettAlexander on Jun 17, 4:38 PM
- It works - Javier on Jun 20, 8:04 AM
- Cool! - Jeff McAhren on Jun 20, 12:21 PM
- Re: FOILED - Javier on Jun 17, 11:52 AM
- does it have to be partitions? - Graeme on Jun 17, 10:56 AM
- Localhost / Host file - Brett Alexander on Jun 16, 1:59 PM
- Also - Brett Alexander on Jun 16, 2:00 PM
- Re: Also - Pranav on Apr 2, 9:02 AM
- Re: Also - Javier on Apr 2, 9:31 AM
- Alternate Design - DanP on Apr 4, 11:30 AM
- Re: Alternate Design - Javier on Apr 4, 12:42 PM