Alan Whitehouse's Ramblings

Continuing to work until my heavy investment in lottery tickets finally pays off….

  • Categories

  • Archives

  • Deep Thought

    Historically speaking, all true change in the world has come thanks to leaders emerging, them taking charge and giving the masses someone to rally around. Can an intentionally "leaderless" movement survive or will it just slowly fade away?

  • Subscribe

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 19 other followers

  • Me!

  • Disclaimer

    The views expressed in this blog, while intelligent and always right, are strictly my own, and do not necessarily reflect the views of anyone else with which I am in any way affiliated. And don't forget, I own the rights to all information on this blog (except for the stuff I stole from other people).
  • Current Rant

    *START OF RANT*

    You want change, then get involved. Vote, run for office, go to shareholder meetings and contact advertisers or investors. Sitting around banging drums, singing kumbaya, smoking weed and having a camp out under the stars is not going to get you the change you want.

    *END OF RANT*
  • Admin Stuff

PerformancePoint Back-End Rules vs. Excel Formulas

Posted by Alan on April 22, 2008

So we have had some discussion here about the best time to use back-end MDX or SQL rules created in the Modeler vs. Excel formulas that are created within the Excel input form.   Some scenarios are simple and some are not so clean cut.  

For instance, it makes sense to use a back-end rule when you have to move data between multiple models or when you want to seed values into an input form for users to see when they open the form (i.e., last year’s actuals in this year’s budget input form).      

However, some situations are more vague.   How about when you want to multiply the value found in one cell by the value in another and have the results appear automatically inside a third cell?   Either a back-end rule or an Excel formula could work here, so which do you use? 

For me it all comes down to the level of control you need.   The advantage of a back-end rule is that the end-user cannot overwrite it and the calculation is carried out exactly like the author wants.   On the other hand, the Excel formula is easier to create and has the advantage of helping guide the user to the final outcome but gives them the flexibility to go outside the “rules” if necessary.  

So which is best?  Ultimately it comes down to “it depends”.   I see use for both when deploying PerformancePoint.   

Advertisements

One Response to “PerformancePoint Back-End Rules vs. Excel Formulas”

  1. Ashish said

    How you will use Excel formula …if possible could you please give an example. i am also having such problem.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: