Tag Archives: TM1

Setting the Java Virtual Machine (JVM) in Cognos

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 Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. The next setting that we need to configure is the Java Virtual Machine, or JVM. Wikipedia defines a Java Virtual Machine … Continue Reading

This entry was posted in Administration, BI Admin, TM1 Admin and tagged 10.2.2, Cognos BI, JVM, performance, TM1. Bookmark the permalink. | Tagged 10.2.2, Cognos BI, JVM, performance, TM1 | 1 Comment

Tuning Cognos BI and TM1 for Maximum Performance

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 can significantly enhance both the speed and usability of both tools. How can BI and TM1 be Integrated When used together we can use Framework Manager to prepare data from a database before it is loaded into TM1, we can … Continue Reading

This entry was posted in Administration, BI Admin, TM1 Admin and tagged 10.2.2, Cognos BI, performance, TM1. Bookmark the permalink. | Tagged 10.2.2, Cognos BI, performance, TM1 | 1 Comment

The Pick List – How to Create and Use Picklists in TM1

Picklists in TM1 are a great way for you to ensure that users only “enter” (or in this case select) a value from a standard list of options. For example, you might want a user to enter a three character month like Jan, Feb, Mar etc. You could design your cube to have a text element and then ask users to enter periods in that format. This will work perfectly … Continue Reading

This entry was posted in Attributes, Cubes, Dimensions, MDX and tagged Picklists, TM1. Bookmark the permalink. | Tagged Picklists, TM1 | Leave a comment

Security in TM1 is one of those things that can make a TM1 administrator go crazy over new requirements or over setting up a new user. Things do not get better with reading the documentation, which does not cover all aspects or the security inner workings. In the following post, the TM1 security is peeled layer-by-layer starting from the very basics of cube security and finished with multi-layer multi-group security … Continue Reading

| 5 Comments

Transfering Data between TM1 Servers using ODBO (i.e. Without CSV's)

This blog shows the steps needed to establish an ODBO connection in order to  transfer data between 2 cubes in different server instances.

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 10.2, Training Material and tagged Datasource, ODBO, TM1, Turbo Integrator. Bookmark the permalink. | Tagged Datasource, ODBO, TM1, Turbo Integrator | 3 Comments

How to use SPSS Modeler and Time Series Algorithms to Forecast Revenues

A planning exercise typically involves a batch of spreadsheets, which probably look chaotic and consumes a lot of time to maintain. A much better, more efficient and optimised option is to use specialised software for this work, like TM1. Using TM1, speeds up the process considerably and the planning process is a lot more efficient. But still you have to rely to some arbitrary decisions regarding next years budget, like … Continue Reading

This entry was posted in SPSS and tagged Analytics, Cognos BI, Forecast Revenues, IBM SPSS Modeler, Predictive, SPSS, Time Series, Time Series Forecast, TM1. Bookmark the permalink. | Tagged Analytics, Cognos BI, Forecast Revenues, IBM SPSS Modeler, Predictive, SPSS, Time Series, Time Series Forecast, TM1 | Leave a comment

10 Point Health-Check: Part 2

This is part 2 of our 10 point health check for TM1. Please see this link for Part 1. 7. Fine-Tuning Application Settings Both the TM1 Server and Client have Settings files which should be tweaked in order to get the most out of your TM1 Implementation. While the default value of 98% of the settings are great for a best practices implementation, this leaves a few tweaks which can … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Health Check, TM1. Bookmark the permalink. | Tagged Health Check, TM1 | Leave a comment

10 Point Health-Check: Part 1

1. Hardware Specifications – Memory This item is first on our list simply due to the implications of exceeding the amount of memory on your hardware – be it virtualized or not. Within 32-bit Servers consuming all available memory will crash a IBM Cognos TM1 Server in most cases, Under 64-bit Hardware the Pagefile will be used which is approximately 8 times slower than Memory. The Bottom Line: While TM1 is … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Health Check, TM1. Bookmark the permalink. | Tagged Health Check, TM1 | Leave a comment

Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The tips below will make things easier for you. ASCII Quote Character Options To start your extract process … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator. Bookmark the permalink. | Tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator | Leave a comment

Monte Carlo simulation with TM1

A bit about Vangelis: Hi, I am Vangelis, I am from Greece and now I live in Sydney Australia. Currently, I’ m working as a consultant at Infocube Consulting. I have expertise in IBM Cognos products, BI and TM1 and also in mathematics and statistics. My academic background consists of a BSc in Mathematics, MSc in Finance & Banking, MSc in Information & Telecommunications Technologies and a couple of certifications … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, TM1 10.1 and tagged Cognos Insight, Monte Carlo simulation, TM1. Bookmark the permalink. | Tagged Cognos Insight, Monte Carlo simulation, TM1 | 2 Comments