Sep 21, 2016 at 04:45 PM

Simple Master Data for Global Parameters

31 Views

Hi,

So I'm trying to create attributes / master data to store the parameters of a calculation.

Basically, I want to put "Number of Historical Periods", "Periods Offset" & "Multiplier" in a simple MD. For the users to be able to change them manually. I don't want to link these attributes to products or customers as it would be the same value for all possibilities.

So I have create a separate MD with all 3 attributes plus a "ParameterID" as the KEY:

ParameterID

HISTPERIODS

HISTPERIODSOFFSET

MUTLTIPLIERPCT

My first attempt was to add this MD to my planning level PERPRODCUST.

I then use the attributes directly in the calculation :

IF( "$$PERIODIDCU$$" - "PERIODID" < "HISTPERIODS" AND "$$PERIODIDCU$$" - "PERIODID" > "HISTPERIODSOFFSET", IF(ISNULL( "POSADJHISTBASELINEQTY@PERPRODCUST" ),NULL,1),NULL)

This does not work, the values are not passed throught the Attributes.

I then tried to create them as attribute as KF @CUST or @PERPRODCUST, but they are still empty.

My understanding is I could decide to put the attributes in my Customer master data, but then I would have to maintain de same values 1000 times.

Any suggestions ?

Thanks,

Marc