GenE – Its components
Although good cost modeling can be a challenge, accessing and updating data is also a challenge. We tend to underestimate the automation work to be done for an effective data update. In many cases, it ends up being obsolete after a few years, if not even after a single year. In order to help with the problem of data organization, GenE offers the possibility of automating and transforming data upstream in order to obtain an up-to-date, simple and efficient dataset.
In the next sections, you will find the essential application functionalities of GenE, allowing you to prepare and transform your data in connection with the modeling of your cost model.
Segments
Segments are the DNA of each item you want to analyze. Most organizations already call on segments to define their accounts , products, customers and others. In the case where there is little or no segmentation, GenE will allow you to add the necessary segments to your lists. It is essential to structure your data for the purposes of multidimensional analysis and automation to update your costing model.
![](https://cpatech.ca/wp-content/uploads/2023/12/Segments.png)
Dimensions
This is where all the business logic of your costing model will be defined. Each dimension represents an axis of data to analyze, such as resources, departments, activities, products, customers and others.
![](https://cpatech.ca/wp-content/uploads/2023/12/Dimensions-1024x725.png)
Measures
In order for a Dimension to take on its full meaning, they will have measures that are specific to it. A measure can be data serving as a basis for allocation or the value to be processed. Example, in a trial balance, you will define the base measure: Amount (account value to allocate). Another measure could be the number of employees (FTE). This measure could serve both as a statistic for wages and could also serve as a base for allocating any costs.
![](https://cpatech.ca/wp-content/uploads/2023/12/Mesures-1.png)
Transformations
Transformation rules are used to organize data and then allocate them. In fact, you could simplify your trial balance and then allocate the costs of this BV according to very specific rules and so on from one dimension to another and even within the same dimension.
![](https://cpatech.ca/wp-content/uploads/2023/12/Transformation.png)
Calculations
Are you missing data? Thanks to the calculation module integrated into GenE, you can create new data (measures) to add value to your model and thus refine your results.
![](https://cpatech.ca/wp-content/uploads/2023/12/Calculs.png)
Scenarios
Do you want to create a scenario without having to duplicate your entire dataset? You just have to click on ‘New Snapshot’ and the application takes care of the rest. All your data will be retained as long as you do not delete the Snapshot in question.
![](https://cpatech.ca/wp-content/uploads/2023/12/Scenario.png)
Results analysis
Now you just need to analyze your results. Thanks to the analysis grids integrated into the application, you can quickly view your results. In addition, GenE offers an API that allows its data center to be opened to BI and Excel type applications.
![](https://cpatech.ca/wp-content/uploads/2024/01/825937a727d69e3f9e6d55651b085866-1024x244.png)
Power BI
In addition to the API allowing you to connect to GenE’s data, to get off to a good start, Power BI users will have at their disposal a semantic layer already connected to the GenE’s API.
![](https://cpatech.ca/wp-content/uploads/2023/12/Modif-API-2-1024x622.png)
Audit
The application is able to trace all activities done to the data in GenE; create, update, delete and even imports. This way, you will be able to identify at all times what changes or actions have been made to the data. In addition, thanks to its Snapshot (scenario) functionality, which allows one or more data sets to be isolated, the user will be able to identify what changes have been made between two scenarios and thus better understand the reasons for the differences between them.
![](https://cpatech.ca/wp-content/uploads/2023/12/faec274fbe854fc9a2dcbdfd15a60461-1024x346.png)
Decentralized data entry
You want to involve your managers in entering or validating the cost model? Using the segmentation structure demonstrated above, you can define roles and give access to your data. GenE therefore makes it possible to decentralize your costing models and thus enable broader collaboration with the organization.