Integration

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

Useful TM1 and Planning Analytics URLs

Posted on Apr 23, 2019 by John

Here is a collection of useful TM1 URL’s. In this we have assumed that the physical TM1 server is called “tm1server”, the Cognos Application server is called “cognosappserver”, the Cognos…

Data Export Tool Review – Flyspeed

Posted on Jun 15, 2017 by John

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a…

Setting the Java Virtual Machine (JVM) in Cognos

Posted on Mar 2, 2017 by John

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop…

Tuning Cognos BI and TM1 for Maximum Performance

Posted on Mar 2, 2017 by John

Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the out of the box settings. These tuning changes are not difficult and…

Forcing Cognos BI to Use Native TM1 Engine

Posted on Feb 24, 2017 by John

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop…

Restart Order for Cognos and TM1 Servers

Posted on Feb 23, 2017 by John

What order do I use to restart Cognos BI and TM1 servers in a distributed environment? We are currently doing a project where there is a TM1 server, two Cognos…

AsciiOutput with Pipe Delimiter

Posted on Feb 17, 2017 by John

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just…

Integrating TM1 with Cognos Workspace

Posted on Feb 16, 2017 by John

One of the really cool features of the integration between TM1 and Cognos is the ability to import views of Perspectives worksheets from TM1 into Cognos BI where they can…

Text File Export from TM1 – AsciiOutput Functions

Posted on Dec 21, 2015 by John

When we are exporting from TM1 to a text file there is a set of functions we can set that modify the way the AsciiOutput process behaves.  These include: Suppress Rule Calculated values or…

How to Create a Header Row with AsciiOutput

Posted on Dec 4, 2015 by John

Asciioutput is a great way to export data from TM1. The problem with it is that it does not automatically add a header row at the top of the file…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles

Keen to chat? Book a discovery call!

pen