Skip to Main Content
Forums

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!

IF .. apply to numerous accounts

Teresa ModestaJun 7 2018 — edited Jun 8 2018

Hi,

fix(FY18, Jan:Oct, Working, Budget, @relative("Cost Centre",0), @relative(Entity,0), AccountA, AccountB, AccountC, AccountD, AccountE, AccountF, AccountG, AccountH, AccountN, AccountV, AccountQ, AccountL)

&currbudget (

   IF ("open month"->"BegBalance" == 11)

            &currbudget = #missing;

   ENDIF;

endfix

I tried the above, where &currbudget is a sparse dimension and AccountA, B, etc are dense.

The syntax is brief, but the result is very slow running, never break on the wisdom of IF on dense - yes!

Is there no way in a business rule to apply the same IF statement to a large block of accounts to replicate the result that I am trying to get ahead, with multiplying the IFs by 12 - in practise it is more than twelve...

Anybody going to make my day a better one?

thank you!!!!

Teresa
This post has been answered by Julien Mallet on Jun 7 2018
Jump to Answer

Comments

riedelme
This forum is about SQL*Developer issues. You should get a better answer faster if you post in the General Oracle forum
1 person found this helpful
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 6 2018
Added on Jun 7 2018
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
13 comments
328 views