IBM Planning Analytics Review
Last week on the Infocube website we published a review of IBM Planning Analytics, otherwise known as hosted TM1, or TM1 in the Cloud, or SaaS TM1. We covered things like: What is Planning Analytics Using Perspectives and Guided Exploration with Planning Analytics Visualisations Uploading Data and Security Why would you use Planning Analytics Inclusion of […]
Turbo Integrator Variable Type Quick Change
What a great trick for assigning Variable Types in TI’s – thanks to MafiaMan for this. When setting up Variables in a TI process, you can select the type for all variables in the Variables tab just by dragging your mouse over them and then change the last one to, say “Other”. They will all […]
Interim Fix For TM1 10.2
IBM has just released an interim fix for TM1 10.2 and provides important corrections. According to IBM this fix should be applied to all installations. It includes the following fixes: Number Description PM97736 PM does not respond after opening a view that was migrated in from a Cognos Planning application PM97742 Default sandbox data does […]
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 […]
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 […]
TM1 at month-end
IBM Cognos TM1 is … what it has been developed to do within your environment. Unfortunately that means most companies aren’t getting the most out of their investment as it has been sold to them as a single point solution, solving a single point problem – So I thought that over the next for months […]
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 […]
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 […]
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 […]
Messaging users of IBM Cognos TM1
Did you know that you can send messages to your users through TM1? You would be surprised how many people don’t realise that its possible – and easy!!! 1. Open TM1 Server Explorer (Perspectives) 2. Right click on your server and select “Server Manager”. From here you can actually do a few things like: Disconnecting Users and […]
TM1 10.1 – IBM Cognos Insight Review Pt 2
In the first part of this review we had a look at the workings of IBM Cognos Insight and how it can effortlessly “munch down” a multitude of file formats an “crap out” a sexy looking dashboard. The scariest part of this is that it really works – and it looks great! The Pro’s Instant […]
The [Black Box] Killer
In the past when corporate finance came across a “Big” Data problem, very often the solution was created by a member of the team particularly good with VBA and access databases. They would often slave away for days on end creating the solution to this particular problem. This solution was usually needed due to row […]
Free Trial of Cognos Insight – Big Data Analytics
A free trial of Cognos Insight is available for download on Analytics Zone – Download Now. What is Analytics Zone? Analytics Zone is a community portal focusing on Big Data Analytics. Its a great place for connecting with other analysts and data scientists, downloading modelling (Not “Project Runway”) resources, tutorials and catching up with the latest Big Data […]
TM1 10.1 Operations Console vs. CubeSpy
A simple breakdown of the differences and similarities of the new TM1 Operations Console in TM1 10.1 and CubeSpy through Installation, Features and appearance. Software Installation CubeSpy TM1 Operations Console Run the Installer. Open and Point CubeSpy to TM1 when Prompted. Add TM1 Servers. Run the Installer. Start the Applications Server via Cognos Configuration. Add the SSL Certificates […]
TM1 10.1 – The new look for Perspectives
One of the first questions I’m ever asked about a new release of any kind of software is “How does it look?”. And since TM1 10.1 introduces a new icon set across Architect and Perspectives I thought I’d add in a quick little gallery. Click the images below to see the different screens of TM1 Perspectives 10.1. Please note […]
TM1 10.1 – IBM Cognos Insight Review Pt 1 – With the Sales Challenge Data File
Back in October we posted a Sales Cube Challenge TM1 Consultants and Developers could do to gauge themselves and their skill levels – Optionally readers could send their completed TM1 Servers back to us for feedback and advice. Now with IBM Cognos TM1 10 out we thought we’ve review one of the new components (IBM […]
Introducing TM1 10.1 – The Overview
Its exciting times for anyone in Business Intelligence Industry working with IBM Solutions due to the release of TM1 version 10 last week. We will be doing quite a bit of blogging over the next few weeks about the new capabilities and components to the software package. Below is a high level overview of the […]
Guest Post: Solving a TM1 Performance Problem – Wim Gielis
One of our major customers was facing severe performance problems. The problems related to 2 cubes, in which we wanted to execute a rather tricky elimination. Please follow along while we discuss the cube architecture. We have an allocation cube with the following dimensions: Financial code (10 n elements) Year (2008, 2009, 2010, 2011, 2012) […]
CubeSpy TM1 Server Monitor – Open Beta Release!
CubeSpy Server Monitor provides TM1 Administrators with visibility and notifications about what their TM1 Servers are doing. Features: Connect to Multiple TM1 Servers of Different Versions. Monitor as many TM1 Servers as you have. Profile Creation – Group Servers by Version, Location. Windows Tray Icons Displaying Server Queues Graph with Color Coding Monitor User Idle […]
Applied Dimensionality – Hyperthreading?
Just came across this great piece on the Applied Dimensionality blog. “This’ll be a bit long (but with a hidden bonus for attentive reader), so I’ll start from conclusions. If you’re using a recent server with Intel CPUs, you’d better check whether they have Hyper-Threading (HT) and try turning it off to gain 2x speed […]
