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

LO cockpit help

hi

I have deleted the data from Cube and PSA and Info package for an LO cockpit data source to make a fresh load in to BI (in sandbox)...Now I went to LBWG and deleted set up tables...and then filled the set up tables again...now when I load the init by running the infopackage its giving only 54 records...can any one tell me where am making the mistake ? Did I forget any step in ECC ?

Please advice...Just tell me how to reload the init ...FYI I have deleted the data from PSA and Info package scheduler as well....I need to load from ECC again

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 04, 2007 at 06:44 PM

    Hello Sam,

    Did you delete them init in the InfoPackage (via Scheduler ­> Initilization Options for the Source System) ?

    If you did, did you check if there are any filters in the InfoPackage?

    Otherwise, you could try to test the extraction and see if it comes from the source or from the bw side.

    Hope it helps,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:49 PM

    Check the base tables itself first to confirm the number of entries match,also after deleting the set up tables check in RSA3 to see if its completely deleted..

    More insights

    LOCOCKPIT

    Steps

    1)LBWG - Delete Set-up tables

    2)LBWE -->Application area(Purchasing)

    Activation of extract structures

    Click >Structure >Maintenance

    Click >Datasource >2LIS_02_HDR

    Click >Update >Active

    Click >Update Mode >Queued Delta

    Green light should appear on each extraction structures after all STEPS

    3)SBIW settings-based on Application area

    Inventory Controlling

    IMPORTANT - ORDER OF LOADING

    ALWAYS LOAD in order as BX datasource first then BF datasource and then UM datasource in cube

    a)SBIW >Setings for Application -specific Datasources(PI) >Logistics-->Settings:Inventory Controlling -->

    Select Determine Industry sector

    Select Transaction Key Maintenance for SAP

    Transaction key is used for Process key mappings w/t these the data would not load in to BW though it would come in PSA

    b)Select Stock Initialization or TCODE - MCNB

    Purchasing

    a)SBIW >Setings for Application -specific Datasources(PI) >Logistics-->Settings:Purchasing

    Select Determine Industry sector

    Select Transaction Key Maintenance for SAP

    4)Fill Set up tables

    SBIW >Setings for Application -specific Datasources(PI) >Logistics >Managing extract structures >Initialization >Filling in the set up table >Application specific setup of statistical data.

    OR

    OLI*BW -example for Inventory transaction is OLI1BW

    5)BW -Replicate datasources

    Loading data steps-

    1)LBWQ (Empty the queue by deleting the entries if its FRESH installation or Execute Job through Job control and empty the queue)

    2)LBWG (Delete set up tables)

    3)SBIW(OLI*BW) Fill set up tables ,use BLOCK check box

    4)Make an INIT from BW (Data now flows from LBWQ to RSA7)

    5)Set up a V3 update job in R/3 ,frequency daily/periodic

    Inventory Cube -

    1)Load BX datasource

    2)Load BF datasource (No checkmark on Marker update)

    3)BW - Compress cube with YES Checkmark Marker update

    4)Remove Check Mark

    5)Delta

    6)BW - Compress cube with YES Checkmark Marker update

    IMPORTANT -

    Note 691721 - Restoring lost data from a delta request

    Note 581778 - ODS capability of extractors from Inventory Management

    MB51 transaction to check the report

    LBWE - Lo Cockpit

    0inforec-is-not-included-in-2lis02itm-or-2lis02scl

    Note 396647 - FAQ: V3 update: Questions and answers

    SM13 usage Note 328181 - Changes to extract structures in Customizing Cockpit

    Note 602260 - Procedure for reconstructing data for BW

    Update methods - V1 ,V2,V3

    Gist of LO Cockpit Delta

    Hope it Helps

    Chetan

    @CP..

    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.