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.
DBRW TM1 Excel Syntax and Use
Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display the contents of a specific intersection of a TM1 cube.
DBRA TM1 Excel Syntax and Use
Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display the contents of an Attribute in the Excel sheet.