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

Key fields in a cube?

Hai all,

If we have an invoice, in ODS, its can be uniquely identified with a key(combination of, for example, company code, customer, sales district etc.)

But how can we identify a unique invoice in Cube.

I know that the basic model of ods is table and that of cube is multidimenational. The reason why I am asking this question is to clarify how two invoices get added up in the cube. For example, there is an invoice in the cube, with some amount 50, that was loded in a previous load and if a residual invoice comeup, with say 10,in the next load. Then in the cube they shoud get addedup showing 60. Or do they still appear distinct, in that case again the query, how can it report on a particular invoice? How does the system know that its the residual of the precious one. in ODS, its by the key, but in cube by what?

Thank you very much.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2005 at 03:26 AM

    Hi Visu,

    As a Thunb rule that we follow ..

    The Keys in the ODS are made the different dimensions of the cube..

    Say If you have 5 invoices for a particular vendor..

    If you have the vendor as the lowest granularity in the Report the value of invoices are aggregated..If you pull in the invoices as well the individual values are displayed...

    In the cube if you have the Key same comming from the ODS the value will get added up..

    If a residual invoice comes up at a later point say a different date the invoice will be shown seperately in the report if you have the date in there too..

    If not it will be aggregated at the invoice level..

    Hope It helps

    Ashish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2005 at 03:48 AM

    Hi,

    <i>If we have an invoice, in ODS, its can be uniquely identified with a key(combination of, for example, company code, customer, sales district etc.)</i>

    Do you mean to say that there will be only one invoice to a unique combiantion of company code, customer, sales district etc.

    In general, it is wrong.I hope , you will be having lot of invoices for this combination. So it is better to take invoice into key fields of ODS. Other wise ,if you take invoice into data field,it will be overwritten.

    <i>But how can we identify a unique invoice in Cube.</i>

    To identify the invoice in the cube you have to include it into one of the dimensions. To get data for this field you have to take Invoice as part of key figure in ODS also.

    With rgds,

    Anil Kuamr Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 25, 2005 at 10:24 PM

    Hi!

    we can assume that every charecterstic in the cube is part of key. all the charectrers combinely formas a key and hence the values dont mix up. even the same transaction have different key figure values at different times then they dont mixup. if we want a unique value from a cube then we need to know all the charecterstic values that represent the key figure.

    with regards

    ashwin

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Though, different records (even with the same invoice number) may be distinguished in the cube, as you pointed out, during a report run these invoice amounts might sum up. To prevent this you need to specify some other information, for example Movement Type, or Document Type, or something else. It is done very often in SAP applications. In SD you have invoices, returns, debit and credit memos etc.

      I'd propose do not mix up with different by meaning amounts. I mean if you post some invoice amount, do not post a residual value of the invoice. You'd rather post 40 as some kind of reconciliation, or partial payment, or delivery etc. In this case all amount are of the same nature (cumulative) and using distinguish parameter (Document type) you can easily build reports you want.

      Best regards,

      Eugene

      Message was edited by: Eugene Khusainov

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.