Search found 3 matches

by natb
Tue Sep 16, 2008 2:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The Sound Of No Hands Clapping
Replies: 64
Views: 44495

Re: The Sound Of No Hands Clapping

I was at the Forum two weeks ago. I was hoping that I would learn more of technical stuffs on TM1 like I got to learn at MS TechEd. They seem to concentrate on the integration of Cognos 8 and TM1 and how great their products are. I don't get to use Cognos at work so .... :?
by natb
Mon Sep 15, 2008 12:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Duplicate column names using SQL Server - OPENQUERY
Replies: 6
Views: 14653

Re: Duplicate column names using SQL Server - OPENQUERY

The reason that I tried to query the data from TM1 this way is that I am in a process of testing out 'MDX query' against TM1 cubes to see what MDX statements work and what not. My team and I have more experience in MS SQL Server than TM1 and we created many SSRS reports querying data directly from S...
by natb
Fri Sep 12, 2008 7:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Duplicate column names using SQL Server - OPENQUERY
Replies: 6
Views: 14653

Duplicate column names using SQL Server - OPENQUERY

Hi there, I am wondering if anyone ever tries querying TM1 data from MS SQL Server (SSMS) using OPENQUERY. We have TM1 cubes and are planning to use TM1 writeback abilities to help with some modelling and forecasting. Once users finish forecasting their data, we would like to create reports using MS...