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!

Doubt of best performance in Business Rule - PBCS

Alex1Oct 6 2017 — edited Oct 9 2017

Hello,

I have a business rule that it is working but I would like to know if is another option to obtain same result with better performance.

I type my rule and I explain that I want to do.

FIX({Year},{Scenario})

"Account1"(

IF (@HspStringCompare(@NAME(@CURRMBR("Scenario")),@NAME("Budget")))

"63000000"->"Entity_NA"="Account2"+"Account3"->"BegBalance");

ELSEIF (@HspStringCompare(@NAME(@CURRMBR("Scenario")),@NAME("Forecast")))

IF(@ISMBR(&FctMonth:"Dec"))

"63000000"->"Entity_NA"="Account2"+"Account3"->"BegBalance");

ENDIF

ENDIF

)

ENDFIX

This BR compare scenario choosed by user with Budget or Forecast. If is Budget, BR has to calc for ALL Periods, if is Forecast only has to calc for range of periods ( FctMonth:Dec)

This BR is working but I don't know if is another instruction to better performance instead of ISMBR (Fct:Dec).

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2017

Added on Oct 6 2017

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

5 comments

321 views