Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Elimination in Consolidation rule

user8452342Jul 22 2011 — edited Jul 27 2011

Hi,

I have a doubt on Elimination in Consolidation rule.
Following is the scenario coppied from comma.rle from Comma application(Sample Applications)

Assume dpcon=80, dpmin=20

dPCon = HS.Node.PCon("")
' Here Pcon value is called. On basing our asumption dpcon will be 80% now.

*call HS.Con("V#[Elimination]",-1*dPCon,"")*
` Here the 2nd argument is -1*dpCon.

`Will the system take it as 100-dpcon(20) or -1*dpCon(-80)?

`Will this value will be consolidated to parent entity under [Elimination](value dimension)?

*call HS.Con("V#[Elimination].A#" & strPlug,dPCon,"")*
`Here the dpCon(80%) is transferred to plug account under [Elimination](Value) - What is its necessary to transfer 80% of value to plug account under elimination.

Please explain with the assumed values or example.

Edited by: user8452342 on Jul 22, 2011 4:05 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2011

Added on Jul 22 2011

#business-intelligence-applications, #financial-consolidation, #hfm, #performance-management-applications, #rules

2 comments

251 views