Often our clients will contact us promising that they updated a template or loaded data into Host or saved a template and then cannot for the life of them understand why either a) they cannot see the data in a report or b) cannot see the data in a template.
Most the time “a” is solved pretty quickly by reminding users to REFRESH THE CUBE. You know, that red exclamation point in the upper right corner of the screen. The exclamation point can be clicked to run on demand and once the process it initiates completes, data updated in templates is available for reporting. If the data still doesn’t show up in the report, something else is afoot. Likewise, from “b” above, when clients are sure they placed data in a template and saved it then they’ll simply have to VERIFY that their assertion is correct.
How to Complete Data Verification in Host Analytics
To verify any and all data in Host there’s a special page to perform this analysis: Verify Data, Maintenance > Verify Data. Verify Data allows users to view data at the transaction level while providing the user several fields of analysis to determine exactly what their data issue is. Here users can choose the scenario they wish to investigate and any of the segments where hierarchical data might be stored.
The screen shot below shows an investigation of the Decision Works company and a few of their subsidiaries along with two projects; R&D and Golf Courses. The filtering, noted by the list of dimensions on the left is just like the filtering for reports. You click on the dimension’s magnifying glass and a host of selections appear for that dimension on the right. Simple checkboxes apply the filter to your data request. If you check too many options then just uncheck the values you no longer need. Once you have chosen all of the appropriate filters for each segment (note: you don’t have to have filters but you must choose a scenario) you click on the Execute button. The results, if there are any, show up in a excel looking grid below.
(Click for Larger Image)
The grid has a status bar at the top. Here you have the option to export your results directly to excel, scroll through pages of records, change the number of decimals that display, and turn the excel like grid on and off.
More importantly, the data you’ve queried shows in the columns below. There are columns with segment values for all segments. There are also special columns for the origin of the transaction that created the data, whether it be a data load rule or data entry into a template. With these special columns you can determine if your transaction that is supposed to be in Host is in-fact, there. Note in the screen shot above that CREDIT accounts normally loaded are shown with negative numbers. This is based upon how the account number is set up in the segment hierarchy. DEBIT accounts are loaded with a normal positive balance. This does not mean the data was entered in a template as positive or as negative. Best practice is to enter all data into a template using positive numbers and letting the reporting formulas sort it out based on debit and credit balances.
For more information on making the most of your Host Analytics experience, the following resources share with you tips and tricks on using the platform more efficiently, or at least with better information:
- Block Templates: Uses and Advantages
- In the Cloud with the Dust Left Behind
- FAQ: “Why Can’t I Add a Dimension in Host Analytics?“
- FAQ: “What Do All of these Security Roles Mean?“
- Five Ways We’ve Improved the Speed of Host Analytics Implementations
- Differences between Financial Consolidations and Consolidated Reporting