Cascading Picklists in TM1 – How to Create in 4 Steps
Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.
How to Get an Element ID from an Alias in an TM1 Excel Report
Need to get a primary element name from an alias in a TM1 Excel report? Simple solution for deriving an element principal name in Excel.
General Ledger Analysis with TM1
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.