MS Query and TM1

Post Reply
eddoria
Posts: 22
Joined: Fri Aug 10, 2012 5:07 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2003 and 2010

MS Query and TM1

Post by eddoria »

Hi all. Hopefully someone might be able to shed some light on this.

We have an Excel 2010 workbook with an ms query to our erp system. We want to add two new fields into the query and we open ms query and add them. We close and return to Excel and we can see the new columns added but on the last OK to exit they disappear from the worksheet. This is only happening for users with TM1 installed. For any other user who does not have TM1 it works and the new columns appear in the workbook.

We are using TM1 10.1.1

Any insight would be greatly appreciated.

Regards

Vera
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: MS Query and TM1

Post by lotsaram »

Sounds familiar. I'm sure this is a bug that has been posted before. Have you checked with IBM?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply