Lee Lazarow, Author at Revelwood Knowledge Center – Page 3 of 4
Lee Lazarow, Author at Revelwood Knowledge Center – Page 3 of 4

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

Did you know that comments are an important piece of good rule development in IBM Planning Analytics? Comments help to describe your logic and can make it easier to navigate through many lines of code. A special type of comment in Planning Analytics entails the definition of a region. The use of regions allows you to expand and collapse sections of rules in the Planning Analytics rule editor. A region is defined by adding a comment that starts with #Region … Read More

Did you know that TM1 offers an easy way for you to convert GMT times to local times?  Do you get tired of seeing your message log records in GMT?  Are you frustrated that you have to convert times from GMT to local time?  Does the concept of daylight savings time annoy you?  Well, there’s not much that TM1 can do about that last question, but it does offer a solution to the first two. TM1 contains many of your … Read More

Did you know TM1 allows users to create alias names for elements within your model? This is a great approach that allows you to give different names to the same element. For example, account 601 can also be displayed in reports as “601 – Comp Expense”. Many clients have asked me for an easy way to do something similar with dimension and cube names since many of these are often created with some form of prefix (example: a glbProduct dimension … Read More

Did you know you can easily control your logs, making them easier to navigate? Your TM1 server tracks data transactions made in the system. When a cube value is changed, TM1 records the change in a transaction log file named Tm1s.log. The values in the log can be used as an audit trail and can also be used as part of a data restoration approach in the event of a server crash. While logging is a great auditing tool and … Read More


« First‹ Previous234Next ›

Never miss another post.

Sign Up for Our Newsletter.