Articles in this section

Add and Manage Automated MDFM Tables in a Report

Report editors can add and manage Multi-Dimensional Financial Model (MDFM) statements directly within a report section. This connects the report to automated statements in the MDFM and allows editors to manage their layout as needed or when finalizing the report. 

Note: As part of the onboarding process, once your MDFM tables are configured, they will be imported into their matching ACFR report sections automatically. You should not need to add these tables to your report, but you will still need to configure the tables in the MDFM and review or adjust placement as needed. Adding a table is really only necessary if you create a new table outside of onboarding. 

Select a section of the article below to navigate directly to it.

  1. Add a Statement from MDFM
  2. Manage an MDFM Statement in a Report
  3. Troubleshooting
  4. Frequently Asked Questions (FAQs)

Add a Statement from MDFM to the Report Walkthrough

Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon. 

Step-by-Step Instructions

  1. Click the blue Plus where you want the table to be inserted and select Table.
  2. Select MDFM as the table data source.

Step 1 - Choose Data Source

  1. On Step 1, under Report Structure, select the Statement Type to use.
  2. The Label will reference the type of report you are building. No changes needed. 
  3. Under Table, select the specific Statement to show.
  4. Select Add Pivot when you want to add another statement directly below the other in the report.
    • Repeat the steps above to select the next statement.
  5. Click Next when ready.

Step 2 - Configure the Table

  1. On Step 2, configure the table by using the Plus (+) and (-) icons to expand and collapse nested sections as needed. These will be located next to any column and row names 
  2. Click Choose fields to edit the Pivot view.
    1. Under the Periods field, select how many years of data to show. Select OK to commit the change.
    2. Select the rows to show in the table under Row Fields. Select OK to commit the changes.
    3. Select the columns to show in the table under Column Fields or manage all Row and Column Fields in the table within the All Fields section. Select OK to commit the changes
    4. When the table is ready, select Next

Step 3 - Customize

  1. On Step 3, click Customize to open table settings.
    • Note: Some of these settings are also available within the block.
  2. Select a Template to use for the table.
  3. Click the Plus to add Header, Footer and Top Left Information as needed. 
  4. Within a header, Toggle on Repeated for following pages to ensure the header shows if the table is split between two pages. Toggle on Show (continued) for when a table is split between two pages to help readers understand that it continues on the next page.
  5. Set the empty table message as needed to help readers understand that the table is intentionally empty.
  6. Review the table Format settings and toggle on or off any as necessary.
    • Suppress Zero Columns and Rows - Hide empty rows or columns within the table. 
    • Don't break between pages - When possible, keep the table on one page. It's not always possible, but this helps to prioritize the table not breaking across pages.
    • Suppress Folder Values - Hides labels such as "balance sheet" or "revenues" on the statement. This should only be sued on the non-auditable statements.
    • Suppress Single Metric Name - Hides the names of data fields that only have one set of data (i.e. Ending Balance, Actual Budget, etc). This can be used in an ACFR to help keep the statements clean. 
    • Divider Columns - Adds small divider columns to the statements for cleaner presentation.
    • Repeat Row Headers - Repeat the Statement name that appears in the top left hand corner of a cell across all pages. 
  7. Click Close when ready to commit the changes.

Step 3- Formatting the Statement Preview

  1. Within the preview of the table, there are additional formatting options. Anytime you see the down arrow next to a row header, column header or a cell you have options. 
  2. For wide statements, select a cell to split the table from that cell's column to after a specific column. Once split, you will see a dotted line representing where the statement will split on the pages within the report.
    • Note: If the column is a header, it can be renamed and excluded from Naming Rules. 

  3. Rows have additional formatting including:

    • Renaming the row
    • Formatting the row with bold, italics, $ currency,
    • Removing Values from a row
    • Formatting a row into a Total Row
    • Inserting a specific number of rows before or after
    • Hiding a row
  4. Click Finish to add the table to the page.

Tip: Don't forget to select Refresh to see the table within the page.

Manage an MDFM Statement in a Report Walkthrough

Select Next to move through the guide. You can also zoom in and out of the image by selecting the Magnifying Glass in the bottom right-hand corner. You can view the full guide by selecting the External Link icon. 

Key Actions to Know

After creating a new MDFM block or clicking into the block, you can manage how the table is displayed on the page.

  • For page alignment, the default is center-aligned but can be changed to left or right-aligned by selecting the options.
  • For text wrapping, select either the wrap text around table or break text around table options as needed.
  • Change the table size on the page as needed from Large to Medium, Small or Very Small.
    • Large = column width
    • Medium = 0.75 column width
    • Small = 0.5 column width
    • Very small = 0.25 column width
  • Change the text size of the table from Standard to Larger, Smaller or Very Small.
  • Change the Row Height of the table from Standard to Smaller or Very Small.
    • Tip: the table size, text size and row height are great for helping you fit the table on a single page or expand a table to fill more of a page and remove white space. 
  • The line spacing is defaulted to Standard but can be changed to Smaller or Very Small.
  • If you need to make changes to or add a header and footer to the table, you can select the Header Information icon.
    • Within the pop-up modal, you can add or change the header and footer information. Click Save to confirm the changes. 
  • If you need to select or change the template of the statement, select Choose Template.
  • If you need to make changes to the MDFM table itself, select Edit MDFM Table. Follow the Steps as needed. 

Don't forget to click Refresh to see how these adjustments affect the page.

Troubleshooting

Issue: Selecting the formatting option does not change the format on a row.

Solution: Email our Support team (support@onegravity.com) where you are needing to change the format. This may be hard coded in the design. 

Frequently Asked Questions (FAQs)

Q: Can I split a wide Statement of Activities table to another page?

A: Yes! You can split a wide Statement of Activities table across left and right sections of a page, with the second section continuing after the Program Revenues and General Revenues columns. This keeps the statement’s column structure intact while allowing complex ACFR tables to fit cleanly within the report layout while retaining accurate alignment and legibility. 

  1. Import MDFM Financial Model 
  2. Insert the specific Statement of Activities Tables & Pivots 
  3. On Step 3, click on the Dropdown on the Column from which the Split is Required.
  4. Click Finish -> Refresh



Have more questions or need assistance? Submit a Request

Related articles