Every week we publish a new blog post on IBM Planning Analytics Tips & Tricks. Some of these focus on how to use new features in IBM Planning Analytics and others explain how to optimize key aspects of the core TM1 engine.
We took a look at our analytics (yes, we don’t just implement analytics, we use them too!) to see which blog posts with tips & tricks are the most popular with Revelwood clients and visitors to Revelwood’s Knowledge Center. Here are our most popular blog posts on IBM Planning Analytics and TM1.
1. Working with the TM1 REST API
In this blog post, Nina Gordy, a consultant in our Professional Services Group (PSG), delivers tips on working with the TM1 REST API. Nina worked extensively with the REST API while she was on the development team for Quantum, our TM1 mobile application for system administrators.
Lee Lazarow, our FPM technical director, details how to easily visualize data in IBM Planning Analytics Workspace. He explains the three easy steps you need to take in order to turn your data into a map.
In this blog post, also written by Lee, we provide tips on logging with Turbo Integrator. The proper use of logging can help minimize the amount of disk space needed in your environment and may also help improve the efficiency of your data load processing.
4. Using MDX to Compare Dimensions Hierarchies
MDX, which stands for multidimensional expressions and is similar to SQL, is for multidimensional data in OLAP cubes. TM1, however, has a unique implementation of MDX. Shane Bethea, also a consultant in PSG, explains how TM1 dimensions often have multiple hierarchies that should all roll up to the same total. But sometimes they get out of sync. This is where MDX comes in – it can be used to see if both hierarchies contain the exact same number of n-level customers, and, if the two hierarchies are out of sync, it can identify the elements causing the problem.
5. Making Default Cube Views with MDX
Jay Apwah, a consultant in PSG, also wrote a post on MDX. His post covers how you can easily update a cube value to control the period elements that will display in a subset used in views. The concept he covers in this post can be applied in many different ways.
Want more tips & tricks on working with IBM Planning Analytics and TM1? Visit our Knowledge Center on a regular basis