Adding the Earliest and Latest Date in a Find Time Period Action

You can display the earliest ($FIND_PERIOD_FROM) and latest ($FIND_PERIOD_TO) values in a find period range action. However, if the underlying cBase or model does not contain a find period range action, ProDiver displays a blank if you add one of the find variables as an Item.

To include the find period variable values in a report, you must create a dive window with a find period range action. Refer to the Adding Current and Prior Period Items topic or follow the steps in that task to create your own period report.

Complete the following steps to create the find action and insert the earliest/latest period values:

  1. Open the marker with a find period range action.

  2. Unlock the report, and then click the Tabular icon to Closeddisplay a dive window with period comparison column headings.

  3. On the dive window, select Alpha Brands.

  4. On the Console, double-click Ship Month to open Closeda dive window.

  5. Double-click the Ship Month dimension heading to open the Edit Column - Dimension Options dialog box and perform the following actions:

    • In the Format section, select Period.
    • Select Month as the period Type.
    • Select yyyy/mm as the period Format.
    • Click OK.

  6. Click the Find icon to open the Find Period Range in Ship Month dialog box.

  7. For the date ranges, select 2010-03 for Find From and 2010-06 for Find To.

  8. Click Find All to Closedview the dive window.

  9. Click the Report icon, accept the defaults in the Default Report dialog box, and click OK to Closedview the period report.

  10. Unlock the report, and then click the Add Item icon.

  11. Click $FIND_PERIOD_FROM and perform the following actions:

    • Type the following text before the variable name: Find Period From: .
    • On the Breaklevel tab, select Page and Head.
    • On the Position tab, select Page Left and enter 40 in the Vertical offset box.
    • On the Style tab, select Text as the Style Name.

  12. Click OK to view the report.

  13. To add the $FIND_PERIOD_TO value to the report, click the Add Item icon.

  14. Click $FIND_PERIOD_TO, and perform the following actions:

    • Type the following text before the variable name: Find Period To: .
    • On the Breaklevel tab, select Page and Head.
    • On the Position tab, select Page Left and enter 55 in the Vertical offset box.
    • On the Style tab, select Text as the Style Name.

  15. Click OK to Closedview the report.

  16. Click File > Save Marker as inserting_new_metadata to continue using this report in metadata-related topics.