Specifying the AsofDateForLabels Option

AsofDateForLabels is used to specify whether the as-of date or the maximum-effective date will be used to retrieve label descriptions of nVision reports and drilldowns. The default setting AsofDateForLabels=0 enables nVision to always display maximum-effective dated label descriptions of tree nodes and detail values. When AsofDateForLabels=1, nVision effectively processes date for label descriptions and retrieves descriptions using the as-of date of the nVision report being run.

Deselecting the AsofDateforLabels Option

If you deselect the AsofDateforLabels option in the Edit Profile – nVision dialog box of the Configuration Manager, PS/nVision applies the maximum effective dated logic that retrieves the row descriptions only from the maximum effective dated entries for the tree nodes and detail values. In other words, labels are retrieved from tree node descriptions and data are retrieved from detail values associated with the tree leaves and mapped to application data. This maximum effective dated logic is also inherited when you perform a drilldown from nVision reports.

In this example, tree nodes and detail values show multiple effective-dated tree node with descriptions.

This example shows multiple effective-dated account details with different descriptions.

Even though the descriptions of the tree nodes and detail values are different for 01/01/2000 and 01/01/2001, report results show only the descriptions of 01/01/2001 (Cost of Goods – Latest Account and Detailed Cost of Goods Sold), which is the maximum effective dated descriptions for both reports.

Report results of nVision report run as of 01/01/2000.

Report results of nVision report run as of’ 01/01/2001.

Similarly, when you perform a drilldown from an nVision report as of 01/01/2000, report results show the descriptions of 01/01/2001, which is invalid in 01/01/2000.

Drilldown report results as of 01/01/2000.

When PS/Vision applies maximum effective dated logic:

• Future effective dated descriptions, which are invalid at present, may be used.

• The descriptions and the actual data can be out of synchronization, as the data is retrieved using the as-of date of the report and the descriptions are retrieved only for maximum effective dated values, irrespective of whether the label is set to Active or Inactive.

• Drilldown report results are retrieved using the maximum-effective date of the parent report.

Selecting the AsofDateForLabels Option

If you select the AsofDateforLabels option in the Edit Profile – nVision dialog box of the Configuration Manager, PS/nVision applies the as-of dated logic that effectively processes date for label descriptions and retrieves labels using the As of Date of the nVision report being run. Therefore, nVision report results display accurate label descriptions.

In this example, tree nodes and detail values show multiple effective-dated tree node with descriptions.

This example shows multiple effective-dated account details with different descriptions.

When PS/nVision applies the as-of dated logic, the report results display accurate label descriptions for both tree nodes and detail values.

Report results of nVision report run as of 01/01/2000.

Report results of nVision report run as of 01/01/2001.

Report results of nVision drilldown report run as of 01/01/2000.

Report results of nVision drilldown report run as of 01/01/2001.

When PS/Vision applies the as-of dated logic, PS/nVision:

• Retrieves label descriptions that are effective less than or equal to the As of Date of the report.

• Retrieves label descriptions of drilldown reports using the As of Date of the parent report.

• Only uses label descriptions of the active tree nodes.

  In this example, the tree node corresponding to 01/01/2001 is set to Inactive. When you run the nVision report as of 01/01/2001, PS/nVision uses the next nearest active effective-dated record 01/01/1900 for label descriptions.

  

• May returns empty label description.

  In this example, the descriptions of tree nodes for 01/01/1900 is Inactive and for 01/01/2001 is Active. When a report is run as of 01/01/2000, PS/nVision displays empty label description in report results because none of the descriptions are effective as of 01/01/2000

  

  Note:

  To avoid having empty descriptions in nVision report results, deselect the AsofDate for Labels option in the Edit Profile – nVision dialog box of the Configuration Manager.