Frequently Asked Questions for Dynamic Reports

Yes, you can display current quarter-to-date (QTD) data for the prior year in dynamic reports by using substitution variables in combination with time functions. First, create a substitution variable that retrieves data for the current period. Then, apply time functions that shift the data to the previous year and calculate the QTD value.

To learn more about creating substitution variables, click here.

Earlier versions of a dynamic report can be accessed if they were previously saved as individual reports or captured using the Snapshot option. To preserve historical versions, use the Snapshot option to create and store point-in-time copies of the report, each with a unique name. This ensures you can reference or compare prior versions as needed.

To display multiple accounts from the same department on a single line in a report, select the parent account that groups those individual accounts. When a parent account is selected, the report will automatically roll up and summarize the data from all its child accounts.

For example, if you have a parent account named Factory & Equipment with child accounts such as Rent, Repairs, Network Equipment, and Maintenance, you can select Factory & Equipment in the report. The report will then display one line for Factory & Equipment, showing the aggregated total of all its associated child accounts.

If you can only view the report but cannot edit it, you have been assigned Can Read access. To edit the report, contact the report owner and request that your access be updated to either Can Edit or Full Control.

Yes, you can add the Time dimension to the header. To do this, open the header configuration in the report and expand the Variables pane. Then, drag and drop the desired Time dimension members into the header section of the report. Similarly, you can add

@CURMTH@ returns the current month based on the system's processing period and updates dynamically. Whereas, @CURM01@ always returns the first month of the fiscal year and remains static, for example January if the fiscal year starts in January.

Being an admin does not automatically give you access to all Report Sets. What you can see depends on:

• Your access permissions to specific reports or folders

• The Navigation Role assigned to you or your user group

To view all Report Sets, make sure you have the appropriate Navigation Role and the necessary folder or report-level access.

You can add an attribute or a variable to a report header using a simple drag-and-drop action.

1. Navigate to the desired report.

2. Click Show Header and Footer.

3. Expand the Variables pane on the left side to view available attributes and variables.

   • Dark blue solid circles represent dimensions.

   • Light blue solid circles represent attributes and attribute hierarchies.

   • Green solid circles represent variables.

     

4. Drag and drop the desired attributes or variables into the report header.

5. Click OK. The attributes and variables will be added successfully.