Revenue and Gross Profit analysis is at the heart of what many companies use TM1 for. In this short Workshop Series we will build upon the Nebula Fit GL model we built last year, adding in a Gross Profit cube and relevant dimensions for Customers, Products and Measures, we will check security and build out some reports and more of the CEO’s PAW based dashboard.
This will then set us up to start a rolling Forecast model, which will be the second Workshop Series for 2022, where we will build upon the GL and GP cubes with sales and margin forecasting and, PnL planning. We then will supplement this model with Labour, Capital Expenditure, Balance Sheet and Cashflow. It will end up quite a model!
Workshop 6 - Planning Analytics for Excel
The final workshop in our Revenue and Gross Profit series is to design some reports using Planning Analytics for Excel. We will create a Dynamic Report that links to the System Control cube to set the Reporting Month. Join us as we explore making a Dynamic Report from scratch and end up with a fully automated expandable report.
Need a TM1 Server to Work On? Use Ours!
Remember that if you don’t have a TM1 server to work on to complete the workshops, please let us know and we’ll set you up with a spot on our server.
Become an Explorer to Attend
*Or sign in if you are already a member*
Workshop History
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.
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.
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.
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.
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.
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.
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.
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.
GL Workshop 9: Reporting
The Reporting workshop shows how we define what we need to build and then how it gets done, incorporating all the tricks we deploy with clients. We have also included in detail, all the steps we go though in the lesson so you can use this as a template to build your own reports.
GL Workshop 10: Dashboard
Nebula Fit's CEO needs a profitability dashboard. Here we build it out using Planning Analytics Workspace with 4 visualisations and go through how to make it all come together easily.
Revenue and GP 1 – Introduction & Design Meeting
Hello and welcome to the first workshop of our new series on Revenue and Gross Profit analysis. This will be…
Revenue and GP 2 – Dimensions
Workshop 2 took us down the route of creating dimensions for our Revenue and Gross Profit analysis. One of the…
Revenue and GP 3 – Cube, Load TI’s and Variance Rules
Workshop 3 allowed us to take the dimensions we had created in workshop 2 and create our new Gross Profit…
Revenue and GP 4 – FX Translation and Security
Workshop 4 took the cube we created in Workshop 3, the actual and budget data we loaded and the variance…
Revenue and GP 5 – Planning Analytics Workspace
Finally, we have completed the model and have moved to use the information in it to prepare some dashboards and…