Lee Lazarow, Author at Revelwood Knowledge Center – Page 5 of 5
Lee Lazarow, Author at Revelwood Knowledge Center – Page 5 of 5

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


Did you know that you can create a URL that will open directly into a specific websheet? The concept is to simply use your existing TM1 Web address and then enter some parameters. The parameters are where the fun begins since you can include parameters for actions to take, adminhost and server names, and websheet names. You can also include your username and password within the URL to automatically connect into your Planning Analytics environment.   The base URL and the parameters … Read More


Many of you know that MDX can be used in your current IBM Cognos TM1 environment to create dynamic subsets and row expansions, but did you know that MDX can also be used to create an entire view of data? TM1’s initial use of MDX functionality was limited to manipulating one dimension at a time, but IBM Planning Analytics uses the full power of MDX via expressions called tuples and sets.  These expressions define intersections of data which result in … Read More


VIEW MORE ARTICLES >


« First‹ Previous45

Never miss another post.

Sign Up for Our Newsletter.