Adding a Dimension like a Qualifier/Grouper – Best way in script?

[#1]

Hi! This is mi situation:

I have 3 Dimension (Especie, Variedad, CalibreStd. See table below). I need to add an extra dimension that Works like a qualifier/grouper of the CalibreStd dimension.

CalibreGrupo	Especie	Variedad	CalibreStd
1- 56-60	MANZ	ROGA	56
1- 56-60	MANZ	ROGA	60
2- 70-80	MANZ	ROGA	70
2- 70-80	MANZ	ROGA	80
3- 90-110	MANZ	ROGA	90
3- 90-110	MANZ	ROGA	100
3- 90-110	MANZ	ROGA	110
4- 120	MANZ	ROGA	120
5- 135	MANZ	ROGA	135
1- 56-60	MANZ	_default	56
1- 56-60	MANZ	_default	60
2- 70-80	MANZ	_default	70
2- 70-80	MANZ	_default	80
3- 90-110	MANZ	_default	90
3- 90-110	MANZ	_default	100
3- 90-110	MANZ	_default	110
4- 120+	MANZ	_default	120
4- 120+	MANZ	_default	135
1- 56-60	PERA	_default	56
1- 56-60	PERA	_default	60
2- 70-80	PERA	_default	70
2- 70-80	PERA	_default	80
3- 90-110	PERA	_default	90
3- 90-110	PERA	_default	100
3- 90-110	PERA	_default	110
4- 120+	PERA	_default	120
4- 120+	PERA	_default	135

The most practical way to maintain this data is specifying a default configuration (“_default”) for each Especie and specifying particular cases like Variedad=ROGA.

I need to know the best way to load this in script.

I thought add a key with 3 dimensions concatenation and use “ApplyMap” like this:

Key1->Especie|VariedadCom|CalibreStd

Key2->Especie|_default|CalibreStd

ApplyMap('MAPCalibreStdGrupo',Key1,Key2)

That’s works, but the problem is that if in the future the definition change (for example, adding a 4^th or 5^th dimension) this way is impossible to maintain.

So, how can I do that in the best way avoiding add ALL VALUES in the table. I need to avoid that because there are a lot of registriess and some dimensions grow dynamically and will be out of synch.

Thanks

[sunny_talwar]

What is the logic behind these ranges that can dynamically grow? If they follow a some kind of logic, we might be able to make it work

[#3]

Hi! There is no logic. It depends the season, because we are talking about fresh fruits (that every season change) and because some years some "Calibre" are more important than other and they need to change de grouping.