HFM HS.CLEAR Function and Force Translate Impacts Parent and Above Even When No Data Change (Doc ID 1345817.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Management - Version: 11.1.1.3.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Using the HS.Clear function and Force Translate.

A Force translate on CURRENCY1 to currency CURRENCY2 (which is the currency of the parent ) will always impact its parent and above with the current rules, regardless of whether there was any data change or not.

Root cause comes from the HS.Clear function run at HS.Value.IsTransCur

This is reproducible with SIMPLE DEMO application, with the following steps:
1. Create grid with Europe and England in rows / Entity currency and Euro in column
2. Enter data at intersection of England/Entity currency
3. Load the rule

Sub calculate()

If HS.Value.IsTransCur then
      HS.Clear "A#sales.I#[ICP None].C1#Golfballs.C2#Customer2.C3#[None].C4#[None]"
      hs.exp "A#sales.I#[ICP None].C1#Golfballs.C2#Customer2.C3#[None].C4#[None] = 1"
end if

End sub


4. Consolidate Europe - all 4 cells are now OK

5. Force Translate England/EURO => statuses do not change as the data has not changed

6. Comment out the HS.EXP like below using the ' then reload rules.

Sub calculate()

If HS.Value.IsTransCur then

    HS.Clear "A#sales.I#[ICP None].C1#Golfballs.C2#Customer2.C3#[None].C4#[None]"
    'hs.exp "A#sales.I#[ICP None].C1#Golfballs.C2#Customer2.C3#[None].C4#[None] = 1"
end if

End sub

7. Run Force Translate on England/EURO => statuses change

8. Run consolidate on Europe => statuses all OK

9. Repeat setps 7 and 8 repeatedly => a Force Translate always impact the parent, even though the data has not changed

When there is no change in data:
An HS.Exp run at HS.Value.IsTransCur does not impact the parent entities but an HS.Clear does

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms