Dynamic application builder for multidimensional database environments

A system comprising:

• data processing hardware;
• and
• memory hardware in communication with the data processing hardware, the memory hardware storing instructions that when executed on the data processing hardware cause the data processing hardware to perform operations comprising:
• receiving a request to build a custom application for querying a multidimensional database;
• obtaining master data associated with the multidimensional database, the master data indicating a hierarchical structure of the multidimensional database;
• determining an application definition based on the obtained master data, the application definition indicating target outputs of the custom application;
• grouping the target outputs into a plurality of groups;
• for each respective group of the plurality of groups, generating machine written code comprising a distinct code block for the respective group by:
• generating a first portion of the distinct code block configured to retrieve a corresponding section of the multidimensional database for the respective group and limit data retrieval to only the corresponding section of the multidimensional database;
• and
• generating a second portion of the distinct code block configured to generate the target outputs of the respective group based on the corresponding section of the multidimensional database;
• and
• generating the custom application based on the distinct code blocks generated for each respective group of the plurality of groups.