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

Update Rule/Start Routine to affect all data in cube

My situation is such that delta causes incorrect total revenue in a report

Scenario:

First Time an order is inserted with a field PFUNC in BW as blank.

There’s a change on order with additional revenue +

PFUNC of the order is now = “YF” and is captured in another ODS. Update Rule (routine) for PFUNC in the cube takes the value from ODS.

Report is filtered on PFUNC = “YF”

Problem: So it only shows Revenue that comes with Delta (added revenue). Total revenue missing in report.

I need to show all revenue. Full load is ruled out. “YF” filter has to stay in report cuz we don’t want all other PFUNC values in the report.

So the question is how do I achieve this? Suggestions will be generously appreciated. Lemme know if u need clarification.

Thanks

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 Apr 26, 2007 at 08:41 PM

    A few clarifications:

    Is PFUNC a key in ur ODS?

    PFUNC of the order is now = “YF” and is captured in <b>another ODS</b>

    what do you mean by another ODS? Is that the deltas are captured in another ODS? Or else we are talking abt two different ODS with there own set of data?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08:26 PM

    Remove the filter in the report.

    Is PFUNC is some status indicator?

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hi,

    yes your cube is recording the changes and keeping history of those fields...

    This happens to all scenarios where documents can be changed during time and are loaded into cubes.

    Alternatives:

    - having these fields as navigational attributes of the document header or docnr/itemnr or any other suitable char or compounded char. How many records are loaded in your cube?

    - have these fields as "key figure" of the ODS and update them with overwrite and report on the ODS itself (or create another one...)

    - during the cube update start routine you read the cube itself with a key (your order with or without item but you need to identify uniquely the records to be changed with your new filed value) and post the corresponding records in an internal table with the exact same structure than the cube. In one of your key figure you implement a return table functionality in order generate a reversal of the record to be changed as well as the new "image" (sum of all key figs of loaded record and original record) with the PFUNC value of the loaded record...

    Needless to say that the last option would be very sophisticated and somebody with some BI/ABAP skills should take care...

    As always, you're the one who evaluate options...

    hope this helps,

    Olivier.

    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.