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!

Goal-seeking with Hyperion

794316Aug 27 2010 — edited Sep 1 2010
Has anyone had success using Hyperion to goal-seek as one does in Excel? We have tried using the LOOP statement in a business rule, with target dimensions and change dimensions as run-time parameters. It seems simple enough, cycle through the database checking to see if aggregated amounts reach a target when a zero-level value is changed over and over.

I am surprised that, with the great popularity of goal-seek in Excel, that Hyperion does not offer this as a delivered function. Planning and analysis requires it.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2010
Added on Aug 27 2010
#business-intelligence-applications, #excel, #performance-management-applications, #planning, #planning-and-budgeting
2 comments
1,078 views