Modeling utilizing staging entity joined with compensation formula table

A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

• providing an in-memory database comprising information of a plurality of users;
• populating a staging entity of a model with a subset of the information comprising a per-user base value and per-user attribute values, wherein the staging entity is stored within the in-meory database, wherein the staging entity has a MetaData Framework (MDF) format and is based upon metadata provided by a class of a parent template in the in-memory database, the parent template having a format different than the MDF format;
• based upon the attribute values, assigning each user in the staging entity a respective guideline from a guideline table, wherein the assigning comprises performing a join operation between the staging entity and the guideline table;
• applying the respective guideline to the per-user base value to generate a per-user allocation;
• aggregating the per-user allocation for multiple users with the same respective guideline to create a per-guideline allocation, wherein the aggregating is performed by an in-memory database engine of the in-memory database;
• aggregating the multiple users with the same respective guideline to create a per-guideline count;
• displaying the per-guideline allocation and the per-guideline count;
• in response to an input provided to the model, changing a value of the respective guideline of one of the users in the staging entity;
• applying the respective guideline with the changed value to the per-user base value to generate a batch updated per-user allocation;
• modifying the parent template to include the changed value;
• storing the staging entity with the batch updated per-user allocation;
• aggregating the per-user allocation for multiple users with the same respective guideline to create a per-guideline allocation;
• displaying the per-guideline allocation;
• and
• displaying in an interface screen, the changed value of the model juxtaposed with a different model, the interface screen including,
• a first string identifying a formal name of a table in the MDF format,
• a second string identifying a formal name of a matrix in the MDF format, and
• a third string identifying a ratio attribute, wherein at least one of the first string, the second string, and the third string are common between the model and the other model.

A computer system comprising:

• one or more processors;
• a software program, executable on said computer system, the software program configured to cause an in-memory database engine to:
• provide an in-memory database comprising information of a plurality of users;
• populate a staging entity of a model with a subset of the information comprising a per-user base value and per-user attribute values, wherein the staging entity has a MetaData Framework (MDF) format and is based upon metadata provided by a class of a parent template in the in-memory database, the parent template having a format different than the MDF format;
• store the staging entity in the in-memory database;
• based upon the attribute values, assign each user in the staging entity a respective guideline from a guideline table, wherein the assigning comprises performing a join operation between the staging entity and the guideline table;
• apply the respective guideline to the per-user base value to generate a per-user allocation;
• in response to an input provided to the model, change a value of the respective guideline of one of the users in the staging entity;
• apply the respective guideline with the changed value to the per-user base value to generate a batch updated per-user allocation;
• modify the parent template to include the changed value;
• store the staging entity with the batch updated per-user allocation;
• and
• display in an interface screen, the changed value of the model juxtaposed with a different model, the interface screen including,
• a first string identifying a formal name of a table in the MDF format,
• a second string identifying a formal name of a matrix in the MDF format, and
• a third string identifying a ratio attribute, wherein at least one of the first string, the second string, and the third string are common between the model and the other model.