Lee Lazarow, Author at Revelwood Knowledge Center
Lee Lazarow, Author at Revelwood Knowledge Center

Did you know that you don’t have to show all of your dimensions during an ad-hoc query in IBM Planning Analytics Workspace (PAW)? TM1 cube views and formulas require a reference to every dimension within the cube. While all of these dimensions have a use within your cube, they are not always needed for your reports, templates and ad-hoc querying. PAW books allow you to hide dimensions during ad-hoc browses. This is done by simply dragging the dimension off the … Read More


Did you know that you can bookmark items for quick navigation in IBM Planning Analytics Workspace (PAW)? PAW’s navigation menu allows you to scroll through your entire system which includes cubes, dimensions, views and other aspects of your model. This ability to access your models within a single list is very powerful, but it can also become very large. PAW offers an easy way to quickly navigate to important components of your model that via the use of bookmarks. To … Read More


When working with clients to design a TM1 system, I sometimes have clients ask about an approach of building one cube for a model vs. building multiple cubes for a model. What do I mean by that? A cube consists of a single table/database of data whereas a model consists of a series of cubes that are linked together. TM1 is designed to quickly and efficiently link a series of small cubes together, but this style of thinking contradicts the … Read More


Did you know there are some simple steps you can take to clean up your TM1 environment?  A quick clean up gives you easier navigations for ad-hoc analysis, as well as smaller dimensions. In today’s world, memory is cheap.  Hard drives that used to be measured in KB quickly became MB, GB and TB.  RAM chips have become larger and computers have become virtualized.  This means that it’s easier to quickly expand the environment where your TM1 model is stored. … Read More


Did you know you can create a single hierarchy that contains all year-to-date values within an entire year? As you know, TM1 is a consolidation tool which is designed to sum together a series of values.  There are many ways to create the consolidations using a combination of grand totals and sub totals.  This blog specifically addresses the year-to-date (YTD) hierarchy associated with a time dimension. Many clients prefer to create a single hierarchy that contains all YTD values within … Read More


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 … Read More


VIEW MORE ARTICLES >


123

Never miss another post.

Sign Up for Our Newsletter.