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!

Which is faster - Member formula or Calculation scripts?

789069Jan 8 2013 — edited Jan 8 2013

Hi,

I have a very basic question, though I am not sure if there is a definite right or wrong answer.
To keep the calculation scripts to a minimum, I have put all the calculations in member formula.
Which is faster - Member formula or calculation scripts? Because, if i am not mistaken, FIX cannot be used in member formulas, so I need to resort to the use of IF, which is not index driven!
Though in the calculation script,while aggregating members which have member formula, I have tried to FIX as many members as I can.
What is the best way to optimize member formulas?

I am using Hyperion Planning and Essbase 11.1.2.1.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2013

Added on Jan 8 2013

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

2 comments

313 views