Do you have Excel based TM1 reports with hard coded Excel SUM formulae? Or manually entered line descriptions on your P&L or Balance Sheet, or a General Ledger cube with negatives for credits and positives for debits, when your users want to see all positive values? Here’s a quick case study for what we achieved for a new client last week that delivers all this and enables the GL cube to be easily used in Planning Analytics Workspace.
How to Create Virtual Dimensions in TM1/Planning Analytics
Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.
Virtual Dimensions in TM1 and Planning Analytics Explained
Virtual Dimensions and Hierarchies in TM1 and Planning Analytics explained. You can add virtual dimensions, or hierarchies, to any physical dimension in TM1 to expand the analytics available from a TM1 cube. Here we explain what they are.
Create a TM1 Send Sheet in Excel
Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.
Weights in TM1 – What They Are and How to Use Them
Weights in TM1 can be confusing. Here we explain what they are and how to use them with some simple examples that will have your dimensions designed perfectly!
Connecting Planning Analytics for Excel (PAX) to TM1
Here we detail how to create a new connection in Planning Analytics for Excel (PAX) to a TM1 model or server with screenshots to guide you along the way.
Persistent Feeders in TM1 – Explanation and Implementation
Persistent Feeders can dramatically decrease the time required to restart a TM1 model. Here is an explanation of what Persistent Feeders are and instructions on how to implement them in your TM1 model.
Days in Month – How to Easily Calculate in a TM1 Rule
Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.
Choose Your Favourite ExploringTM1 T-Shirt
We are about to crack 100,000 visitors and half a million page views on ExploringTM1.com and to celebrate we are going to print a new, free t-shirt for the ExploringTM1.com community. Here are the final 8 tshirts and a link that will take you to the survey of possible designs.
DimensionElementDelete Function TM1: Syntax and Use
Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the dimension and all associated data from any cube the dimension is used in – so please be careful!