This workshop is FREE for ALL members of TM1 Explorers! 

The idea for this workshop series is that we replicate what we would normally do when we are engaged by a client. So we will go through all the steps we would need to do to deliver a fully functional model. It will not be perfect – cos it never is in reality. 

In the series we will build a complete General Ledger analysis model as if we were doing it for a real client. We will face challenges, things won’t work as expected and together we’ll overcome those.

Workshop 9 takes us into the world of reporting. Using Excel, we’ll create a P&L, a Balance Sheet, a detailed Expense report for Variance Analysis by Branch Managers and a reconciliation report for the finance team. The reporting methods we’ll use to do this are Explorations, Quick, Dynamic and Custom Reports. 

Importantly, we’ll include the tricks we use with reports for our clients that make the reports easy to deploy and use month after month as the accountants roll over.

Join next Tuesday as we continue the live GL workshops. Then every week, tune in and build your model side by side with us all the way through to reports and analysis, security and making the model dynamic so it updates as you get new data.

If you are looking for the recording and model as it was last week, then after you have registered for this week, please head over to this page and collect the up to date model and watch the lesson.

Become an Explorer to Attend

*Or sign in if you are already a member*

Workshop Recordings

1 Lesson

GL Workshop 8: Security

TM1 Security can be easy or can get very complex. Here we assess Nebula Fit's requirements, determine how to do that in TM1 and then go and build it.

8 Lessons

GL Workshop 7: FX Conversion & Foreign Currency Translation Reserve Calculation

Workshop 7 takes us deep into the calculation of foreign exchange. We build up how to do FX translation initially in Excel prior to switching over to TM1 and then going through multiple stages of rules to end up with a fully functioning set of rules that satisfy accounting standards.

8 Lessons

GL Workshop 6: Relative Time and YTD Rollups

Relative Time allows us to build reports and embed a place holder for time that updates each month automatically. Year to Date rollups allow us to present YTD values side by side with monthly values in reports. In this workshop we build out both, ready for us to start reporting.

8 Lessons

GL Workshop 5: Create Cubes, Load Data, Reconcile, Create Picklists

This workshop takes us down the cube creation path and then we walk through how we caret a process that loads the general ledger data. Along the way we encounter problems, like we do in the real world, and work out how to overcome these issues. We finish off with the addition of new dimensions and cube for FX translation before we add picklists to our branch and account dimensions to ensure valid selections by the finance team.

8 Lessons

GL Workshop 4: Dynamic Dimensions

Workshop 4 continues building inside our Nebula Fit model where we discuss the best method to manage dimensions that need to be refreshed each time we load data. We then create three TI's to build the the Account and Branch dimensions and the structure for them that is not available from the source system.

8 Lessons

GL Workshop 3: Version, Time and Measures Dimensions

Workshop 3 takes us into modelling with TM1 as we build out four static dimensions. We also discuss continuous time vs having Year and Month dimensions. We then create a TI to build the Time dimension and then create hierarchies (virtual dimensions) for the Time dimension.

8 Lessons

GL Workshop 2: Create TM1 Models and Add Standard TM1 Explorers Objects

Lesson two in the GL Workshop series takes us onto the tools as create two new TM1 models and then add into both of those models a set of standard TM1 Explorers objects that will backup the models and clean out old backups and log files. We also deploy a System Control cube that we will use to manage the model.

8 Lessons

GL Workshop 1: Introduction and Design Meeting

This workshop introduces the GL Reporting and Analysis workshop series and takes us through a Design Meeting between the consultant and client. This helps you identify the requirements fo the client before we start to build out the model.