Arbitrary dimensional resource accounting on N-ary tree of assets in databases
In some embodiments, a method receives a label for a record in a database. A first operation is performed using a first value associated with the record to generate a first reporting object for a sustainability metric that is based on a resource. A second value for the first reporting object is generated based on performing the first operation using respective first values associated with first records based on a relationship in a data model to a first reporting object. The method uses the label to perform a second operation using the first value associated with the record to generate a third value for a second reporting object for the sustainability metric. The second reporting object is generated based on performing the second operation using respective first values associated with second records that are associated with the label.
1. A method comprising:
performing a first operation using respective first values associated with a set of first records to generate a second value for a first reporting object, wherein the set of first records are determined from a relationship in a data model to the first reporting object for a sustainability metric that is based on a resource, and wherein the set of first records include a record;
retrieving a set of second records that are tagged with a label, wherein the set of second records includes the record and includes a different record than first records found in the set of first records; and
performing a second operation, using respective first values associated with the set of second records that are associated with the label, to generate a third value for a second reporting object for the sustainability metric.
2. The method of claim 1 , wherein the first operation is a rollup of first values for the set of first records based on the relationship in the data model to the first reporting object.
3. The method of claim 1 , wherein the second operation is a rollup of first values for the set of second records that are associated with the label.
4. The method of claim 1 , wherein the first operation is an aggregation of first values for the set of first records based on the relationship in the data model to the first reporting object.
5. The method of claim 1 , wherein the second operation is an aggregation of first values for the set of second records that are associated with the label.
6. The method of claim 1 , wherein the third value for the second reporting object is not used to generate the second value for the first reporting object.
7. The method of claim 1 , further comprising:
storing the label with an identifier for the record, wherein the identifier is used to retrieve the first value for the record to generate the third value for the second reporting object.
8. The method of claim 1 , wherein:
the record is associated with a consumption of an asset, and
the consumption is converted into the first value for the sustainability metric.
9. The method of claim 1 , wherein the second value for the first reporting object is generated by:
determining a plurality of records for an account; and
aggregating first values for that are associated with the plurality of records into a fourth value for the account.
10. The method of claim 9 , wherein the second value for the first reporting object is generated by:
determining respective fourth values for a plurality of accounts in the data model; and
aggregating the fourth values for the plurality of accounts based on relationships between the accounts and the first reporting object in the data model.
11. The method of claim 1 , wherein the second reporting object is generated by:
determining respective first values for the set of second records; and
aggregating the respective first values for the set of second records to generate the third value.
12. The method of claim 1 , further comprising:
determining whether a characteristic for the record meets a requirement for the label; and
associating the label with the record when the characteristic meets the requirement.
13. The method of claim 1 , wherein:
a record in the set of first records is not found in the set of second records.
14. A non-transitory computer-readable storage medium having stored thereon computer executable instructions, which when executed by a computing device, cause the computing device to be configurable to cause:
performing a first operation using respective first values associated with a set of first records to generate a second value for a first reporting object, wherein the set of first records are determined from a relationship in a data model to the first reporting object for a sustainability metric that is based on a resource, and wherein the set of first records include a record;
retrieving a set of second records that are tagged with a label, wherein the set of second records includes the record and includes a different record than first records found in the set of first records; and
performing a second operation, using respective first values associated with the set of second records that are associated with the label, to generate a third value for a second reporting object for the sustainability metric.
15. The non-transitory computer-readable storage medium of claim 14 , wherein the first operation is a rollup of first values for the set of first records based on the relationship in the data model to the first reporting object.
16. The non-transitory computer-readable storage medium of claim 14 , wherein the second operation is a rollup of first values for the set of second records that are associated with the label.
17. The non-transitory computer-readable storage medium of claim 14 , wherein the first operation is an aggregation of first values for the set of first records based on the relationship in the data model to the first reporting object.
18. The non-transitory computer-readable storage medium of claim 14 , wherein the second operation is an aggregation of first values for the set of second records that are associated with the label.
19. The non-transitory computer-readable storage medium of claim 14 , wherein the third value for the second reporting object is not used to generate the second value for the first reporting object.
20. An apparatus comprising:
one or more computer processors; and
a computer-readable storage medium comprising instructions for controlling the one or more computer processors to be configurable to cause:
performing a first operation using respective first values associated with a set of first records to generate a second value for a first reporting object, wherein the set of first records are determined from a relationship in a data model to the first reporting object for a sustainability metric that is based on a resource, and wherein the set of first records include a record;
retrieving a set of second records that are tagged with a label, wherein the set of second records includes the record and includes a different record than first records found in the set of first records; and
performing a second operation, using respective first values associated with the set of second records that are associated with the label, to generate a third value for a second reporting object for the sustainability metric.