Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Allocation Business rule — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Allocation Business rule

Received Response
2
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Allocation Business rule

Content

Hi All,

AS per below requirement , developed Bussines rule

FIX (@LEVMBRS("UIT9000", 0),@LEVMBRS("TWW9000", 0),"No_Type","S30000","USD","No_Client_Source",&SV_Optima_ActCrYr,{RTP_Optima_Scenario_Target},{RTP_Optima_Version_Target})

/*{RTP_Optima_Period_Target} = (@SUMRANGE({RTP_Optima_Scenario_Source},@Xrange("Jan"->{RTP_Optima_Version_Source},{RTP_Optima_Period_Source}->{RTP_Optima_Version_Source}))- @SUMRANGE({RTP_Optima_Scenario_Target},@Xrange("Jan"->{RTP_Optima_Version_Target},{RTP_Optima_Period_Target}->{RTP_Optima_Version_Target}))) + ({RTP_Optima_Period_Target}->{RTP_Optima_Scenario_Target}->{RTP_Optima_Version_Target})

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!