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

IBM Planning Analytics Tips & Tricks Series Did you know IBM Planning Analytics’ snap commands can serve as a spellcheck for you? In today’s Twitter and text based world, misspellings (or abbreviations, as some people call them) have become a way of life. It’s virtually impossible to make it through a day without seeing a reference to “ur”, “imho” or some other form of abbreviation. For those of you who use these abbreviations regularly, you will be happy to know … Read More


IBM Planning Analytics Tips & Tricks Series Did you know IBM Planning Analytics has snap commands that allow you to use natural language wording to perform simple tasks?  One example of this entails the use of sorting data within a view. We can start with a simple view that shows operating expenses by quarter. We can sort this by simply typing “sort Q1 2016” into the snap command window. By default, the sort command sorts the values in ascending order. … Read More


IBM Planning Analytics Tips & Tricks Series Many of you know that Planning Analytics Workspace books allow you utilize templates, but did you know there is a difference between the options that show a solid frame vs. the options that show a dotted frame? Creating a new PAW book is as easy as clicking the “New” button and then selecting how you want to define the book. One way to do this is to utilize a pre-built template which defines … Read More


IBM Planning Analytics Tips & Tricks Series Did you know IBM Planning Analytics offers more than one way to add calculations to your data? The great thing about using Planning Analytics within Excel is that you can add additional calculations to your data set to help you further analyze your data. Did you know that you can also do this within PAW explorations? Use the following steps to create a new calculation: Select one or more elements within your exploration. … Read More


IBM Planning Analytics Tips & Tricks Series Did you know IBM Planning Analytics Workspace allows you to add comments to your data set? During both planning and reporting cycles, many clients often ask how they can add comments into their data set. After all, the goal of a Planning Analytics database is to have a single source of data … both numeric and text. Planning Analytics Workspace allows you to insert comments into your explorations quickly and easily. Step 1: … Read More


IBM Planning Analytics Tips & Tricks Series Did you know that you can trace the details of a calculation in an IBM Planning Analytics Workspace exploration? The following screen shot shows a simple revenue calculation that uses input values for Units and Unit Price. You can right click on the revenue value and select the option of “trace cell” to see the details of the calculation. The trace will show me the calculated result, the formula, and the values for … Read More


VIEW MORE ARTICLES >


12Next ›Last »

Never miss another post.

Sign Up for Our Newsletter.