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
Conn./reading/writing to TM1 cubes and processes out of JAVA
-
- Posts: 10
- Joined: Tue Jun 02, 2009 2:51 pm
- Version: 9.1
- Excel Version: 2003
-
- 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
Is there nobody out there who faced this challenge ?
I would be most gratefull.
Tom
I would be most gratefull.
Tom
-
- 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
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.
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.
TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
-
- 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
Thx 4 the info.
I didn't know Paris Hilton was that smart
I didn't know Paris Hilton was that smart

-
- 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
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 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
-
- 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
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
The cost of ownership is huge here....
That's why.
Can you give more info on how ?
Thx in advance.
Tom