Data Modelling Question---Load into a Cube

[Former Member]

In the Data Modelling Doc

"the update rules are defined for every key figure from the communication structure of the InfoSource, enabling one large transactional record with many key figures to be split into many records in the fact table with one key figure"

What would this mean?

If a Infocube has 10Key figures and 15 Characteristics, would every record load to the cube result in 10 records to be recorded in fact table.

Thanks

Simmi

[edwin_harpino · Accepted solution]

hi Simmi,

the doc

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6ce7b0a4-0b01-0010-52ac-a6e813c3...

p. 41

it's about partitioning attribute, where only one keyfigure exist in infocube

in the sample it's QTY (the 'infoobjects' are CUS PROD DAT ValType QTY)

where the data may come as

CUSPRODDAT----KF1QTY(for value type P)---KF2QTY(for value type F6)

C1---P1---199801-- 10----

---

80

in update rules, keyfigures is splitted, we can do in start routine something

data : new_data_package like data_package.

loop at data_package.

new_data_package-cus = c1.

new_data_package-prod = p1.

new_data_package-dat = 199801.

new_data_package-valtype = P.

new_data_package-QTY = 10.

append new_data_package.

new_data_package-valtype = F6.

new_data_package-QTY = 80.

append new_data_package.

delete data_package.

endloop.

data_package[] = new_data_package[].

so in infocube one record splitted to 2 records

CUS-PROD-DAT-ValType-QTY

C1 P1 199801 P 10

C1 P1 199801 F6 80

your question is if in infocube has 10 key figures,

--> no, in the context it's only one keyfigure

it's about partitioning attribute sample, not normal data modeling with many key figures.

hope this helps.

[Former Member]

As promised - check Olivier's msgs in this thread

[Former Member]

You will have only one record, Even though you are spliting the record. Record Value Splited but number count won't change.

Nagesh Ganisetti.

[Former Member]

What would this mean?

If a Infocube has 10Key figures and 15 Characteristics, would every record load to the cube result in 10 records to be recorded in fact table.

It depends upon for how many KF's you copy in the update rule(update rules - change - select KF - copy icon to the right most - that would be kf_1). If you just copy for one - the resultant records would be 10+1 and so on.

I believe a few months back there was a thread where Olivier explained the whole scenario amazingly, where you need to update a KF with 2 currencies. Thats the one of the most detailed thread I ever saw. (Olivier we miss you). If I find it I will update the thread.

[Former Member]

Since you have 10 key figs and 15 chars, every record in the fact table can have upto 10 key figures and 15 chars.

IF a record has only one key figure, then that record in the fact table will have only one key figure.

Ravi Thothadri