Posts Tagged ‘Development’
How Do I Edit Business Rules in IBM Planning Analytics Workspace (PAW)?
How Do I Create a Business Rule in IBM Planning Analytics to Perform Custom Calculations?
IBM Planning Analytics’ Calculation Types IBM Planning Analytics is well known for the speed with which it performs on-the-fly, on-demand aggregations, consolidations and other calculations. The calculation of a specific number in a Planning Analytics cube is not performed until it is requested, for example by a DBR() formula in a spreadsheet, and when it…
Read MoreHow Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports?
How to create MDX expressions According to the dimension and your business need, dimensions may be large. You may want to limit the data shown in the report or input schedule. You can create customized categories or subsets of dimensions for your report or input schedule. Customized subsets are utilized to speed the selection of…
Read MoreCreating List Subsets in Anaplan
Creating a subset of list items in Anaplan is an easy way to create a smaller list of items out of a larger list. A subset can be maintained manually or imported along with other list properties. This subset list can then be used as a dimension when creating a module just like any other…
Read MoreAnaplan API Integration – Large Volume Read
Not long ago Anaplan updated their transactional API (Application Programming Interface), allowing users to read “large volume view and list” data. To qualify as “large volume” the data set should consist of at least one-million cells or list members respectively. For those familiar with Anaplan and its methods of integration, these API endpoints allow for…
Read MoreAnaplan Top 10 Functions
When building modules in Anaplan, calculations form the backbone of your models so knowing the most common functions and how to use them is very important. Below are ten of the most common functions model builders will utilize, along with their purpose and syntax. Before reading this document, it is recommended you understand the basics…
Read MoreExport from a Saved View using Anaplan Connect and Batch Script
Anaplan Connect is an API (application programming interface) client that functions using a command-line interface. Through this interface, and the writing of batch and or shell scripts, an Anaplan administrator may automate the running of various actions from Anaplan. Typically, when using Anaplan’s API or Anaplan Connect, users leverage a predefined import, export, or some…
Read MoreWhen to Use SUM or LOOKUP?
Anaplan provides numerous calculation functions which deliver enhanced analysis within a model. Two common and related functions are SUM and LOOKUP. SUM enables the summation of values based on a list or time formatted line item or property in a source with a matching dimension in a target. SUM achieves this through user-entered mappings within…
Read MoreNaming a Numbered List in Anaplan
Lists are a great way in Anaplan to organize information and are used to group similar types of metadata that can be referenced within a model. Lists are organized into three columns: name, parent and code. Numbered lists provide unique identifiers that can be helpful when your list items contain duplicate names. Naming a numbered list helps improve consistency throughout…
Read More