The Proof of the
Pudding is in the Eating
Let’s try some of that delicious EPMA pudding
by trying to do a deploy from EPMA.
Here’s SampApp1 in the EPMA Application
Library. What happens when we try to deploy SampApp1?
Uh oh, that doesn’t look good. It seems odd
that there could be a validation error when the transformation from Classic to
EPMA just went through flawlessly.
Going to the Job Console and looking at the
error message suggests that the Plan Type dimensions haven’t been ordered. We
are about to touch upon a minor stupid trick because, of course, the dimension
order was set in the Classic Planning application.
Minor Stupid Trick
When you convert a Planning application to
EPMA, understand that—for whatever reason—EPMA doesn’t pick up the dimension
order. It’s actually there, you just need to change the order of one dimension
to get them all to take.
Go into the EPMA Dimension Library, and select
the application. The easiest way to do this is to double-click on the
application within the Application Library. Then right-click on the application
name, and select Performance settings.
Change the position of one dimension, and then
move it back to its original location, and you have fixed this particular
issue.
In this case, I chose Account and moved it up
to the top of the list, and then back to its original second position.
Up the Ladder
Back Down the Chute
That’s it! It only takes a minute. Now let’s
try that deploy.
Deploying the
Database
Let’s do a full deploy.
Did you notice that a Create Outline is not
possible in EPMA after the very first deploy (which in this case was handled
via Classic Planning)? This is super nice because sooner or later in Classic
Planning you will select Create Outline, and then hate yourself as all of your
data and other Essbase artifacts get deleted forever. You’ll only do it once,
but why experience the pain?
And we have confirmation that the application
is now a fully fledged EPMA application. Go on, make those dimensions shared,
learn all about the .ads file format, use Data Synchronizer. In short, unleash
your inner EPMA geek.
What’s that? You goofed? EPMA is not for you?
What to do?
Enter the stupid trick with a warning.
