VBA wrapper for TM1 API?

[mitch23]

Does anyone know if Cognos has any plans for exposing more of the API functionality through VBA (I guess essentially a VBA wrapper around the API)? The API is obviously very difficult to use.

[Alan Kirk]

Does anyone know if Cognos has any plans for exposing more of the API functionality through VBA (I guess essentially a VBA wrapper around the API)? The API is obviously very difficult to use.

Pretty unlikely I think. Based on my dealings with support over some API work that I've done, the API doesn't seem to be number 1 on their hit parade. F'rinstance there are some painfully obvious omissions from it which they don't seem to be too interested in providing (the number of ports used by an individual user comes to mind), and they aren't intersted in providing official support for (or documenting) the function which lets you piggy-back of your Excel connection.

There is in fact a third party commercially available product which does provide a such a wrapper though. I'd point you to the post in the Commercial forum which introduces it to you, but for some reason the person who produced it hasn't made one yet (hint, hint, Paul).

[paulsimon]

Thanks Alan

I will get around to putting something on the Commercial bit of the forum soon. For the moment I will send a private message.

Regards


Paul Simon

[Kyro]

The API can be very complex, but by creating a couple of helper functions like objectHandleGet,objectHandleGetByName,objectPropertyGet and a objectCount you make life a hell of a lot easier.