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 … [Read more...] about IBM Planning Analytics Tips & Tricks: How to Manipulate Case Used for Text
IBM Planning Analytics Tips & Tricks: Rule Concepts that are often Forgotten
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Rule Concepts that are often Forgotten
IBM Planning Analytics Tips & Tricks: Financial Rules
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Financial Rules
IBM Planning Analytics Tips & Tricks: Errors in Non-writeable Cells
Did you know IBM Planning Analytics is smart enough to look at the write permissions of a cell before attempting to load values into a cube? Have you ever tried to run a load … [Read more...] about IBM Planning Analytics Tips & Tricks: Errors in Non-writeable Cells
IBM Planning Analytics Tips & Tricks: Cellput vs CellIncrement
Did you know one of the most popular uses of TurboIntegrator is to load data into a cube? There are many different commands that can be used to load data depending on whether the … [Read more...] about IBM Planning Analytics Tips & Tricks: Cellput vs CellIncrement
IBM Planning Analytics Tips & Tricks: Blank Rows in Active Form Reports
Did you know when creating active form reports, you may sometimes want to separate sections? Some people like to create this separation via dashes or via bold line formatting. Some … [Read more...] about IBM Planning Analytics Tips & Tricks: Blank Rows in Active Form Reports
IBM Planning Analytics Tips & Tricks: Cell Level Security Defaults
Did you know that you can have TM1 / Planning Analytics security always use your cell security definitions … even when the security definition cell is blank? Values in a cell … [Read more...] about IBM Planning Analytics Tips & Tricks: Cell Level Security Defaults
IBM Planning Analytics Tips & Tricks: The New Set Editor
IBM Planning Analytics contains a new set editor that makes it easy to manipulate the elements in a subset. This approach allows you to quickly add a single element, add a group of … [Read more...] about IBM Planning Analytics Tips & Tricks: The New Set Editor
IBM Planning Analytics Tips & Tricks: New Excel Feature – XLOOKUP
Did you know Excel has a new feature called XLOOKUP? For those of you who read these blogs regularly, you know that much of the focus is placed on IBM Planning Analytics Tips … [Read more...] about IBM Planning Analytics Tips & Tricks: New Excel Feature – XLOOKUP