Financial Management Blogs by Members
Dive into a treasure trove of SAP financial management wisdom shared by a vibrant community of bloggers. Submit a blog post of your own to share knowledge.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member181999
Contributor
1,523


About Business:

Client is Hi-Tech Product Sales & Service Leader (Mobile, I-Tab, accessories, etc,) Client has Internet sales and service division which is also call as a data generation area. Generating 5+ million business transactions/records per day in the systems (SAP + Legacy Systems). Business heads in the respective region should improvise the earnings based on the buying climate of the day by promoting time sensitive offers (Festival offers / Bundle offer / Offer to Stores).

 

Current Architecture:



Problem Statement:

Problem identified in the Internet Sales Data flow (Flow includes 5 Source System ---> BW(Staging Layer) --> BPC (Planning and Consolidation Platform))

  1. Data load 1 hrs (BW) + Data load 2 (BPC)

  2. BPC Data manager is taking 2 Hrs to complete the data load

  3. Daily 5 + Million records are landing the BPC model

  4. Business team have to wait for the availability of data @ reporting layer

  5. Only One Planning cycle / Business day


 

Root Cause: Internet sales BPC DM is taking 2hrs to complete the load. When we have a close look on the data & records in the models. The business needed records = 1 Million but the data load has 5+ Million records. So we saw a gap of 4 Million records unwontedly landing here.

We have following SAP BPC dimensions in model and their Data is as follows :

  1. Product Code =  PC_00_00 (Top Node)

  2. Product Code = PC001, PC002 and so on…..

  3. Data source = IS_DS, IS_ORA_DS, IS_ORA1_DS, IS_HADOOP_DS, IS_SAP_DS

  4. Time = Current day

  5. Flow =Flow01, Flow02 and so on . . .


 

Solution Approach: In Internet Sales Data Manager (BPC) introduced a dynamic filtering condition based on Script logic. If any change in the business. Business team will intimate the back-end. (Support team gets request for change on monthly basis).

 

Sample Code:

PRODUCT Code  *Logic to select only the need product codes Planning & Consolidation


*XDIM_MEMBERSET TIME = %TIME_SET%  *Select only user driven time


*XDIM_MEMBERSET PRODUCT_CODE <> PC_00_00 *Select the top node of the Product Hierarchy


*XDIM_MEMBERSET FLOW = Flow001, Flow002, Flow003, Flow004, Flow005, Flow006, Flow007, Flow008, Flow009, Flow010 * For us this Flow entities goes to 100 and varies weekly.


*WHEN DATA_SOURCE


*IS LOCAL_BUSINESS, IMPORT_ BUSINESS, REPACK_ BUSINESS


*ELSE


*REC(EXPRESSION = %VALUE%, PRODUCT_CODE = PC001, PC002, PC003, PC004)    * For us this Sale numbers goes  to 100 and varies weekly.


*ENDWHEN


*WHEN DATA_SOURCE


*IS IS_DS, IS_ORA_DS, IS_ORA1_DS, IS_HADOOP_DS, IS_SAP_DS * For us this Data Source numbers goes to 10 and varies weekly.


*ELSE


*REC(EXPRESSION = %VALUE%, PRODUCT_CODE = CC_BUSINESS_PRODUCT, DATA_SOURCE = LOAD_BUSINESS_PRODUCT_GAAP )


*ENDWHEN.


New Architecture




Achievements:

  1. Data load completing in 5 to 10 Mins.

  2. Now the data is available for BPC operations(Planning & Consolidation Models) in 1 Hr (Previously 4 Hrs with old process).

  3. Business team has an ability to do the planning and consolidation more strategically.

  4. Business enabled with 3 Planning cycles / Business day.


4 Comments
Labels in this area