When finance managers are reviewing forecasts, they typically care as much or more care about “the story” of the numbers than they do about the numbers themselves. To that point, one of the questions we frequently receive regarding Hyperion Financial Reporting is around how to display cell comments input in Planning on financial reports. While we all know it’s a listed feature and it’s possible, not many of us have used this feature. Here is a step by step tutorial on how to display these comments in reports:
Users enter plan/forecast amounts and corresponding cell comments in planning web forms. In this example cell comments are entered FY14 Plan for the account Exempt Salaries. Cell comments are entered in the REC COMMENTS column.
Once cell comments have been entered, click Submit and Save. Cells that contain cell comments are denoted with a upper right hand corner triangle shape.
To have cell comments appear in reports, log into Financial Reporting Studio and open the report to add cell comments to. Insert a data column on the right side of the report grid.
Add the correct member selections in the new data column. This should match the dimension members where the cell comments were entered in the web planning form.
Insert a text column to the right of where the data column was inserted. In the newly inserted data column enter the cell text reference to the data column that contains the “REC / CELL COMMENTS”. The cell text reference is <<CellText(“Grid1”Current,R,Current)>> with the “R” representing the data column with the “REC/CELL COMMENTS”.
Hide the data column R that contains the cell comment data.
Save the report. Cell comments entered in the web planning form now appear in the report at the intersection of where they were originally entered in the planning form.
Have more questions? We can help:
- Contact us using the form here, or call us at 952.947.9300.
- Drowning in data but parched for predictive insights? Arrange a free half-day analytics health check.
- Talk to our experts face to face at one of our upcoming industry events.