Skip to Content
avatar image
Former Member

Stock extraction into BI reports

Hi and happy New year to all,

we are on SAP BI 7.0, and I have a question with regards to stock on our reports.

One of our reports displays the current stock by manufacturer and material as well as the previous 12 months sales quantities.

This is broadcast each day to customers via email.

The stock on the report is coming from Data Source 2LIS_03_BF into our inventory Cubes via DSO.

0TOTALSTCK is being used to derive the stock quantities on the reports and it is a Non Cumulative with inflow and Outflow.

I am having an issue with the performance of the query.  As one of the cubes is extremely large, I am assuming that the query takes a very long time to run, as it is has to read the full cube in order to determine the 0TOTALSTCK using the inflow and outflow, please correct me if I am wrong.

We are also extracting data from the table MARD, and this information is loaded into navi attributes of our 0MAT_PLANT info obect.

As a result, I am now looking at the option of creating another version of the query, and removing the 0TOTALSTCK key figure,

and replacing with the appropriate navi attributes from 0MAT_PLANT using formula variable with a replacement path on the navi attribute.

I know this also will have to retrieve the navi attribute at query runtime, however I am assuming it will be much quicker than determining 0TOTALSTCK.

The only downside I can see of this approach is that the report will only display the stock holding as of last extract, and not allow to see stock holding for e.g. two weeks or 1 day before, this shouldn't be a problem as the report goes externally to customers.

Does anyone else see any problems with this approach e.g. data integrity, performance etc.

Look forward to your replies,



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2015 at 12:42 PM

    Hi Shane,

    Maybe an alternative could be the so-called Snapshot Scenario. Please refer to document How to Handle Inventory Management Scenarios in BW (NW2004).

    I also would like to recommend you to review SAP Note 419490 - Non-cumulatives: poor query performance for 5 performance tips.

    Best regards,


    Add comment
    10|10000 characters needed characters exceeded