A while back I wrote a blog about the SCAN function which showed how you can search for specific characters and then combine this with the SUBST formula to create new sets of text. … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel DELET Function
IBM Planning Analytics Tips & Tricks: Garbage Memory
I recently had a customer ask me why Windows was showing a much larger memory footprint than what was expected (based on their cube sizes). After further analyzing their model, we … [Read more...] about IBM Planning Analytics Tips & Tricks: Garbage Memory
IBM Planning Analytics Tips & Tricks: 21/21/21
Some of you may remember an Excel feature that we wrote about a while back, which explained how the DATE function will convert invalid dates into real ones. For example, … [Read more...] about IBM Planning Analytics Tips & Tricks: 21/21/21
IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar
Do you regularly work with others that are in a different time zone? If so, how often have you heard your counterpart tell you to “just determine my time by adding X hours to … [Read more...] about IBM Planning Analytics Tips & Tricks: Working with Two Time Zones in Google Calendar
FP&A Done Right: The Role of Narrative Reporting in ESG
ESG (environmental, social, governance) reporting is the talk of the Office of Finance. Does our company need to start thinking about ESG? When do we need to start reporting on our … [Read more...] about FP&A Done Right: The Role of Narrative Reporting in ESG
IBM Planning Analytics Tips & Tricks: PAW Chart Show Totals
One of IBM Planning Analytics’ purposes is to serve as an aggregation tool. As a result, many of your explorations consist of a series of base level elements plus a total. Here is … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Chart Show Totals
IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process
Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly … [Read more...] about IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process
IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER
A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER
IBM Planning Analytics Tips & Tricks: MDX Syntax Explained
MDX enables you to query dimensions and cubes, lists of elements, data points, calculations, and more. The first step in learning MDX is to understand the syntax. Below is … [Read more...] about IBM Planning Analytics Tips & Tricks: MDX Syntax Explained