Search found 5 matches

by sqzeezer
Thu Mar 26, 2009 10:44 am
Forum: MS Analysis Services
Topic: Access MSAS from Java
Replies: 0
Views: 50492

Access MSAS from Java

Hello

I want to access Microsoft Analysis Services 2008 from Java. I am looking for an API enabling me to make queries as well as cube manipulations.
Are there any libraries you could recommend me? I did a Google search but could not find anything really useful.

Thanks for your help!

Marc
by sqzeezer
Tue Mar 24, 2009 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Measuring TM1 Performance / Benchmark
Replies: 1
Views: 2444

Measuring TM1 Performance / Benchmark

Hello I am setting up a Cognos TM1 benchmark to measure the execution time to open several views, insert elements, process cubes ... and I wanted to ask you if you have any idea how to measure tm1 execution time? I have done a similar benchmark for Microsoft Analysis Services and I used a profiler t...
by sqzeezer
Tue Mar 24, 2009 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load Parent Child Hierarchies from ODBC into TM1
Replies: 25
Views: 19222

Re: Load Parent Child Hierarchies from ODBC into TM1

This should do what you want; it goes in the Metadata tab of the process: One point to note; the code assumes that the records are returned in hierarchy order as per your sample. That is, that a parent will always have been added as a "child" before an attempt is made to add any children ...
by sqzeezer
Tue Mar 24, 2009 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load Parent Child Hierarchies from ODBC into TM1
Replies: 25
Views: 19222

Load Parent Child Hierarchies from ODBC into TM1

Hello everybody, I have the following problem: I want to import a parent child hierarchy from a relational database to a TM1 dimension. The relational database looks like this: Parent | Child A A A B B C A D E E E F ... So the dimension I want to import is the following: A |-B | |-C |-D E |-F ... I ...