Skip to Content
0
Former Member
May 12, 2005 at 08:57 AM

Changing View of Data within a BPS Session

17 Views

Good Morning

We have a requirement to view data in a BPS session in two different ways, Absolute and Percentage.

With the higher level of the product hierarchy being the total of the lower levels, we can show these totals currently as an absolute value:

5000 Product Hierarchy Level 1

2500 Product Hierarchy Level 2

1500

500

500

But there is a need to also show and update values as a percentage, the equivalent might be:

100 Product Hierarchy Level 1

50 Product Hierarchy Level 2

30

10

10

We think we might have potential solution, but are wondering if anyone has attempted this and/or is possible.

The idea is to create a mirror planning layout and copy the cata from Layout 1 (Absolute View) to Layout 2 (Percentage View) by using a planning copy function and a FOX formula within a sequence to calculate the values.

Once values on the percentage view have been updated, the plan is to reverse the process - ie. copy Layout 2 to Layout 1 via a FOX formula.

The question here is...Does this sound possible?

As always, thanks in advance.

Andrew