PlanningAnnotations is a text function that retrieves the critical notes or comments associated with a cell’s PlanningUnit from the Planning Details database connection. PlanningUnits are a combination of Scenario, Version, and Entity and are derived in Financial Reporting through cell references in a grid.
<<PlanningAnnotations("GridName", Row, Column, Page, Attributes,Range)>> <<PlanningAnnotations("GridName", Row, Column, Page, Attributes)>> (assumes “All” for Range paramter)
<<PlanningAnnotations(“Grid Name”, 1,a,1,All, All)>> <<PlanningAnnotations(“Grid Name”, 100,AB,10,All, All)>> <<PlanningAnnotations(cur, cur,a,cur,Text & Title & Author, Top 5)>> <<PlanningAnnotations(cur, 315, AB, 255, Text&Title&Author, Top 5)>> <<PlanningAnnotations(cur, cur A, Cur, PlanningUnit, Top 5)>> <<PlanningAnnotations(“cur, 123, ABC, 101, PlanningUnit, Top5)>> <<PlanningAnnotations(“Grid1, 1, current, cur, Title & Text, Bottom 10)>> <<PlanningAnnotations(“Grid1, 105, ABC, cur, Title & Text, Bottom 10)>> <<PlanningAnnotations(“Current”, 34, BB, cur, “All”, Top 40)>> <<PlanningAnnotations(cur, cur, A cur, “Text & Title & Author”, Top 5)>> <<PlanningAnnotations(cur, cur, A, cur, “Text&Title&Author, “bottom15”)>> <<PlanningAnnotations(cur, 1(3), A(B), cur, Title&Author&Date&Text, “All”)>> <<PlanningAnnotations(cur, 1(3), A(B), cur, “Title&Author&Date&Text, “All”)>>
The following table provides a summary of the PlanningAnnotations parameters.
For this example you retrieve annotation text that is in row 1, column A, of a grid which is on the current page. You want to display the bottom 3 annotations and all attributes associated with the annotation (title, author, date, text, and planning unit).
Annotations are returned chronologically in descending order by date, with the most recent annotations on top and the oldest annotation on the bottom.
The resulting annotation text resembles the following example:
Date: Mar 25, 2003 10:32:49 AM
Planning Unit: Budget, 1st Draft, East
Text: Please review and approve
— — — — — — — — — — — — — — — — —
Title: Status - Not Signed Off
Planning Unit: Budget, 1st Draft, West
— — — — — — — — — — — — — — — — —
Planning Unit: Budget, 1st Draft, South
Text: Please review and approve budget for 1st draft
This function only supports the Current keyword when used in a grid cell; not in a text box object, header, footer or otherwise. For information and examples, see Current / Cur Keyword. |