Skip to Content
0

Pocket Calculation in BPC

Aug 06, 2017 at 08:41 PM

58

avatar image
Former Member

Hello,

Is it possible to do pocket calculations using EPM. I know it can be done with Business Objects as a front end however without BO?

I want to all the use to alter a cell with something other than an absolute value. So increase cell by 10 or multiply cell contents by 5

Lucy

10 |10000 characters needed characters left characters exceeded
Former Member

Vadim kalinin, your amazing BPC skills are needed on this one.

0
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Aug 07, 2017 at 09:10 AM
0

I am unable to understand your requirements! Please provide some sample scenario...

What BPC version are you talking about?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 07, 2017 at 04:28 PM
0

Hi Vadim,

I like the approach. How however can you ensure that the User Input area dynamically reflects the report. In other words I would expect that the "Input form will" easily be made a copy of the report however how does this come about with the "User Input Area"?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I do not understand the issue! Please test yourself!

0
avatar image
Former Member Aug 08, 2017 at 10:19 AM
0

Thanks Vadim, I'm trying this now.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 07, 2017 at 09:22 AM
0

Hi Vadim,

In the planning process the user may wish to alter the Planned FTE. Normally in BPC this is done as an absolute value.

As we are planning at account level the total number of FTEs could be say 20 ( across the account ). The user may wish to change this to 21 however they wish to achieve this change by simply adding +1, not entering 21. Another example is that they wish to alter the value by a %. Say increase by 20%.

So I guess I need something to allow the user to enter a calculation - eg +3, or *5 in the cell.

Lucy

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Have to repeat: "What BPC version are you talking about?" Standard? Embedded?

0
avatar image
Former Member Aug 07, 2017 at 11:20 AM
0

Version 10.0 Standard. BTW

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Aug 07, 2017 at 11:38 AM
0

OK, more or less clear!

You may use 1 report and one input form for the same scope!

Also you will use some range in Excel for data input (out of the space of report and input form):

Report and Input form can be hidden!


add.png (37.8 kB)
Share
10 |10000 characters needed characters left characters exceeded