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

IBM Planning Analytics Tips & Tricks Series Did you know there may be several situations during development where you may want to clear all of the data from a specific cube? This could be due to a new process to reload data, a second round of user testing, or a migration from DEV to PROD.  There are a few approaches that can be used to clear data from a cube.  One approach is to create of a view which consists … Read More


IBM Planning Analytics Series Did you know one of the great things about Excel is that there are many built-in functions that calculate values associated with specific industries? One of these industries is the financial industry where Excel is sometimes used to calculate values associated with annuities. But did you know that some of these formulas are also built into Planning Analytics for use within rules? Here are three annuity formulas that can be used in Planning Analytics rules: The … Read More


IBM Planning Analytics Tips & Tricks Series Did you know one of the great things about creating TM1 Web sheets is that you simply need to create an Excel sheet and then press a button called Publish? This will convert your Planning Analytics formulas into a web-based interface that your users can easily access. In addition to the Planning Analytics formulas, IBM is continuing to expand the use of Excel’s native formulas.  Planning Analytics version 2.0.7 introduced the use of … Read More


IBM Planning Analytics Tips & Tricks Series Did you know that rules are used in TM1 to perform live calculations without the need for any manual intervention or on-demand scripts? This is a very powerful aspect of Planning Analytics and, when used properly, increase the value of the tool for your users. There are some aspects of rules that I often see people forgetting. Here are some friendly reminders about how to use these components properly: Division TM1 offers two … Read More


IBM Planning Analytics Tips & Tricks Series Did you know IBM Planning Analytics rules can be used to manipulate the case used for text?  There are rules to change values into both uppercase and lowercase. UPPER Converts an entire string to upper case UPPER(‘Lee Lazarow wrote this’) becomes LEE LAZAROW WROTE THIS LOWER Converts entire string to lower case LOWER(‘Lee Lazarow wrote this’) becomes lee lazarow wrote this CAPIT Converts the first letter of each work to upper case CAPIT(‘Lee … Read More


IBM Planning Analytics Tips & Tricks Series Did you know there are two different ways to stop a TurboIntegrator script? The ProcessBreak command stops processing source data and proceeds directly to the Epilog.  This approach allows you still run code in the Epilog that can perform tasks such as deleting subsets, writing to a process tracking cube, or running other processes. Here is an example of skipping the data and metadata section if a parameter called pVersion does not exist: … Read More


VIEW MORE ARTICLES >


12Next ›Last »