IBM Cognos TM1 and Express Monitoring

The first in our series of Spark related YouTube Videos. Make TM1 Administration a day at the beach! Take a look here now: a day at the beach Username: tester Password: abc123  

This entry was posted in Cognos Express, CubeSpy TM1 Server Monitor, IBM Cognos TM1, InfoCube Spark and tagged Cognos TM1, CubeSpy, IBM Cognos, InfoCube Spark, Server Monitor, TM1 Server, TM1Server.log. Bookmark the permalink. | Tagged Cognos TM1, CubeSpy, IBM Cognos, InfoCube Spark, Server Monitor, TM1 Server, TM1Server.log | 1 Comment

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

Woohoo! TM1 Tuts has cracked 100,000 visits!

This is just a shout out to all the administrators, support teams and developers who have browsed or subscribed to the TM1 Tutorials blog over the last two years. Thanks, your the best and we are so pleased to have the opportunity to share our time tested tips and tricks with you all If you are new to TM1 Tutorials, take a moment to read through the topics we have covered … Continue Reading

This entry was posted in Bug Fix, Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 Contributor, TM1 pre 10.1, Training Material and tagged Cognos TM1, Feeders, IBM Cognos TM1, Rule Feeders, Turbo Integrator. Bookmark the permalink. | Tagged Cognos TM1, Feeders, IBM Cognos TM1, Rule Feeders, Turbo Integrator | Leave a comment

Your Lifeline, The TM1 Transaction Log

Super-Undo – backing out transactions in TM1 is not at all difficult. First of all here is the view of the Salary cube with data: And one after the data is accidentally flushed out: There are 2 ways to navigate to the Transaction Log window through TM1 Perspectives: Click on your Server name from the list and Click Server > View Transaction Log Right click on your server name and … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Architect, Backing Out Changes, IBM Cognos TM1, Perspectives, TM1, Transaction Log. Bookmark the permalink. | Tagged Architect, Backing Out Changes, IBM Cognos TM1, Perspectives, TM1, Transaction Log | 1 Comment

Creating basic Top 10 reports using MDX expression

One of the most common requests for reports is to generate a list of top 10 for a dimension based on TM1 data. This makes sense considering level of data TM1 works best with; this could cover top 10 consumers, customers or top 30 SKUs at one particular outlet or within a brand. There are several ways to achieve that within TM1, the simplest way to do this within a … Continue Reading

This entry was posted in IBM Cognos TM1, Training Material and tagged Excel, IBM Cognos TM1, MDX, Reporting. Bookmark the permalink. | Tagged Excel, IBM Cognos TM1, MDX, Reporting | 9 Comments

How to write easily understood Turbo Integrator code

As many of TM1 consultants know, reading TI code always has the possibility of being a tricky task – especially if it is someone else’s code. This is mostly due to TM1 Perspectives Turbo Integrator lacking Syntax Highlighting (See our Notepad++ highlighter) but in part it is due to poor variable naming, indenting, casing or things simply not developed consistently throughout the model.

This entry was posted in IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged IBM Cognos TM1, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged IBM Cognos TM1, TI Process, Turbo Integrator, TurboIntegrator | 4 Comments

Broken Transaction Log?

With Windows Vista, 7 and many of the newer server editions of Windows a Microsoft security fix has removed a component which TM1 Perspectives & Architect use to display the Transaction Log browser.  This component is called “MSMask32.ocx” which traditionally belongs in the System32 folder. To get this working again on these machines: Download the component here: msmask32.zip Save these to the appropriate folder below: On a 32-bit computer save to C:\Windows\System32\ On … Continue Reading

This entry was posted in Bug Fix, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged Bug, IBM Cognos TM1, Transaction, Transaction Log. Bookmark the permalink. | Tagged Bug, IBM Cognos TM1, Transaction, Transaction Log | 1 Comment

Removing old TM1 Servers from "Services"

When upgrading a clients environment to IBM Cognos TM1 10.1 I noticed a bunch of older TM1 Services. A quick google reveals that you can remove services by using the following command line: sc delete “Service Name” Note: If you have a TM1 Service setup as: “TM1 Server x64 / Production Server” you will use the following command sc delete “Production Server” Is it about time you cleaned up the … Continue Reading

This entry was posted in TM1 10.1, TM1 pre 10.1 and tagged IBM Cognos TM1, Install, Installation Guide, NT Service, TM1, TM1 Installation. Bookmark the permalink. | Tagged IBM Cognos TM1, Install, Installation Guide, NT Service, TM1, TM1 Installation | Leave a comment