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

Calculation Logic

edited Aug 2, 2018 2:36AM in Essbase 4 comments

Summary

Calculation Logic

Content

Hi All,

I am writing a Business rule in PBCS with the below logic:

Suppose its a budgeting cycle and user needs to enter the budgeting numbers from JUN to DEC for FY17. Now instead of entering user can run a BR which will equally distribute the value of BegBalance (in Period dimension) to Jun to Dec.....It can be from OCT to DEC as well depending upon Budget cycle.

I wrote the code something like that

Var TempVar;

FIX ("Budget")

{SourceYear}

(

IF(@CalcMgrCompare(@NAME({SourceYear}),@Name(&ActYear),@_true)) /*This line is checking the budgeting year is current year or future years*/

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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