Essbase Java API export database MAXL

Question

I've been having trouble running the MaxL "export database" command with the Java API. I've tried using code like this:( Referred to Essbase Java API Sample com.essbase.test.ExecuteMaxl.java)

IEssMaxlSession test = olapSvr.openMaxlSession("test"); test.execute("export database sample.basic using report_file 'top.rep' to data_file 'c:/topExp.txt'"); It fails with the following exception:

Cannot execute maxl statement. Essbase Error(1290101): This MaxL statement requires client support. This is not supported yet.

I am running Essbase 11.1.2.1 and the same version of the Java API.

score 1 · Answer 1 · answered Nov 28 '14 at 00:14

1

You did not tell to Essbase where to find the report file. If the "top.rep" is on the server then you must explicitly refer to it in the Maxl statement. So, it will be: "...using server report_file". Otherwise, if the file is hosted on the client, you must specify the path as you did for the output data file (eg. "c:/top.rep")

Rgds, AleMon

answered Nov 28 '14 at 00:14

alemon

11
1

I did tried to execute as export database sample.basic using server report_file 'top.rep' to data_file 'c:/topExp.txt'. Still I get the same error. – Chandan C Dec 01 '14 at 07:06
Save the MaxL statement in a file and use essmsh instead of japi. On Win should be: startMAXL.bat "c:\yourmaxl.msh" – alemon Dec 14 '14 at 03:01

score 0 · Answer 2 · answered Nov 28 '14 at 23:48

0

Running MaxL commands through the Java API in my experience does not work, giving the error indicated (aka, it potentially relies on some native code like in the C API, but as it says, it's not supported). Why not use the report running command in the Java API?

answered Nov 28 '14 at 23:48

jwj

528
3
13

I wanted to use a common code to export data and metadata (Members), as export outline is fastest, I taught of using export data & export outline respectively. Sadly both give same error. – Chandan C Dec 01 '14 at 07:08

score 0 · Answer 3 · answered Dec 03 '16 at 20:39

To export data why not use the java api method exportData

    private static void exportData(IEssCube cube) throws EssException {
    System.out.println("Exporting data BSO");

    // As the path is relative, file will be exported to "ARBORPATH/app/Demo/Basic" on Essbase server.
    cube.exportData("Demo/Basic/exportedData.txt",IEssCube.EEssDataLevel.ALL, true);


    // As the path is absolute, file will be exported to "C:/temp/exportedData.txt" on Essbase server.
   //cube.exportData("C:/temp/exportedData.txt",IEssCube.EEssDataLevel.ALL, true);

    System.out.println("Exporting data Complete.");

}

Essbase Java API export database MAXL

3 Answers3