Leave a Reply

0 thoughts on “jMnDLoader a graphical approach for loading data and metadata into Hyperion Planning

  • Peter Nitschke

    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

  • Peter Nitschke

    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

  • Kapil

    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