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:
Key figure = 0AMOUNT
Sales Doc type = TA
Fiscal year = 2017
Product group = 1001
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?
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.