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 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


Did you know that there are three different ways to define the false section of an IF statement?  The approach you choose will impact how the cell calculates a result.  In this blog post, we discuss these options and when to use each one. TM1 uses a standard approach to the concept of an IF statement:              IF (Argument, True Result, False Result) This approach is great when you have specific values for both the … Read More


Did you know you can easily visualize data with IBM Planning Analytics Workspace?  IBM Planning Analytics Workspace (PAW) allows you to visualize your data using a variety of charts and graphs, including the ability to display your results via a map.  The only requirement for mapping is to ensure that your geography dimension includes recognizable place names.  IBM defines “recognizable” to include items such as countries, states and provinces and offers a list of acceptable items on their website. You … Read More


Did you know IBM Planning Analytics Workspace (PAW) allows you to visualize your data using a variety of charts and graphs, including the ability to display your results via a pie chart?  In order to create a pie chart, you must follow one simple rule: ensure that you have only one “measure” element on either the row or the column. You can create a pie chart in PAW with three easy steps: 1. Ensure that a dimension is defined as … Read More


VIEW MORE ARTICLES >


« First‹ Previous234Next ›

Never miss another post.

Sign Up for Our Newsletter.