Search This Blog

Monday 13 February 2012

BW InfoProvider Design Specifications- (0SD_C03) - Sample



InfoProvider Identification

InfoProvider Name:
InfoCube:  0SD_C03 – Sales: Overview
Standard/Custom:
Standard
Business Content        
Std.Business Content
w/ Modifications         
Custom        
Module(s):
CO 
FI 
HR 
MM 
PM 
PP
SD
PS 

Other (specify):



Document History
Created By:

Date Created:

Approved by:

Date Approved:

Change History (To track changes to Request spec. after the specifications have been approved)
Date Modified
Modified by
Brief Description of Change
Approved by
Date Approved























Sample Data Flow



1.   Business Content Installation
1.1. R/3: Data Transfer to the SAP Business Information Warehouse
1.1.1.             Classification:
Standard Business Content                                                   
Standard Business Content w/ Modifications              Refer to: __________
Custom                                                                     Refer to: __________

1.1.2. In each of the designated source systems, transfer the following DataSource(s):
DataSources:     2LIS_11_VAHDR
2LIS_11_VAITM
2LIS_11_V_ITM
2LIS_12_VCITM
2LIS_12_VCHDR
2LIS_13_VDITM
2LIS_13_VDHDR
                       
Source System:
F Box   (Development Client TBD)         
            G Box   (Development Client TBD)         
            E Box   (Development Client TBD)         
Note:  This assignment has been activated per standard business content.  No modifications have been made.

Use R/3 Menu Path:
Data Transfer to the SAP Business Information Warehouse à Business Content DataSources à Transfer Business Content DataSources

1.2. BW: Set up InfoSource / DataSource Assignment
1.2.1.             Classification:
Standard Business Content                                                   
Standard Business Content w/ Modifications              Refer to: __________
Custom                                                                     Refer to: __________

1.1.1.             Modeling: Source Systems: Replicate the DataSources of the following Application Components:
Application Component(s): Sales & Distribution
1.1.2.             In each of the designated source systems, assign the following DataSource - InfoSource relationships:
DataSource                               InfoSource
2LIS_11_VAHDR                       2LIS_11_VAHDR
2LIS_11_VAITM                        2LIS_11_VAITM
2LIS_11_V_ITM                         2LIS_11_V_ITM
2LIS_12_VCITM                        2LIS_12_VCITM
2LIS_12_VCHDR                       2LIS_12_VCHDR
2LIS_13_VDITM                        2LIS_13_VDITM
2LIS_13_VDHDR                       2LIS_13_VDHDR

Source System:
F Box   (Development Client TBD)         
            G Box   (Development Client TBD)         
            E Box   (Development Client TBD)         

1.1.3.             Install the Transfer Rules and Communication Structure.
Note: This assignment has been activated per standard business content.  No modifications have been made.

1.2. Activate InfoCube: 0SD_C03
1.2.1.             Classification:
Standard Business Content                                                   
Standard Business Content w/ Modifications              Refer to: __________
Custom                                                                     Refer to: __________

1.1.1. From the Business Content area of the Administrator Workbench:
1.1.1.1.                  Set ‘Grouping’ to:
Only Necessary Objects                                   
In Data Flow Before                              
In Data Flow Afterwards                        
In Data Flow Before & Afterwards                 
           
1.1.1.2.                  Set ‘Collection Mode’ to:
Collect Autmatically                              
Start Manual Collection                                  Refer to: __________

1.1.1.3.                  Insert the following object(s) for Collection:
Object: 0SD_C03
1.1.1.4.                  Install
Note: This object has been activated per standard business content.  No modifications have been made.

   Dimensional Model (Include InfoProvider, master data, related ODS, and related aggregated cubes)

10 comments:

  1. Thanks for the nice info.
    But can you illustrate more about the steps for activating the setup tables corresponding to the cube 0SD_C03.
    Correct me if I'm wrong:
    1) RSA5 - Activate all related Data Sources mentioned above
    2) RSA3 - Check DS
    3) RSA7 - Make sure no delta activated
    4) SBIW - Fill in setup tables and select everything related to SD to fill 0SD_C03
    5) BI site...

    I'm not sure exactly whats in step 4
    please specify more

    Thanks

    ReplyDelete
    Replies
    1. Hi Heba,

      Please follow this document
      http://scn.sap.com/docs/DOC-12007

      It explains LO extraction in detail.

      Regards,
      Anjali

      Delete
    2. Thanks so much

      Regards,

      Delete
  2. Hi Anjali again,

    I'm wondering if you have a documentation for COPA cubes like the great one you've uploaded for SD?

    Thanks

    ReplyDelete
    Replies
    1. Hi Heba,

      I only have the documention published in SDN

      http://scn.sap.com/thread/1243577

      Regards,
      Anjali

      Delete
  3. Hi Anjali,
    Great initiative I am really surprised after seeing your blog on SAP BI, I had gone lot of blogs but the information you are given in the site is awesome. I was searching for the 0SD_C03 installation in google none of them had given the proper information. I found this info is very useful.
    Thanks

    ReplyDelete
  4. Hi Anjali,

    I am trying activate the ddata sources as given in the digram and is there any sequence of data load should I follow. Ex: 2lis_11_vaitm....vcitm
    I mean should I follow any sequence of data source loading to the targets in the BW

    ReplyDelete
  5. Hi Bala,

    Thanks!!! As far as I know, you need to follow a sequence while loading Inventory DataSources only....So go ahead!

    Regards,
    Anjali

    ReplyDelete
  6. Hi Anjali,

    Do you have any SAP BI business scenario's or any demo models to do some practice.
    Thanks,
    Prince

    ReplyDelete
  7. Hi Anjali,
    Thanks for sharing your knowledge and i have a question on Data flow shown on above.
    1.Do we have standard BI Content Info providers for Delivery
    Document, Billing Documents.

    Thanks
    Vijay

    ReplyDelete