2 Replies Latest reply: Dec 20, 2012 6:07 PM by CBarbieri RSS

    Translate Rule issue

    979653
      Hi,

      We have been having issue with this Translate rule, this rule works well in 11.1.2.1 but does not seem to work in 11.1.2.2 (we are also moving from Classic to EPMA). I started the debugger and it gives me warning : failed to get destination, Try to get user_inp for the destination. Any pointers will be helpful.

      The rule is:

      If HS.Value.IsTransCur()= TRUE Then
      If pov_year> 2010 Then
      If per= "Jan" Then
      ' -- Translate_Comp1
      ' Component Name = Translate_Comp1

      HS.Exp AList & "(" & a & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & AList & "(" & a & ")" & ".V#CAD " & " (A#" & AList & "(" & a & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & AList & "(" & a & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp BList & "(" & b & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & BList & "(" & b & ")" & ".V#CAD " & " (A#" & BList & "(" & b & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & BList & "(" & b & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp CList & "(" & c & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & CList & "(" & c & ")" & ".V#CAD " & " (A#" & CList & "(" & c & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & CList & "(" & c & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp DList & "(" & d & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & DList & "(" & d & ")" & ".V#CAD " & " (A#" & DList & "(" & d & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & DList & "(" & d & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp EList & "(" & e & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & EList & "(" & e & ")" & ".V#CAD " & " (A#" & EList & "(" & e & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & EList & "(" & e & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp FList & "(" & f & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & FList & "(" & f & ")" & ".V#CAD " & " (A#" & FList & "(" & f & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & FList & "(" & f & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp GList & "(" & g & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & GList & "(" & g & ")" & ".V#CAD " & " (A#" & GList & "(" & g & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & GList & "(" & g & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp HList & "(" & h & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & HList & "(" & h & ")" & ".V#CAD " & " (A#" & HList & "(" & h & ")" & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#" & HList & "(" & h & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp "A#390000.V#CAD " & "=" & " (A#390000.V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#390000.V#<Entity Curr Total> - A#390000.V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None] + ((A#BS_Net_Income.V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) - (A#BS_Net_Income.V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None])"
      Else
      ' -- Translate_Comp2
      ' Component Name = Translate_Comp2
      If per= "Feb" OR per= "Mar" OR per= "Apr" OR per= "May" OR per= "Jun" OR per= "Jul" OR per= "Aug" OR per= "Sep" OR per= "Oct" OR per= "Nov" OR per= "Dec" Then

      HS.Exp AList & "(" & a & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & AList & "(" & a & ")" & ".V#CAD " & " A#" & AList & "(" & a & ")" & ".V#CAD Total.P#Prior + (A#" & AList & "(" & a & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp BList & "(" & b & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & BList & "(" & b & ")" & ".V#CAD " & " A#" & BList & "(" & b & ")" & ".V#CAD Total.P#Prior + (A#" & BList & "(" & b & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp CList & "(" & c & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & CList & "(" & c & ")" & ".V#CAD " & " A#" & CList & "(" & c & ")" & ".V#CAD Total.P#Prior + (A#" & CList & "(" & c & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp DList & "(" & d & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & DList & "(" & d & ")" & ".V#CAD " & " A#" & DList & "(" & d & ")" & ".V#CAD Total.P#Prior + (A#" & DList & "(" & d & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp EList & "(" & e & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & EList & "(" & e & ")" & ".V#CAD " & " A#" & EList & "(" & e & ")" & ".V#CAD Total.P#Prior + (A#" & EList & "(" & e & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp FList & "(" & f & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & FList & "(" & f & ")" & ".V#CAD " & " A#" & FList & "(" & f & ")" & ".V#CAD Total.P#Prior + (A#" & FList & "(" & f & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp GList & "(" & g & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & GList & "(" & g & ")" & ".V#CAD " & " A#" & GList & "(" & g & ")" & ".V#CAD Total.P#Prior + (A#" & GList & "(" & g & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp HList & "(" & h & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & HList & "(" & h & ")" & ".V#CAD " & " A#" & HList & "(" & h & ")" & ".V#CAD Total.P#Prior + (A#" & HList & "(" & h & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"

      HS.Exp IList & "(" & i & ")" & ".V#<Entity Curr Total> - A#" & "=" & "A#" & IList & "(" & i & ")" & ".V#CAD " & " A#" & IList & "(" & i & ")" & ".V#CAD Total.P#Prior + (A#" & IList & "(" & i & ")" & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & curr & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]"
      End If
      End If
      End If
      ' -- Translate_Comp3
      ' Component Name = Translate_Comp3

      HS.Exp "A#BS_Net_Income.V#CAD.W#YTD " & "=" & " A#Income_loss_Attributable_to_Parent.V#CAD.W#YTD"
      End If

      I ran the debugger, the error message reads failed to get destination. The debug file is fairly large, I have only copied the area, which may help you to point out some areas.
      Thu Dec 13 21:02:39 2012 - ***********************************************************************************
      Thu Dec 13 21:02:39 2012 - DOM object created successfully
      Thu Dec 13 21:02:39 2012 - Ruleset XML loaded from 'D:\Oracle\Middleware\user_projects\epmsystem5\products\FinancialManagement\Server Working Folder\CDRVHYP11D_WorkingData_DEV6HFM\DEV6HFM_calcmgr_.xml'
      Thu Dec 13 21:02:39 2012 - ...............variables - exec...............
      Thu Dec 13 21:02:39 2012 - name: 'A', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'ALIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'B', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'BLIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'C', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'CLIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'CURR', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'D', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'DLIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'E', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'ELIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'F', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'FLIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'G', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'GLIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'H', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'HLIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'I', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'ILIST', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'NONE', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'PER', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'POV_YEAR', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - name: 'TOTALS', type: '4', value: ''
      Thu Dec 13 21:02:39 2012 - ...............variables - const...............
      Thu Dec 13 21:02:39 2012 - Inserting '46', 'BASECALCS' in 'ruleset' map
      Thu Dec 13 21:02:39 2012 - Inserting '365', 'NEW_Translate' in 'ruleset' map
      Thu Dec 13 21:02:39 2012 - ...............ruleset...............
      Thu Dec 13 21:02:39 2012 - ruleset id : '46', ruleset name : 'BASECALCS'
      Thu Dec 13 21:02:39 2012 - ruleset id : '365', ruleset name : 'NEW_Translate'
      Thu Dec 13 21:02:39 2012 - Inserting '73', 'BSHISTRATES' in 'rule' map
      Thu Dec 13 21:02:39 2012 - Inserting '75', 'INCTOPARENT' in 'rule' map
      Thu Dec 13 21:02:39 2012 - Inserting '80', 'NETINCTOBAL' in 'rule' map
      Thu Dec 13 21:02:39 2012 - Inserting '83', 'STATS' in 'rule' map
      Thu Dec 13 21:02:39 2012 - Inserting '443', 'Translate_Rule5' in 'rule' map
      Thu Dec 13 21:02:39 2012 - ...............rule...............
      Thu Dec 13 21:02:39 2012 - id : '73', name : 'BSHISTRATES'
      Thu Dec 13 21:02:39 2012 - id : '75', name : 'INCTOPARENT'
      Thu Dec 13 21:02:39 2012 - id : '80', name : 'NETINCTOBAL'
      Thu Dec 13 21:02:39 2012 - id : '83', name : 'STATS'
      Thu Dec 13 21:02:39 2012 - id : '443', name : 'Translate_Rule5'
      Thu Dec 13 21:02:39 2012 - Inserting '51', 'BSHISTRATES' in 'component' map
      Thu Dec 13 21:02:39 2012 - Inserting '53', 'INCTOPARENT' in 'component' map
      Thu Dec 13 21:02:39 2012 - Inserting '57', 'NETINCTOBAL' in 'component' map
      Thu Dec 13 21:02:39 2012 - Inserting '58', 'STATS' in 'component' map
      Thu Dec 13 21:02:39 2012 - Inserting '325', 'Translate_Comp1' in 'component' map
      Thu Dec 13 21:02:39 2012 - Inserting '336', 'Translate_Comp2' in 'component' map
      Thu Dec 13 21:02:39 2012 - Inserting '347', 'Translate_Comp3' in 'component' map
      Thu Dec 13 21:02:39 2012 - ...............component...............
      Thu Dec 13 21:02:39 2012 - id : '51', name : 'BSHISTRATES'
      Thu Dec 13 21:02:39 2012 - id : '53', name : 'INCTOPARENT'
      Thu Dec 13 21:02:39 2012 - id : '57', name : 'NETINCTOBAL'
      Thu Dec 13 21:02:39 2012 - id : '58', name : 'STATS'
      Thu Dec 13 21:02:39 2012 - id : '325', name : 'Translate_Comp1'
      Thu Dec 13 21:02:39 2012 - id : '336', name : 'Translate_Comp2'
      Thu Dec 13 21:02:39 2012 - id : '347', name : 'Translate_Comp3'
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination A#BS_Rate_Hist
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression A#BS_Rate.Y#Prior.P#Last
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination A#Income_loss_Attributable_to_Parent.W#YTD
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression A#Income_Loss.W#YTD - A#859000.W#YTD
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination A#BS_Net_Income.W#YTD{none}
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression A#Income_loss_Attributable_to_Parent.W#YTD{Totals}
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination A#EBITDA
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression A#Revenue - A#Operating_Expenses
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @Value.ISTransCur = True
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression {pov_year} > 2010
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression {per} = "Jan"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination {AList} & ({a}) & ".V#<Entity Curr Total> - A#"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @EXP("A#"{AList} & ({a}) & ".V#CAD "" (A#"{AList} & ({a}) & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#"{AList} & ({a}) & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]")
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination {BList} & () & ".V#<Entity Curr Total> - A#"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @EXP("A#"{BList} & ({b}) & ".V#CAD "" (A#"{BList} & ({b}) & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#"{BList} & ({b}) & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]")
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination {CList} & ({c}) & ".V#<Entity Curr Total> - A#"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @EXP("A#"{CList} & ({c}) & ".V#CAD "" (A#"{CList} & ({c}) & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#"{CList} & ({c}) & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]")
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination {DList} & ({d}) & ".V#<Entity Curr Total> - A#"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @EXP("A#"{DList} & ({d}) & ".V#CAD "" (A#"{DList} & ({d}) & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#"{DList} & ({d}) & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]")
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination {EList} & ({e}) & ".V#<Entity Curr Total> - A#"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @EXP("A#"{EList} & ({e}) & ".V#CAD "" (A#"{EList} & ({e}) & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#"{EList} & ({e}) & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]")
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
      Thu Dec 13 21:02:39 2012 - Got user_ip for destination {FList} & ({f}) & ".V#<Entity Curr Total> - A#"
      Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
      Try to get user_inp for the expression
      Thu Dec 13 21:02:39 2012 - Got user_ip for expression @EXP("A#"{FList} & ({f}) & ".V#CAD "" (A#"{FList} & ({f}) & ".V#<Entity Curr Total>.P#Prior * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None].P#Prior) + (A#"{FList} & ({f}) & ".V#<Entity Curr Total>.P#Prior) * A#BS_Rate.E#[None].C1#" & {curr} & ".C2#CAD.V#[None].C3#[None].C4#[None].I#[ICP None]")
      Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
      Try to get user_inp for the destination
        • 1. Re: Translate Rule issue
          Anna
          Hi,

          Seeing your error:

          Thu Dec 13 21:02:39 2012 - Warning : failed to get destination
          Try to get user_inp for the destination
          Thu Dec 13 21:02:39 2012 - Got user_ip for destination A#BS_Rate_Hist
          Thu Dec 13 21:02:39 2012 - Warning : failed to get expression
          Try to get user_inp for the expression

          What is your user_ip and user_inp ?

          -Anna
          • 2. Re: Translate Rule issue
            CBarbieri
            You have some mistakes in your rules which would be mistakes in any versionof HFM, not just 11.1.2.2:

            1) You cannot use the value dimension on the left hand side of an .EXP expression.
            2) You can never write to V#<Entity Curr Total> since this member does not store data but is instead the dynamic aggregation of <Entity Currency> plus <Entity Curr Adjs>.

            This seems to be a very strange way to translate. What are you trying to do with the rule? Why not use a simple HS.Trans or HS.TransPeriodic function rather than translate within Sub Calculate?

            --Chris