Skip to Content
author's profile photo Former Member
Former Member

Data Modelling Question---Load into a Cube

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 02:51 AM

    hi Simmi,

    the doc

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

    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

    CUS PROD DAT---- 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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 12:16 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 12:17 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 05:26 AM

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

    Nagesh Ganisetti.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2007 at 09:26 PM

    As promised - check Olivier's msgs in this thread

    creating-two-records-in-bw-for-a-record-with-two-c

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.