Category Archives: Cognos Insight

TM1 Tutorials remodelled with added analytics

I’m pleased to announce that TM1 Tutorials.com has had a complete rebuild and today we have launched the new site, just in time for IBM Information On Demand (IOD). Please head on over to the new and improved TM1 Tutorials.com and see for yourself what all the fuss is about! You can also track our progress at IOD by following @TM1Tutorials on twitter. The new TM1 Tutorials website is now … Continue Reading

This entry was posted in Cognos BI, Cognos Disclosure Management, Cognos Express, Cognos Insight, IBM Cognos TM1, SPSS, Training Material and tagged IBM Cognos BI, IBM Cognos Disclosure Management, IBM Cognos TM1, IBM SPSS, IBMIOD, Information on Demand. Bookmark the permalink. | Tagged IBM Cognos BI, IBM Cognos Disclosure Management, IBM Cognos TM1, IBM SPSS, IBMIOD, Information on Demand | Leave a comment

Finding the Rules Editor in Cognos Insight

I was tasked to draft up something on Cognos Insight.  Without going through the Cognos Insight user guide, I have got stuck when trying to link data between cubes.  “How I do edit rules in Insight?”, I asked. Until I have got a reply from a colleague, “Look for the widget toolbars!”. Have you ever been wondering why there are so very few menu options on the main toolbar in … Continue Reading

This entry was posted in Cognos Insight, Training Material and tagged Cube Rules, IBM Cognos Insight, Modeling, Rules Editor. Bookmark the permalink. | Tagged Cube Rules, IBM Cognos Insight, Modeling, Rules Editor | Leave a comment

CX/TM1 Monitoring on the App Store – Spark Mobile

Spark Mobile is now on the iTunes App Store. Thanks to all the beta testers. You can access and download the free iPhone / iPad App here. This brings the insights the Spark Cloud has to offer, direct to your mobile device! Notifications about significant events can now be pushed directly to your mobile device and at a touch you can now see Server Configuration, Logs and TM1Top Activity. We hope you … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, InfoCube Spark, TM1 10.1 and tagged Cloud, Congos TM1, IBM Cognos Express, IBM Cognos TM1, InfoCube Spark, Monitor. Bookmark the permalink. | Tagged Cloud, Congos TM1, IBM Cognos Express, IBM Cognos TM1, InfoCube Spark, Monitor | 2 Comments

Neglected Functionality – Custom Rollups & Subset Consolidations

In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked and underused. In this article I’m going to explain Custom Rollups and Subset Consolidations within IBM Cognos TM1. Custom rollups are used to create a temporary user-defined consolidation element. It is a very useful, but somewhat underused functionality. With custom rollups, you won’t be able to save the subset but … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training. Bookmark the permalink. | Tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training | 3 Comments

Testing Turbo Integrator Code

Calculated Variable Formula Window

In the last post we talked about how we can output String and Numeric values in a Fixed Width Field Format. I realised just after writing the article that I used a not-well-known trick in order to perfect the snippets I posted. This is: Using Calculated Variables to Test Field Calculations. I’m going to use the example of the numeric field from the last post to present how to better … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, Training Material and tagged IBM Cognos Express, IBM Cognos TM1, Scripting, Turbo Integrator. Bookmark the permalink. | Tagged IBM Cognos Express, IBM Cognos TM1, Scripting, Turbo Integrator | 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 on … 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

IBM Cognos Users – Have your say! (BI Survey 2013)

Afternoon, Its time again for the BI Survey. I think not many IBM Cognos users actually take this survey which is reflected in the results. So… Click here to take part. All participants will: — Receive a summary of the survey results — Be entered into a draw to win one of ten $50 Amazon vouchers — Ensure that your experiences are included in the final analyses Please Note: TM1 … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1 and tagged BI Survey, Business Intelligence, IBM Cognos, IBM Cognos TM1. Bookmark the permalink. | Tagged BI Survey, Business Intelligence, IBM Cognos, IBM Cognos TM1 | Leave a comment

InfoCube Spark v1.2 – TM1 Minor Error Logs

Version 1.2 of InfoCube Spark has just been released. To our loyal clients: This should patch itself so theres no action required on your side. New Features: TM1 Server.log interrogator. You can now browse and filter the TM1Server.log from all monitored TM1 Application Servers.  New Page on Spark! Minor Error Logs are now incorporated into the Spark, so you can now remotely debug a users issues without racing back into the office. … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, CubeSpy TM1 Server Monitor, IBM Cognos TM1, InfoCube Spark, TM1 10.1 and tagged IBM Cognos, IBM Cognos TM1, InfoCube Spark, TM1, TM1 Software, tm1s.cfg, TM1Server.log. Bookmark the permalink. | Tagged IBM Cognos, IBM Cognos TM1, InfoCube Spark, TM1, TM1 Software, tm1s.cfg, TM1Server.log | Leave a comment

InfoCube Spark – An Introduction

In 2005 Google Launched Google Analytics – a platform for analyzing website traffic by geography, source, keywords and 114 other dimensions. This free value-add platform is now used in 55% of the top 10,000 websites and used by 55% of fortune 500 companies who quickly realized that more timely insights which are more widely accessible drives greater response time and better ability to avoid problems before they occur. I’ve often … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, CubeSpy TM1 Server Monitor, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged IBM Cognos, IBM Cognos TM1, InfoCube Spark, Server Logs, Software, Spark, TM1 Top, TM1 Training. Bookmark the permalink. | Tagged IBM Cognos, IBM Cognos TM1, InfoCube Spark, Server Logs, Software, Spark, TM1 Top, TM1 Training | 2 Comments