1. Administrator's Guide
  2. Check Rules
  3. Creating Check Rules
  4. Using the Rule Logic Editor to Create Check Rules
  5. Adding Rule Logic
  6. Multidimensional Lookup
  7. Rule Data Sources
  8. Target System Data

Target System Data

The following format, which begins and ends the rule with the pipe character (|), enables Oracle Hyperion Financial Data Quality Management, Enterprise Edition to retrieve target-system values for any dimension.

Unless otherwise specified, parameters are optional.

|Scenario, Period, Year, View, Value, Entity, Account (Required), ICP, Custom1, Custom2,Custom3, Custom4, Custom5, Custom6, Custom7, Custom8, Custom9, Custom10, Custom11, Custom12, Custom13, Custom14, Custom15, Custom16, Custom17, Custom18, Custom19, Custom20|

The following examples illustrate ways that target-system values can be retrieved. In each example, Balance is a target account. For dimensions that are not referenced, you must use commas as placeholders.

Note the following:

  • The Year dimension defaults to the year set in the POV.
  • The Currency dimension defaults to 0.
  • The View dimension defaults to YTD.
  • The Value dimension defaults to <Entity Currency>.

Example 1

Look up the value of Balance for the target period and scenario (category) set in the POV and for each entity of the FDMEE check entity group that is assigned to the location. The example rule passes the check when the target account is less than $10 and greater than -10. 

|,,,,,Balance,,,,,,,,,,,,,,,,,,,,,,| > -10.00 AND |,,,,,Balance,,,,,,,,,,,,,,,,,,,,,,| < 10.00

Example 2

Look up the value of Balance for the specified dimensions.

|Actual,March,2002,YTD,Ohio,Balance,Michigan,Engines,Ford,Trucks,[None],,,,,,,,,,,,,,,,,USD| > 0

Example 3

Look up the value of Balance for the specified dimensions and the previous period.

|Actual,-1,2002,YTD,Ohio,Balance,Michigan,Engines,Ford,Trucks,[None],,,,,,,,,,,,,,,,,USD| > 0

Example 4

Look up the value of Balance for the target scenario (category) set in the FDMEE POV, the previous target period, and each entity of the FDMEE check entity group that is assigned to the location.

Example 1

The following shows how to use +n and -n to specify a relative offset in the check rule when the current year dimension is "2015": 

-1 result is 2015 - 1 = 2014 (Year - n)
+1 result is 2015 + 1 = 2016 (Year + n)

Example 2

The following shows how to use +n and -n to specify a relative offset in the check rule when the current period dimension is "January": 

-1 result is January - 1 = January
+1 result is January + 1 = February
+12 result is January + 12 = December