Navision to TM1 TI process with SQL

Post Reply
TomHine
Posts: 7
Joined: Fri Apr 15, 2011 11:34 am
OLAP Product: TM1
Version: TM1 9.1
Excel Version: 2003 - 2007
Location: London, UK

Navision to TM1 TI process with SQL

Post by TomHine »

Hi,

Does anyone have any experience using Navision with TM1 and getting balance information for P&L, balance sheet and cash flow primarily with a veiw to expanding at a later date?

I'd appreciate anyones comments on this.

Regards

Tom
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Navision to TM1 TI process with SQL

Post by declanr »

I have completed a couple of projects that pulled in General Ledger data which originated from Navision.

The data was held in SQL tables underneath so it was just a case of finding someone who knows the SQL tables well enough and then the fact it originates from navision is irrelevant as far as TM1 is concerned.
Declan Rodger
Post Reply