The Multi-Dimensional Financial Model (MDFM) is a feature that can aggregate and process data that has been uploaded to Gravity. It uses a series of rules and formulas to map data to the correct line items within financial statements. Adjustments to the data can also be made within the MDFM.
The MDFM contains these main sections:
-
Administration
- This section is controlled by an Application Level User Permission, so regular users can be restricted from accessing this section as needed
- Admin users should only need to work with two subsections:
- Dimensions - this section is for adding new line items that will be displayed in statements
-
Ex. if you want to add a new line item to the Statement of Net Position’s Assets section, create the new dimension/line item in this Dimension section and assign it a code that follows the same naming/numbering convention as the line items in the same folder
2. To add line item to “Governmental Funds”, click on the + sign to the right of Governmental Funds. Clicking on the plus sign to the right of any item will create a line item within the item you have selected.
3. Once you have selected the correct item, enter the Name and Code of your new line item. Then click the 'Save' icon to the right.
-
- Data Sets - this is for Budget Book data
-
Data sets can be refreshed by opening the relevant subfolder within the Data Sets section, and clicking the Refresh button next to the name of each data set
-
- Dimensions - this section is for adding new line items that will be displayed in statements
-
Hypercubes
- Each hypercube maps/processes different data - the Governmental Funds hypercube maps GF data, the Proprietary Fund hypercube maps proprietary data etc.
- Budget Book data will be contained in its own hypercube
- Each hypercube has a Mapping section, where you can work with local rules and formulas to ensure data is mapped to the correct line item
- The Adjustment section is for making adjustments to line items
-
The Pivot section contains pivot tables built from data in the Mapping section. The pivots are eventually imported into spreadsheets in your main report, to be displayed in your statements
- Each hypercube maps/processes different data - the Governmental Funds hypercube maps GF data, the Proprietary Fund hypercube maps proprietary data etc.
-
Data Sets
- Contains data aggregated from both data file uploads, and resource tables. Mainly used for Budget Book reports
- Data can be reviewed in the View section
- The pivot section contains pivot tables that are imported into spreadsheets to be displayed in budget book statements
MDFM Configuration:
To configure a Multi-Dimensional Financial Model (MDFM), first open the MDFM, and then define or modify its configuration.
Open MDFM:
- Log into the application
- Select one of the financial close management solutions reports
- Open/Create a report
- From the application menu select “Data” → “Multi-Dimensional Financial model”
- The “Multi-Dimensional Financial Model” opened
MDFM Configuration:
- Select and expand “Administration”:
- Dimension - the ability to apply different segments from the GL accounts and charts of accounts
- Click on the ”+” icon to add dimensions, in the dialog box add the following:
- “Name” - Set dimension name (Period, Fund, Account Structure, department….)
- “Group” - Add a dimension group name
- “Type” - can be “Standard” or “Period” (example of dimensions: Period, Fund, Account)
- “Select File”/”Drop File” - Add CSV file with parent/child dimension structure
- Click “OK” to save
- Click on the ”+” icon to add dimensions, in the dialog box add the following:
- Data Sets - the ability to add data sources
- Click on the “+” icon to add a data set and select the following options:
- Standard - Create Data Set from MDFM
- From Query - Use Data Store Query
- Standard - Add the following:
- “Name” - Data set name
- “Caption” - Rename the data set
- “Group” - Add data set group name
- “Workflow” - Set workflow to data set
- Attributes - Define a data set columns structure, and click on the “+” icon to add an attribute. Each attribute needs to be saved (click on the save icon), and each attribute can be edited or deleted (click on the edit/delete icons), for example:
- Name - Fund; Type - String; Click on the save icon
- Name - Department; Type - String; click on the save icon
- Attribute can be added directly from data set
- Key - will define from the set of the created attributes including “Period”, for example, Fund, Department, Period
- Metrics - represent the value column from the data set, add as needed.
- Click “OK” to save
- From Query - Add the following:
- “Name” - Data set name
- “Caption” - Rename the data set
- “Group” - Add data set group name
- “Workflow” - Set workflow to data set
- “Query” - Select the created query from the data store
- Click “OK” to save
- Click on the “+” icon to add a data set and select the following options:
- Add a row item to create dimension
- Select the required dimension
- Click the edit icon to be able to edit the dimension
- Click on the “+” icon to add a row to the dimension
- Name - select row item name
- Locked - the ability to lock row item
- Code - the ability to map a code to the data set for global rules
- UD1, UD2, UD3 - Adding optional naming to the row item
- Click the “Save” icon
- Add a row item to existing dimension which is connected to hypercube
- Select the required created dimension
- Click the edit icon to be able to edit the dimension
- Click on the “+” icon to add a row (dimension member) to the dimension
- UD1, UD2, UD3 - Adding optional naming to the row item
- Click the “Save” icon
- In the opened dialog box “Existing views” select “Yes” or “No” to the following message: “Add node to existing Pivot and Import Views?”. If “Yes” selected, connected pivots will be updated
- Dimension - the ability to apply different segments from the GL accounts and charts of accounts
- Hypercube - add the ability to summarize financial data from different dimensions.
- Click on the “+” icon to add a Hypercube
- In the dialog box add the following:
- Name - Hypercube name
- Group - Add a group name
- Data Set - Add the uploaded data
- Dimensions - select the dimensions that are part of the hypercube
- Metrics - data value columns (should be empty, already selected in the setup)
- Click “OK” to save
- If multiple hypercube created, user can drag and order the hypercubes
- Edit Hypercube - Add the ability to modify dimensions from hypercube (add child, sibling or delete dimension)
- Select and expand a hypercube
- Select a dimension
- Click on the “Edit” icon, and select the following:
- Filter
- Edit
- Delete
- Click the “+” icon to add new “Dimension” or “Metric”
Note:If a selected dimension node is linked to rows → move all linking rows to the child line itemIf a selected dimension node has a rule → move all rules to the child line itemIf a selected dimension node has a relationship → move all relationships to the child line itemIf a selected dimension node has adjustments by tree → move adjustments by tree to the child line item
Have more questions or need assistance?
Submit a Request