Essbase API

by kkikta 7. January 2011 15:36

On and off for the last few months I've been playing with the Essbase API and trying to initialize it in C#. Apparently I am in need of some assistance, for the life of me I can't figure out how to get this thing started. I refuse to accept the idea that I should use the JAVA API and expose the functionality through web services (this is what Dodeca does). So really this is just a rant and maybe a shout out asking if anyone has some samples. Coming from a development background I have been kinda shocked that there is so little code available for public view with regards to this API.

Anyway here are some things I was trying this morning but I am giving up on for now and gonna go work on my IMAP stuff.

 

 

public unsafe struct EssbaseInit
{
    public ulong Version;
    public ushort MaxHandles;
    public string LocalPath;
    public string MessageFile;
    public string HelpFile;
    public ushort ClientError;
    public ushort ErrorStack;
    public ushort usApiType;
    public Int64 vbCallbackFuncAddress;
}
[DllImport("lib\\esbapin.dll")]
public static extern long EsbInit(IntPtr init, ref long instance);
public static unsafe long EssInit(ESB32.EssbaseInit init, ref long instance)
{
    int size = Marshal.SizeOf(typeof(ESB32.EssbaseInit));
    IntPtr handle = Marshal.AllocHGlobal(size);
    Marshal.StructureToPtr(init, handle, true);
    return EsbInit(handle, ref instance);
}

Tags:

Oracle

Comments (3) -

Andrew
Andrew
1/31/2011 1:43:54 PM #

Hello,

Did you get any further with this? we are also trying to do something very similar, it would be interesting for us to know whether you managed to get this working.

What was not working exactly? did you get an Exception? error code?

Best Regards

Andrew

Reply

Quentin
Quentin
2/23/2011 6:50:38 PM #

Have you found a solution? I've got the same thing to do.
Thanks

Reply

John
John
2/25/2011 1:02:03 AM #

I ride the bus with someone who has been able to develop a full implementation id the Essbase API available as a dll that you can include in any .NET project and call all api functions just like in VB6/VBA. He said he is going to release it soon but is charging something $495 per developer license as apparently a lot of people are interested in it.

Reply

Add comment



  Country flag
biuquote
  • Comment
  • Preview
Loading


Month List

Page List