Key figure modeling with different Unit of measures

[former_member195433]

Hi ,

I need load  the following table from flat file to DSO for staging purposes .  The table  has  below structure. How do i model a key figure that has different Uom .

Any suggestions ?  thanks

Identifier	Identifier description	Time	Org	plant	Measure
11	# of Orders	201401	BU1	A	136
11	# of Orders	201402	BU1	A	4672
1 1	# of Orders	201403	BU1	C	809
11	# of Orders	201404	BU1	B	4897
12	Amount	201401	BU2	A	35$
12	Amount	201402	BU2	A	41$
13	quantity	201403	BU1	B	45 kg
13	Quantity	201404	BU2	C	36 kg

[Thomas_Baer · Accepted solution]

Hi,

the data in your flatfile is arranged in the so called account model. It has only one key figure, the identifier tells you the meaning of the measure in the respective line.

In this case I would recommend to have 3 different key figures in the DSO. In a transformation you need to flip the data from account model to key figure model (populate the right key figure based on the identifier value).

[former_member195433 · Accepted solution]

Thomas ,

Thanks for reply

But if identifier column  might have 30 unique values .In this case do i have to create 30 keyfigures in DSO ?

[Thomas_Baer · Accepted solution]

You can (reduces number of lines in the DSO), but you don't have to. You can also go for a mixed model. You can still keep the identifier and assign the value to the right key figure. In this way you can get along with 3 key figures (without unit, with currency, with quantity unit).

[former_member195433 · Accepted solution]

Thanks thomas