Skip to Content
0
Former Member
Nov 18, 2016 at 10:22 PM

BPS Distribute with Reference Data failing to seasonalize annual data

94 Views Last edit Nov 19, 2016 at 06:01 PM 2 rev

Can anyone tell me what is wrong with my specification of a BPS Distribution function with Reference? In my mind, this should be pretty simple to do, but I have been unsuccessful.

I would like to "seasonalize" annual data based on a percentage distribution assigned to each month.


I have the following data in my InfoCube

Sales Doc type: Product Group: Fiscal year: Fiscal year/period: Sales amount: Monthly%
TA: 101:2017:0000000: 40000, 0
TA: 101:2017:2017001: 0: 10
TA: 101:2017:2017002: 0: 20
TA: 101:2017:2017003: 0: 30
TA: 101:2017:2017004: 0: 40

I would like to distribute the 40,000 which is an annual amount to periods 01/2017 to 04/2017: 4000, 8000, 12000, and 16000 respectively.

Here's how I defined the planning function:

Fields to be changed: FY/Period
Fields for condition: FY, Key figure name, Product group, Sales doc type
Reference characteristics: FY/Period, Key figure name

The parameter group was defined as follows:
Conditions:
Key figure = 0AMOUNT
Sales Doc type = TA
Fiscal year = 2017
Product group = 1001

Reference data:
Key figure = ZMONTHPCT
Fiscal year/period = 001/2017 to 004/2017.

When I execute the parameter group, NOTHING happens. Can anyone suggest why my distribution is dead in the water?

Thanks,
Bob

PS: I have also attempted to solved this problem by using a planning function formula and also was unsuccessful with that approach; I think the issue is with a unassigned fiscal year/period 0000000. I have asked a separate question named BPS formula and how to reference a blank 0000000 fiscal year/period.

If I can get either of these approaches to work, I will cross post an answer so other users can benefit.