While working for a particular client project, I was asked to review an existing long running Turbo Integrator (TI) process and find out ways to optimise its processing time, without compromising on the business functionality. Synopsis: A process was created to adjust the amount between cost centres and products based on defined From and To mapping in a mapping cube. A simple example could be, amount from one cost centre be adjusted to multiple centres within its division or a consolidation of centre within a division mapped to same consolidation but for a different product. To achieve this, ...

In this blog, would like to introduce you to a new feature called "Compare Sandboxes"; this feature, an extension to Planning Analytics Workspace’s existing capability, shall be available both on Cloud and in Local versions. What is a Sandbox? (Jump to “Feature Explained” section if you are an existing TM1 user & know this well) A Sandbox lets you create your own personal workspace, your own version where you can enter & store data-value-changes without impacting the base (actual) data. A sandbox is not a copy of the base data, but a separate overlay or a layer of your own data values ...

The last 3 weeks has been great in that it has showed an avenue that I had yet to explore in Planning Analytics, debugging. To say it has been highly frustrating at times is an understatement, however I know I only get stressed when I’m learning a difficult concept. It sometimes hard when looking at code that isn't' documented, exactly why this or that piece of code is necessary. Debugging work has benefited me in understanding and developing a methodology to enable me to learn the overall logic and flow of a model/system. Understanding and being able to follow personalised instead of best ...

If you haven't seen already the latest version of Cognos Analytics is now available for you to download. Luckily you won't need to read the about the latest changes. You can view this youtube clip which will explain what's new in it's reporting, dashboarding, stories and the portal for IBM Cognos Analytics 11.0.11. If you don't have the time some advanced features include using custom polygons and points for mapping. Also included is data caching in dashboards and stories, as well as support for Portal Pages, and controlling object visibility. To download the software you can find the ...

Let me preface this blog by saying that my trip to India was so insightful, culturally rich and filled with great people that it was hands down the work trip of a life time. Amendra may have had other plans but for me this trip was about creating new connections and deepening my understanding of our cross border colleagues from all our offices. Upon reflection I can easily say that we weren't colleagues for very long and are now people I consider friends. Well some of them, in-particular those who didn't want to Shoot me?! I still don't know where the finger guns came from but I suspect thats ...