DimensionElementComponentAddDirect TM1 Function: How to Use, Examples and Syntax
DimensionElementComponentAddDirect Function for use in TI Processes in TM1 and Planning Analytics to IMMEDIATELY consolidate (or rollup) elements in a dimension. Explanation with an example of use.
ELWEIGHT TM1 Function: How to Use, Syntax & Example
Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule or turbo integrator process? Well, ELWEIGHT allows you to do just that! Syntax of ELWEIGHT The syntax of ELWEIGHT is: where: Dimension is the name of the dimension you are checking. Parent is the name of the […]
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.
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!
DimensionElementComponentAdd TM1 Function: How to Use, Examples and Syntax
DimensionElementComponentAdd Function for use in TI Processes in TM1 and Planning Analytics to consolidate (or rollup) elements in a dimension. Explanation with an example of use.