TM1 Forum

Hi Guys

My client is working on cognos express version 10.1 and pointed out to me that since they have had it installed on their machines, they can no longer add columns to tables created from a Sql Server connection. i have played around with this on my machine which runs of TM1 version 9.5.2 and found that if i remove the perspectives add in, i can add columns, but if the add in is there, i cannot add columns.

if we have the table open and refresh (normally if there was an extra column added in Sql, it would now appear on the table), the new column appears for a fraction of a second, and then disappears. it is the same if we manually insert the column - it appears for a fraction of a second, and then disappears.

i am using excel 2010 and my client is using various excel versions including 2010 and 2007. i have logged a call with IBM (PMR 65006,999,864) and they have told me they are working on a fix for 10.2. does anyone have any suggestions while i wait for that fix?

thanks,

I have noticed this also as I find myself at the moment using SQL server data connection quite often to verify TM1 cube data back to the staging DB. The only solution is to load Excel without tm1p.xla, save the file with the changes to the source table then load TM1.

I would suggest you raise a bug.