Page 1 of 1

Conn./reading/writing to TM1 cubes and processes out of JAVA

Posted: Tue Jun 08, 2010 4:03 pm
by tomdekuyffer
Hi all,

It's been some time that I visited this forum, because unluckily for me TM1 got a bit out of the picture in my day to day job.
Luckily (?) for me , things are changing, so I will be able to use TM1 again.

I have a customer who is interested in using the TM1 server as a backbone of it's propriatary created portal reporting and performance management system.

Can any-one please advise me how on could :
- connect to the server
- read/write cube data
- start + fill in prompts of the TI processes

This all should be possible out of a java based system. Does anyone have experiance with this situation ?
Should i use ODBO drivers ? Should I use tha JAVA API ? Or maybe both ?
Which is the way to go ? What should I avoid ?

Your help is much appriciated,
Tom

Re: Conn./reading/writing to TM1 cubes and processes out of

Posted: Mon Jul 05, 2010 3:06 pm
by tomdekuyffer
Is there nobody out there who faced this challenge ?

I would be most gratefull.

Tom

Re: Conn./reading/writing to TM1 cubes and processes out of

Posted: Mon Jul 05, 2010 9:47 pm
by ParisHilton
I've not tried Java , but I am making progress with the other API's.
If you check out the help files, there is brief coverage of every call. You should be able to figure out if the API meets your needs.

I've only executed a TI process so far as processes go and that was fairly straightforward. Getting to grips with capsules is fun, but once you get the hang of it accessing cubes for reading/writing via the API isn't too bad.

Re: Conn./reading/writing to TM1 cubes and processes out of

Posted: Tue Jul 06, 2010 2:40 pm
by tomdekuyffer
Thx 4 the info.
I didn't know Paris Hilton was that smart :-)

Re: Conn./reading/writing to TM1 cubes and processes out of

Posted: Tue Jul 06, 2010 10:37 pm
by lotsaram
tomdekuyffer wrote:I have a customer who is interested in using the TM1 server as a backbone of it's propriatary created portal reporting and performance management system.

Can any-one please advise me how on could :
- connect to the server
- read/write cube data
- start + fill in prompts of the TI processes

This all should be possible out of a java based system. Does anyone have experiance with this situation ?
Should i use ODBO drivers ? Should I use tha JAVA API ? Or maybe both ?
Which is the way to go ? What should I avoid ?

Your help is much appriciated,
Tom
Yes it all sounds possible but simple question: why would you want to go and write your own contributor or web front end when these already exist?

Re: Conn./reading/writing to TM1 cubes and processes out of

Posted: Thu Jul 08, 2010 2:51 pm
by tomdekuyffer
Because the customer has it's own front-end already largely built, because of it's interaction to it's own mail-system, document-management-system and workflow-system.
The cost of ownership is huge here....
That's why.
Can you give more info on how ?
Thx in advance.
Tom