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

value in infocube

Hi,

I am newbie to BW. suppose that i've a infoobject invoiced qty with a value 20 and i stored that in a cube yesterday. today i change that value to 40. what will the cube contents have.

thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2005 at 06:08 AM

    > Hi,

    >

    > I am newbie to BW. suppose that i've a infoobject

    > invoiced qty with a value 20 and i stored that in a

    > cube yesterday. today i change that value to 40. what

    > will the cube contents have.

    >

    > thanks

    so u have have changed means u have loaded into the cube with invoiced qty 40. so now cube contains two record with invoiced qty 20 and invoiced qty 40.

    so now the invoiced qty is 60.

    one thing u need to understand here the cube never overwrites the data it just aggregates the records, so during the reporting time, it will sum all these keyfigures which has same charecteristic values, and give it as one value,

    so i.e. why i have said it will load invoiced qty as 40 as another record, during reporting it will add these values and show it as 60.

    i think now u got it

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If you are using the LO-cockpit invoice extractors, they are smart enough to know to back out the previous day's qty of 40 and add the current days qty of 60. So you would have two records transfered on the second day one with -40 and one with +60. Your cube will aggregate these values with the +40 from the previous day and you get +60.

      If you are not using the lo extractors you must use an ODS to generate these deltas.

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.