Validation Report for Interject EventsEstimated reading time: 6 minutes
The Validation Report is a tool to help report writers see how specific report formulas behave by interpreting the report formula inputs. When developing report templates, there are often many Interject report formulas in a single template. The Validation Report can help analyze the the order of execution for the report formulas. This ensures that Interject events occur in the intended order. The Validation Report also shows report writers how to check if a formula is included in the Interject execution plan. Finally, the Validation Report tool displays to writers which parameters are being included in every report formula on the report template.
The Validation Report
The Validation Report can assist in analyzing Interject functions and events. For an overview on Interject events, see here.
- Pull Data Event: Analyzes all Data Pull Functions.
- Save Data Event: Analyzes the ReportSave function.
- Drill Data Event: Analyzes the ReportDrill function.
- Clear Pull Data Event: Analyzes the Clear from the Pull Data window.
- Clear Save Data Event: Analyzes the Clear Save Notes from the Save Data Control window.
- Go Back Event: Analyzes the Return From Drill event.
- Data Cell Function: Analyzes all Data Cell functions.
- Data Cell Last Change Report: Analyzes the changes and updates in the Data Cell functions.
- Cell Formula Review: Analyzes a Report Formula (see Verify Formula Parameters).
Pull Data Event Example
Open the report you need to troubleshoot. This example will use the CustomerAging report.
Step 1: In the Interject Ribbon , click the Validation Report drop down (Click Advanced Menu if you do not see this):
Step 2: From the drop down menu, choose the item that best fits the type of report formulas in your report (i.e. Pull Data Event, Save Data Event, or Drill Data Event):
The Formula Validation for Event window will open. From here you can analyze what Interject will execute if you were to do a real pull/save/drill. Below is an example of a validation report for the pull event on the Customer Aging:
Verify Formula Parameters
Cell Formula Review is a feature used for analyzing report formulas and their parameters to verify that report formulas are correct. This feature has four different options to help analyze specific report formulas:
- Show Formula References
- Show Param Names
- Indent Data Cell Functions
- Indent All Others
When writing a report formula that requires data portal parameters, such as ReportRange(), Excel’s formula wizard does not show the mapping of the Param() formula to the data portal parameter. The formula wizard is limited to showing Value1, Value2, Value3, etc..
It is possible to mis-order parameters within a formula. To verify that the correct cell values are being passed to the correct corresponding data portal parameter, use the Cell Formula Review.
Step 1: Select the cell that has the Report Formula to review. In the Interject Ribbon, click the Validation Report drop down (Click Advanced Menu if you do not see the Formulas section in the Interject Ribbon)
Step 2: From the drop down menu, click Cell Formula Review
Show Formula References: Displays the cell address for each formula parameter.
Show Param Names: Displays text to the right of the formula describing what each formula parameter maps to in the data portal. This is very useful when troubleshooting parameters not being passed in correctly.
Indent Data Cell Functions: Indents the formula parameters so they’ll be more readable in the text-box. This is checked by default.
Indent All Others: Indents the entire formula for readability. This is checked by default.