Did you know there are a number of workarounds for unsupported Excel functions in TM1 Web? Have you ever published a TM1 Web report, only to see repeating #NAME errors when you … [Read more...] about IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web
IBM Planning Analytics Tips & Tricks: Performance Monitoring, Part 2
Did you know there are easy ways to address resource issues in order to have a finely tuned IBM Planning Analytics environment? This is the second in a two-part series about … [Read more...] about IBM Planning Analytics Tips & Tricks: Performance Monitoring, Part 2
IBM Planning Analytics Tips & Tricks: DefineCalc
IBM Planning Analytics for Excel (PAx) version 80 introduced a new function called “DefineCalc." This function allows a user to create a custom calculation using TM1/Planning … [Read more...] about IBM Planning Analytics Tips & Tricks: DefineCalc
IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1
Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? Here are some tips and tricks for working with charts in PAW. Scatter … [Read more...] about IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 1
IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 2
Did you know IBM Planning Analytics Workspace (PAW) gives you many options for showing data in charts? We recently shared a few tips and tricks for visualizing your data in charts. … [Read more...] about IBM Planning Analytics Tips & Tricks: Charts in Planning Analytics Workspace, Part 2
IBM Planning Analytics Tips & Tricks: Excel EOMONTH
Thirty days has September … Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel EOMONTH
IBM Planning Analytics Tips & Tricks: UNIQUE Function in Excel
Have you ever needed to produce a list of unique values within a cell range in Excel? If so, the UNIQUE function can do this. The example below shows a simple list of … [Read more...] about IBM Planning Analytics Tips & Tricks: UNIQUE Function in Excel
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks, we’ll be highlighting some of the most … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3
IBM Planning Analytics Tips & Tricks: PAW Users and Groups
Do you know how to manage your users and groups in IBM Planning Analytics Workspace (PAW)? As of version 84, PAW now allows you to edit this information via a single click. To … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Users and Groups