Course Hero Logo

Understanding BW Non Cumulative Concept as Applicable in Inventory Management Data Model.pdf

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 14 pages.

SAP COMMUNITY NETWORKSDN -sdn.sap.com|BPX -bpx.sap.com|BA- boc.sap.com|UAC- uac.sap.com© 2011 SAP AG1Understanding BW Non CumulativeConcept as Applicable in InventoryManagement Data ModelApplies to:SAP R/3, SAP ECC 6.0 and SAP BI NetWeaver 2004s. For more information, visit theBusiness IntelligenceHomepage.SummaryThe concept of Non Cumulative is complicated. Tried my best to explain the same with suitable examples.This page will help us to give understanding of OLAP Processing for Non Cumulative.Author:Vipin ACompany:CognizantCreated on:18 July 2011Author BioVipin is currently working with Cognizant as BW Senior Consultant. He has more than 4 years of experiencein BW and 2 years of experience in ABAP
Understanding BW Non Cumulative Concept as Applicable in Inventory Management Data ModelSAP COMMUNITY NETWORKSDN -sdn.sap.com|BPX -bpx.sap.com|BA- boc.sap.com|UAC- uac.sap.com© 2011 SAP AG2Table of ContentsDefinition.............................................................................................................................................................3Features of Non-Cumulative:..............................................................................................................................3Key Concept:......................................................................................................................................................3Working of Non Cumulative (Explaining with an Example):...............................................................................3Query Execution:................................................................................................................................................4Important Key Figures:.......................................................................................................................................5Content on 0IC_C03 cube via Listcube using RECORDTYPE: 1......................................................................6Analyzing the query 0IC_C03/0IC_C03_Q0030.................................................................................................7Technical Side of Non Cumulative:....................................................................................................................9Related Content................................................................................................................................................13Disclaimer and Liability Notice..........................................................................................................................14
Understanding BW Non Cumulative Concept as Applicable in Inventory Management Data ModelSAP COMMUNITY NETWORKSDN -sdn.sap.com|BPX -bpx.sap.com|BA- boc.sap.com|UAC- uac.sap.com© 2011 SAP AG3DefinitionNon-cumulative values are those key figures that are measured in relation to a period of time; that is to saythey cannot be meaningfully cumulated over time. Non-cumulative values are summarized over time usingso-called exception aggregation.In RSD1 you can see that 'normal' key figures are assigned to such a non-cumulative key figure whichdescribes the Inflow and Outflow (or the value change (delta)). In the query the ncum key figure is thencalculated (for the requested days) by taking the data given by the key figures Inflow and Outflow.From a technical point of view the handling of Non Cumulative key figures is very different in comparison tocumulative key figures. The values are only calculated during query runtime and not stored at all in the facttables. That‟s why you can‟t findthis key figure in the transaction LISTCUBE. The technical infoobject0RECORDTP (in the package dimension) was introduced only for Non Cumulative.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 14 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
SAP AG, SAP R 3, SAP ERP

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture