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

Post Reply
tomdekuyffer
Posts: 10
Joined: Tue Jun 02, 2009 2:51 pm
Version: 9.1
Excel Version: 2003

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

Post 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
tomdekuyffer
Posts: 10
Joined: Tue Jun 02, 2009 2:51 pm
Version: 9.1
Excel Version: 2003

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

Post by tomdekuyffer »

Is there nobody out there who faced this challenge ?

I would be most gratefull.

Tom
ParisHilton
Posts: 73
Joined: Fri Apr 23, 2010 11:35 am
OLAP Product: Tm1
Version: 9.5
Excel Version: 2007 2010

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

Post 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.
“The way I see it, you should live everyday like its your birthday”


TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
tomdekuyffer
Posts: 10
Joined: Tue Jun 02, 2009 2:51 pm
Version: 9.1
Excel Version: 2003

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

Post by tomdekuyffer »

Thx 4 the info.
I didn't know Paris Hilton was that smart :-)
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

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

Post 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?
tomdekuyffer
Posts: 10
Joined: Tue Jun 02, 2009 2:51 pm
Version: 9.1
Excel Version: 2003

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

Post 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
Post Reply