This one was there in my drafts for about 2 years. Now that a long time considering that I was trying to create a utility. Now what was/is this about, it is about a thread on Network54 where Cameron Lackpour talked about adding a graphical interface to the OutlineLoad.cmd. I thought well that it is a good tool to work on (considering the number of switches you have to remember to make it work).
Then started the work and I could finish that in two weeks time. (Now you would be imagining, didn’t he said two years) It was done in VB and my employer at that time was not comfortable with me publishing it 🙁
After few months Oracle came up with a web interface for Outline Load and I shelved mine 🙁
I was surprised when I got a call from my ex-colleague, asking about the possibility of running that on a Linux machine. This prompted me to create a java version so that I can run that on Windows and *nix systems.
I was lazy to work on that one (there is a web one out there and who will be interested – was my reason)
Why now? Someone reminded me that they’ve seen my tool and they are on 11.1.1.4 version and I realized that there is no such thing as web interface for that version. (there are a lot of versions that we are dealing with and I can’t remember what came in which version ;))
So here we are jMnDLoader, the tools provides you with a graphical interface for OutlineLoad utility. It has an option where you can generate MetaData.
This is not a client version, it needs to be executed on the Planning server.
Tool makes intelligent selections for you 😉 as you can see for Dry run, it’ll not lock the dimension and rest of the options are not enabled.
This is still on the 11.1.1.x format (it doesn’t have an option to add properties), however the screen captures are from a 11.1.2.3.500 version (it works with 11.1.2.3.500, except for the properties part)
You can generate Metadata using the tool.
I’ve added a help file to the tool, you can find more details on how it works there.
I’m planning to integrate EPMA metadata generation and if all goes well, maybe an interface for the infamous EPMA batch client.
You can download jMnDLoader from here.
HTH
That's very cool!
I've actually been doing some work back in 11.1.2.1 – had to dust off the old batch scripts that I used to build metadata.
I'll pull down a copy and have a play. Thanks for releasing it!
Cheers
Pete
Hey – a few quick things:
Since this has to run on the server, you can normally pickup the Java path by doing something like:
For Java 1.6
FOR /F "tokens=2*" %%a IN ('REG QUERY "HKEY_LOCAL_MACHINESOFTWAREJavaSoftJava Runtime Environment1.6" /v JavaHome') DO set "JavaHome16=%%b"
ECHO %JavaHome16%
For Java 1.7
FOR /F "tokens=2*" %%a IN ('REG QUERY "HKEY_LOCAL_MACHINESOFTWAREJavaSoftJava Runtime Environment1.7" /v JavaHome') DO set "JavaHome17=%%b"
ECHO %JavaHome17%
You can do some basic IF missing on that to work out the version.
Also – you can use the %HYPERION_HOME% environmental variable to get the path of the Hyperion implementation. I think that later changes to %EPM_ORACLE_HOME% (not sure which version) – but a similar lookup is possible.
Cheers
Pete
Nice code Pete, I'm just making people enter the value themselves 🙂 maybe next version I'm going to use your code 🙂
Thank you
Thank you, please let me know how it went
Hi Celvin,
Check out the SMCS. We're working on client version which would enable load to EPMA version directly from Excel.
In testing stage as of now but it's going to be exciting soon.
Rgds,
Kapil