• RELEVANCY SCORE 3.73

    DB:3.73:Activate Data In Ods k3





    Hi Gurus,

    Im loading data from ods to ods thru full update and after that I have to activate that ODS,

    Kindly let me know the steps for activating the ODS,

    right click on the ods and press activate data n ods

    or before i have to do Update ods in data target.

    Raj

    DB:3.73:Activate Data In Ods k3


    hi

    yes i have to load to cube also

    raj

  • RELEVANCY SCORE 3.63

    DB:3.63:A-Ods To B-Ods Loading, Only B Activation Failed fk





    Hi,

    I am trying to load data from ODS to ODS. now my first ODS successfully loaded activated. But in second ODS loaded, but activation failed due to special characters. May I know why its not failed in my 1st ODS for the same records.

    ThanksRegards,

    Sivaram

    DB:3.63:A-Ods To B-Ods Loading, Only B Activation Failed fk


    Hi Sivaram,

    I guess you are using B DSO as Direct update DSO where in you are not able to find the SID option. Please check.

  • RELEVANCY SCORE 3.57

    DB:3.57:What Is Delta Loading In Ods dp





    What is Delta Loading in ODS.

    DB:3.57:What Is Delta Loading In Ods dp


    It's the functionality that allows you to load only "modified" (and new) data since last loading ...

    Best Regards

    GFV

  • RELEVANCY SCORE 3.54

    DB:3.54:Can We Execute The Reports On Ods/Cube When We Are Loading/Archiving fc



    Hi Friends,

    Can we execute the reports on particular ODS/InfoCube in the following cases

    1) When the data is loading into that ODS/Infocube.

    2) When we are Archiving the data from that ODS/Infocube

    Thanks Regards,

    Shaliny. M

    DB:3.54:Can We Execute The Reports On Ods/Cube When We Are Loading/Archiving fc


    1) When the data is loading into that ODS/Infocube.

    Yes. You can. But the data is getting loaded will not be visible in the report

    Ravi Thothadri

  • RELEVANCY SCORE 3.53

    DB:3.53:Getting Sid For Ods Object Zofigl02 ac



    Data is loading through process chain. I am getting the error while getting sid for ODS.

    If I go on detail tab

    Getting Red mark. Below is the msg

    Activation of data records from ODS object ZOFIGL02 terminated

    DB:3.53:Getting Sid For Ods Object Zofigl02 ac


    HI

    Try to reactivate it manually.

    Regards,

    chandra.

  • RELEVANCY SCORE 3.46

    DB:3.46:Loading xj



    how data from ods to cube can be loaded , what i have to do for this, its very urgent.

    points will be assigned

    DB:3.46:Loading xj


    hi

    if you are using BI7. create *tranformation *

    for this data has tobe need successfully update till PSA.

    right click on cubecrete tranformationgive source of tranformation(DSO). in the next screen give the mapping for the elements. activate it

    once it activated come out from tranformation screen.

    click on DTP data transfer process--create DTPin the next screen select mode of extraction full/delta--goto to execute tab and execute the DTP

    mahesh

  • RELEVANCY SCORE 3.44

    DB:3.44:Data Duplication Problem While Loading Data From Ods To Cube am



    Dear Friends,

    I am facing duplication of records while loading data from ODS to Cube.

    I have used datasource 0FI_AP_3 to load data to ODS (daily delta) and the ODS data is loaded to Cube (daily delta).

    The data (288000 records) from ODS to cube has loaded and compressed.While loading the next delta ODS has loaded about 100000 records to cube. In this 10,0000 records I have found that the records loaded in the previous delta (288000) also have included causing the duplication problem. This request is not compressed.

    My question is

    Why ODS is requesting the records of previous Delta and loading the same to Cube ?

    Thanks in advance and your points are assured ?

    Regards

    Prasad.

    DB:3.44:Data Duplication Problem While Loading Data From Ods To Cube am


    Dear Mahadev Prasad K.M ,

    Just check it out it The "Record Mode" of your ODS.There are different record modes like A,D,X,N,R

    Besides there is no chance to fetch the last Delta when Delta

    was successful.

    So just check it out whether your delta was successfull.

    And also check it out in IP that ur init for delta source is available.

    You can do by going IP settingd menu bar environment -- init option for delta source..

    Try to create new if its damaged.

    Revert back to me if you have any quries

    Regards

    Bala

  • RELEVANCY SCORE 3.44

    DB:3.44:Request Invalid For Ods p7



    Hello gurus,

    My PC failed, tried to run by FM, it skipped loading the next ODS from IP. Tried running IP manully, Now i see Records arrived with QM status RED.

    Error message :

    requ** has not correctly updated

    Activation ods terminated

    Now how will i correct the request and activate ODS.

    Please suggest me

    Ponts Guaranteed.

    DB:3.44:Request Invalid For Ods p7


    HI Mahesh,

    Please check the requ** in t-code rsrq . and check whats the status . If it is loading to multiple data targets and not updated correctly in any of the data targets then it will through this type of error .

    so check the request and act accordingly

    Regards

    Venkat

  • RELEVANCY SCORE 3.44

    DB:3.44:Getting Error Message While Loading Data From One Ods To Another Ods 88


    Hello,We are getting error message "No active update rules exist for this infosource" while loading data from one ODS to another ODS.We have checked the update rule and it is active. Data is getting loaded upto PSA but not getting loaded into the targets ODS and we are getting above mentioned message.Please let me know if anyone has faced this problem.Regards,Sanjay

  • RELEVANCY SCORE 3.44

    DB:3.44:Delete The Request In Ods cj



    Hi Experts,

    In my scenario data is loading from base ODS to different data (full load)targets (data mart interface) is going on.

    Loaded one request from PSA to Base ODS but not activates while loading data from base ODS to different data targets.

    Can we delete the request(not activated) while loading different data targets?

    Thanks

    Bala

    DB:3.44:Delete The Request In Ods cj


    Data mart picks the data from activated tables only.

    I think there is no problem with new data table(it is not participating in the data mart process).

    can I delete the job(deleted request processing)?

    is it effect on data mart loading?

    Thanks,

    Bala

  • RELEVANCY SCORE 3.41

    DB:3.41:Two Ods Are Succefully Loaded But Third Ods Get Failed?Why f1



    HI

    Can you help for my problem.......

    Three ODS's are loading from single infopackage.first two ods are

    successfully loaded but third one get failed.the loading is done

    through INIT Updation.how can i load the data to the failed ods

    with out disturbing the other two ODS. HOW? AND WHY?

    Regards,

    Hameed.

    DB:3.41:Two Ods Are Succefully Loaded But Third Ods Get Failed?Why f1


    Hi,

    you can create another infopackage for the particular ods from the infosource.

    delte the failed request from the ods, and schedule the new infopackage.

    Otherwise, you need to uncheck the first two ods fromt the existing infopackage( in infopackage 'Data Target' tab) and you can scheddule it. after loading you can again check the checkboxes for the first two ods inthe infopackage.

    Hope this will be helpful.

    rgrds,

    v.sen

  • RELEVANCY SCORE 3.39

    DB:3.39:Loading In To Ods 8j



    Hello Experts

    This question might sound stupid but I wanted to clear my mind.

    I have to load a ODS A from two other ODSs B and C. Now if I define a field Sales Doc as the key to ODS A and create a transfromation from the ODSs B C to ODS A, does it implies that only those records will be loaded in ODS A which are common to both ODS B and ODS C (Sales Doc is also the keys for B C). If not, how could this be achieved?

    Thanks,

    Rishi

    DB:3.39:Loading In To Ods 8j


    Hi Rishi,

    Suppose if you have loaded some sale docs from ODS B to ODS A and now when you are loading from ODS C to ODS A if there are some sales docs from ODS C which are already loaded in ODS A from ODS B then in such case records will either get over written or added depending on update type you have chosen for sales doc key field.

    And it this overwritting or adding not only depends on Sales Doc field it also depends on other key fields which you have used.

    If you would only like to load common sale docs you can think of using some routine.

    Regards,

    Nilima

  • RELEVANCY SCORE 3.39

    DB:3.39:Ods Load From Psa 79



    Hi,

    I am loading ODS "A" from infource "Z". After that i am loading other data into Same ODS "A" then I want to load Z infosource data which previously loaded into ODS "A" into Another ODS "B" from PSA. how can i do that. I want to include this step in process chain. how can i do this.?

    Regards

    Rajini

    DB:3.39:Ods Load From Psa 79


    It is not clear as to what your difficulty is. There is a process for loading PSA data into data target.

    - Create an InfoPackage to bring the data only up to PSA

    - In your process chain, insert the InfoPackage process

    - Then the next process is to load from PSA to DSO A

    - DSO A activation process

    - Next process is to perform second load into DSO A

    - Activate DSO A again

    - Process to load from PSA to DSO B

    - Activation of B

    It will help if you specifically explain what the difficulty is.

  • RELEVANCY SCORE 3.39

    DB:3.39:Ods To Cube kx



    hi

    what is the advantage of loading data into CUBE from ODS , instead of directly loading data to cube..

    I know the procedure.. that how to transfer the data from ODS to CUBE.. but i want the exact situation... where we are using both ODS and CUBE.. and why we need to transfer the data from ODS to CUBE..

    thanks in advance

    prakash

    DB:3.39:Ods To Cube kx


    Hi Prakash,

    You can directly load the data into infocube but It is always best practice to use ODS before infocube(In most scenarios).

    ODS is useful for detailed reporting (Data granularity).

    We can store all the consolidated and cleansed data in ODS level and update to cubes, if you have requirement of deleting data from infocube, then you can delete the data from infocube and reload the data from ODS without extracting data from source system.

    Some datasources (example: 0FI_GL_4, 0FI_AP_4, 0FI_AR_4 ) use an After Image delta so this delta method is not suitable for direct InfoCube update, in this scenario,ODS object is obligatory to determine the delta for InfoCube update

    There is a lot on EDW. Check here:

    https://www.sdn.sap.com/irj/sdn/docs?rid=/webcontent/uuid/e1859e4e-0a01-0010-c099-c247943aef37 [original link is broken]

    Hope it helps.

    Best Regards,

    VK.Siddu

  • RELEVANCY SCORE 3.38

    DB:3.38:Error In Loading Delta Request To Ods a3



    Dear All,

    i am not being able to load data from ODS to another ODS and Cube. It is saying "the last delta update was incorrect therefore, no new delta update possible".

    i guess i need to delete the old delta update request.

    can you all help me. its a bit urgent.

    DB:3.38:Error In Loading Delta Request To Ods a3


    Hi Anup,

    try to change the request (REQU_CGSYNH9QR02W5WZOQBDPTHP99)status to red in the monitor and then check this request has been deleted from the targets where ever it has been loaded...

    Did this failed requet fetched any records in that or its only with Zero records?

    based on that u need to look for the repeat of last delta.

    Do let me know in wich version that u are working in?

    Assign points for the useful answers to keep this forum active..

    thanks

  • RELEVANCY SCORE 3.38

    DB:3.38:Need Suggestion To Get Data From Change Log Table Of Ods. jd



    Hello,

    There is a case where i am loading opportunity header data from header ODS and opportunity item data from item ODS in the opportunity cube.

    Status (1= OPEN, 2= WON ETC) of the opportunity are available only in header ODS and not in item ODS.

    While loading data from header ODS to cube, I am loading it directly but while loading data from item ODS to cube i am using active data table of header ODS as a lookup in the update rule from item ODS to cube. I am selecting status from the active data table of header ODS while loading data from item ODS to cube.

    Since active data table will have only after image records, there is some data mismatch in the report as i am selecting data from active data table of header ODS while loading data from item ODS to cube.

    I need to select data from Change log in order to get before image also instead of active data table in order to overcome this issue. Is there any way by which i can do selection from Change log instead of active data table as change logs are generated at run time.

    Please let me know if you have any suggestions.

    Regards,

    Sanjay Chaurasia.

    DB:3.38:Need Suggestion To Get Data From Change Log Table Of Ods. jd


    Hi ,

    If your DTP extraction mode is delta and if you have defined it on the active table of the DSO. Only for the first time(i.e the first run of the DTP) the data will be fetched from the active table. From next time onwards the data will be fetched from the change log.

    Regards,

    Adarsh Mhatre

  • RELEVANCY SCORE 3.38

    DB:3.38:Regarding Delta Load From One Ods To Another Ods(Very Urgent) ma



    Hi BW gurus,

    I have a query like while loading delta load from one ODS to another ODS , we are getting error like

    ODS object YRV_O01 was built incorrectly. Cannot update request

    REQU_DQZEAH1QZKNYTJ9RN2I8IBY3K(1,012,023).

    Here source ODS is YSV_O07 and target is YRV_O01

    please give your valuable solutions. It is very urgent.

    Regards,

    Gowri.

    DB:3.38:Regarding Delta Load From One Ods To Another Ods(Very Urgent) ma


    Hi Gowri,

    Your ODS is getting Delta updates, in between your delta requests you did a Full Update load REQU_DQZEAH1QZKNYTJ9RN2I8IBY3K(1,012,023).

    So its not allowing you to activate the ODS.

    Delete the above request from the ODS, if you want to do full update between delta updates use the "Repair Full Update" option, you won't get the above error,

    Please let me know if you still have the same issue,

    Kindest Regards,

    Surya.

  • RELEVANCY SCORE 3.35

    DB:3.35:Ods 2 Cube Scenario 1k



    HI,

    Is there any diff bt reconstruction repeat delta when v r loading from ODS to cube.

    As we know the data transfer method from ODS to CUBE is PSA. So I guess that there is another PSA table getting formed bt ODS Cube. So when v do reconstruction y is not da data getting picked from da PSA (bt ods cube).

    can u ppl explaain with a scenario from inventory.

    thnks in advance

    DB:3.35:Ods 2 Cube Scenario 1k


    Hi Prasad,

    To do a reconstruction for a particular request you need to have the data in PSA, from where the records will be read and will be passed through to the data target.

    repeat delta is something where the immediate delta load fails due to some reason and we force the system to pull the records for the previous request.

    I hope it is clear.

    regards.

  • RELEVANCY SCORE 3.35

    DB:3.35:Deleted Request zd



    Hi,

    I am loading the data from ODS to Cube, i deleted the ODS request without deleting of data mart request, how to get the delta now???

    Tnks

    Sudha

    DB:3.35:Deleted Request zd


    Sudha,

    There is a confusion here.

    Make it clear if you uploaded the data to the cube which you have deleted from the ODS?

    If NO then there is no problem you load the data to ODS and then to Cube.

    If YES then check if your deleted request in the ODS is in reconstruction tab. If yes then reconstruct the request. Then delete your old init request from the infopackage under the scheduler option and then run the init without data transfer from ODS to Cube. This should resolve your issue.

    Regards

    Rohini

  • RELEVANCY SCORE 3.34

    DB:3.34:Duplicate Data Records Error d3


    HelloIO is updated from ODS. System generates an error : duplicate data records.This is because keys of ods dont match keys of infoobject.I can build an other ods to aggregate data before loading to infobjects.Are there any ways to do it in start/end routine? Thanks

    DB:3.34:Duplicate Data Records Error d3

    there is Handle duplicate recors option in DTP Indicator: Handling Duplicate Data RecordsUseIf this indicator is set, duplicate data records (that is, records with the same key) are handled during an update in the order in which they occur in a data package.For time-independent attributes of a characteristic, the last data record with the corresponding key within a data package defines the valid attribute value for the update for a given data record key.Issue solved Thanks a lot !

  • RELEVANCY SCORE 3.34

    DB:3.34:Loadin Master Data Attribute From Ods 7a



    Hi experts,

    I have a Master data as Infoprovider:

    CASE with attributes at1 and at2.

    I loading master data.

    Another infoArea, I have and ODS ( case, field1, field2) that is loading with DELTA.

    After loading the delta, I want to update the AT2 from CASE master data.

    Which is the best option to loading an attribute from ODS? FULL? DELTA? What happend if the duplicate key error appears??

    I believe that with a DELTA Update from ODS to CASE will not be an error.

    thanks a lot!

    DB:3.34:Loadin Master Data Attribute From Ods 7a


    Hi,

    I dont think so there sould be problem in further update from ODS to Attribute.

    It would be better to keep the Delta in Further update.

    Regards,

    Sharayu

  • RELEVANCY SCORE 3.33

    DB:3.33:Delete Request From Ods 19



    Hi Gurus,

    suppose some requests are loaded in ODS and from ODS those requests are loaded into INFOCUBE. Now can i delete the request from the ODS.

    suppose if requests can be deleted then will there be any problem for the data in infocube for next time loading?

    suppose if requests can be deleted then can we get back those requests to ods again.

    Thanks,

    Ram

    DB:3.33:Delete Request From Ods 19


    Hi,

    If you want to delete requests that have already been updated in connected data targets, you have to adjust the connected data targets manually.

    Procedure

    ...

    1. In the administration of the data target, choose the tab page Requests. For your request to be deleted, choose Data Mart Status for the Data Target. The following dialog box displays the request that was updated in additional data targets. Keep the description of this request in mind.

    2. Choose Monitor on this dialog box. You arrive at the monitor for this request.

    3. Choose Manage Data Targets. You arrive at the administration for the connected data targets.

    4. Delete the respective request.

    5. This takes you to the source ODS object administration screen.

    6. Reset the delta administration. To do this, choose Data Mart Status for the Data Target and from the subsequent dialog box, choose Reset Delta Administration.

    7. Now you can also delete the respective request from the source ODS object. You can now load data as full or data again.

    bsuppose if requests can be deleted then can we get back those requests to ods again/b

    u can use reconstruction tab of the ODS

    Hope its clear.

    shylaja.

  • RELEVANCY SCORE 3.33

    DB:3.33:Error While Loading Data From Ods To Cube c3


    Hi,I am loading data from flat files to my ODS.While loading Data to ODS it is not giving any errorBut everytime i load data from ODS to Cube I get an error" Error occurred in the data selection ".though i have not specified any selections.

    DB:3.33:Error While Loading Data From Ods To Cube c3

    Hi Sachin,I think the flat file structure is not corresponding to your transfer structure. Check that. Also are you bale to preview the file in the infopackage.ByeDinesh

  • RELEVANCY SCORE 3.33

    DB:3.33:Question About Delta 37



    I have ods objects and data loading from flat file. I want to realize delta for removing deleted records using ODS. Is there an example of such update rule. This update rule should check whether a record exist in source file. If not mark ODS record for delete.

    DB:3.33:Question About Delta 37


    Sorry I did not undertand the question

    Message was edited by: Oscar Romero

  • RELEVANCY SCORE 3.33

    DB:3.33:From Ods To Cube 11



    Hello,

    If Loading from an ODS to a Cube, Should the Fields that are in ODS Match that of the Cube?

    DB:3.33:From Ods To Cube 11


    Hi,

    That is not a reqt. You do not have to have all fields of the ODS mapped tothe update rules of the cube. Also the names can be different.

    Hope this helps...

  • RELEVANCY SCORE 3.33

    DB:3.33:Rfc Error mk



    Hi,

    While loading from ods to ods or ods to cube(ie..within bi system) the trfc is hanging with error status'name or password error'....

    plz tell me what to do???

    DB:3.33:Rfc Error mk


    Hi Jasil,

    Did u check with PARRTNER PROFILES. TX - WE20

    O/b Parameter : RSRQST

    I/B Parameters RSINFO

    RSSEND

    Regards,

    Vijay.

  • RELEVANCY SCORE 3.33

    DB:3.33:No Data Is Loading To The Ods Although Transfered Records Are There jk



    Hi All,

    I have an issue.Am working in prod and we are loading delta records from 2 ODS to 3rd ODS...In the lower ODSs data is getting loaded but from one of these ODS data is transfered to the top ODS but no data is getting loaded into the top ODS. the status is also yellow and there is no job for this SM37 and SM50.

    i have manually activated this ODS but still it is showing data processing (from a long time)...How can this problem be solved?

    DB:3.33:No Data Is Loading To The Ods Although Transfered Records Are There jk


    DK,

    If you can confirm there is no corresponding work process running for this data load (you had checked that in SM50 SM37), then maybe its worthwhile checking in the following transactions for further information.

    Shortdumps - ST22 (a particular data package might have fallen over)

    BD87 - Issue with IDOC interface

    SM58 - Problem with transactional RFC

  • RELEVANCY SCORE 3.32

    DB:3.32:Delta Load Problem From Ods 33



    Hello everyone here.........,

    I have a problem loading frm ODS to another target with delta.

    Actually to ODS i am loading from two datasources. Both are full loads. Full1 and Full2. When i am trying to load from ODS to another target with delta..., it takes only Full1 data not Full2. So for loading Full2 now i am loading manually.

    so why this happend here. Please let me know how to do

    for making full2 also automatically........,

    swetha

    DB:3.32:Delta Load Problem From Ods 33


    Hi venkat

    I do the same in process chain.

    swetha

  • RELEVANCY SCORE 3.30

    DB:3.30:Error While Data Load Ods-Infocube - "No Destination Exists..." z3



    I'm getting error while loading data from ODS to InfoCube:

    "No destination exists to source system BWQCLNT250"

    have no idea what is about

    DB:3.30:Error While Data Load Ods-Infocube - "No Destination Exists..." z3


    it is because we didn't make systems BI DEV-BI QAS mapping before transporting upon transport connection.

  • RELEVANCY SCORE 3.30

    DB:3.30:Loading Data Into Transactional Ods From Bsp 3m



    Hi all,

    I have a requirement where the data being entered from BSP should be loaded into BW through transactional ODS. does anyone have any document on transactional ODS , like how the interface has to be created between BSP and ODS. please help me out. Thanks in advance.

    regards

    satish

    DB:3.30:Loading Data Into Transactional Ods From Bsp 3m


    Hi Satish ,

    I am working in BW3.5. As far I know , there are only transactional infocubes nut not transactional ODS.

    Using BSPs or manual planning layouts one can write data to a transactional infocube.

    Thanks

    Hareesh

  • RELEVANCY SCORE 3.29

    DB:3.29:Ods To Cube Loading - Taking Too Much Time d8



    Hi Experts,

    I am loading data from R/3(4.7) to BW (3.5).

    I am loading with option -- PSA and then Data Target (ODS ).

    I have a selection criteria in Infopackage while loading from standard Datasource to ODS.

    It takes me 20 mins to load 300K records.

    But, from ODS to Infocube ( update method: Data Target Only), it is taking 8 hours.

    The data packet size in Infopackage is 20,000 ( same for ODS and Infocube).

    I also tried changing the data packet size, tried with full load , load with initialization,..

    I tried scheduling it as a background job too.

    I do not have any selection criteria in the infopackage from ODS to Cube.

    Please let me know how can I decrease this loading time from ODS to Infocube.

    DB:3.29:Ods To Cube Loading - Taking Too Much Time d8


    Hi,

    To improve the data load performance

    1. If they are full loads then try to see if you make them delta loads.

    2. Check if there are complex routines/transformations being performed in any layer. In that case see if you can optimize those codes with the help of an abaper.

    3. Ensure that you are following the standard procedures in the chain like deleting Indices/secondary Indices before loading etc.

    4. Check whether the system processes are free when this load is running

    5. try making the load as parallel as possible if the load is happening serially. Remove PSA if not needed.

    6. When the load is not getiing processed due to huge volume of data, or more number of records per data packet, Please try the below option.

    1) Reduce the IDOC size to 8000 and number of data packets per IDOC as 10. This can be done in info package settings.

    2) Run the load only to PSA.

    3) Once the load is succesfull , then push the data to targets.

    In this way you can overcome this issue.

    Ensure the data packet sizing and also the number range buffering, PSA Partition size, upload sequence i.e, always load master data first, perform change run and then transaction data loads.

    Check this doc on BW data load perfomance optimization

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1955ba90-0201-0010-d3aa-8b2a4ef6bbb2

    BI Performance Tuning

    FAQ - The Future of SAP NetWeaver Business Intelligence in the Light of the NetWeaver BIBusiness Objects Roadmap

    Thanks,

    JituK

  • RELEVANCY SCORE 3.29

    DB:3.29:Ods To Cube 71



    Hi

    I am loading my CUBE from ODS object, the request was success, but data is not available in Cube (Data available in ODS). Why?

    DB:3.29:Ods To Cube 71


    Hi Srinivas

    Pls go to ur ODSmanageSelct the Request Tab check out whether u have Data mart symbol nxt to the request ID,If No then select the Full Upload from the ODS rght click then select the Update into the data Target Then u get POP up window the select Full load.Then from the Nxt load select the Init run from the ODS.

  • RELEVANCY SCORE 3.29

    DB:3.29:Error When I Am Loading Data From Psa To Ods ks



    hai Gurus

    Very good morning

    Actually i am loading data from PSA to ODS.

    But when i am loading data i am getting the error InfoObject/BIC/0REFER_DOC does not contain ALPHA -CONFORMING VALUE 0.

    Can anybody help me to solve the problem and reload the data

    Thanks Regards

    Jayavardhan

    DB:3.29:Error When I Am Loading Data From Psa To Ods ks


    Hi,

    Lacs of postings are there in this forum on this topic. Searching teh forum is the best option for u now.

    With rgds,

    Anil Kumar Sharma .P

  • RELEVANCY SCORE 3.29

    DB:3.29:Full Load Ods To Ods In A Process Chain a3


    hi gurusi have two ODS's lets call them ODS-1 and ODS-2, ODS-1 is feeding ODS-2(its a full load). nowi have a process chain that loads data into a ODS-1, and than activates it and than i am trying to do a full load into ODS-2, i used the variant "further update datatargets" but that just did a delta into ODS-2 from ODS-1, i want todo a full load. so in RSPC removed "further update datatargets" and instead tried simply executing the (generic) full load infopackage that loads from ODS-1 to ODS-2.but it gives the error "InfoPackage ZPAK_3YO6FAHJEYYFN9SYYTDNI5EQA is generated; NOT able to be used as loading variant"so now how do i do a full load in the process chain from ODS-1 to ODS2.

    DB:3.29:Full Load Ods To Ods In A Process Chain a3

    The export datasource for an ODS is generated by the system upon ODS activation, so it would be there...

  • RELEVANCY SCORE 3.29

    DB:3.29:Loading Impossible From Ods 7x


    Hi,I want to load a cube (CUBE1) from an ods (ODS1), but with corresponding info-package, my loading is never initiate. When I launch this loading, info-package compiling programs, etc. but never execute loading.I try load another structure. I create another ods (ODS2) like ODS1 and I've same problem to load this.I've checked ODS1 with rsrv, only test return error (foreign key et SID). According RSRV, ODS1 haven't SID for different caracteristics. When I check tables (/BIC/AODS110, /BIC/AODS140 and /BIC/AODS150) with SE14, SAP BW say me these 3 tables are consistent.I peruse different posts on this forum, the solution to reload master data can be solve this problem ? I don't think. If master data miss, during loading of CUBE1 SAP create a dummy or blank entry but they can't restrain the start of loading. Isn't it ?What's solution ? others check with rsrv show me green light. How can I repair my ODS1 ?Rgds,

    DB:3.29:Loading Impossible From Ods 7x

    Hi,check your autority. You might miss the authority to schedule a job. Additionally check the authorities of your background user (usually aleremote). May be there is also a lack of authorities.regardsSiggi

  • RELEVANCY SCORE 3.28

    DB:3.28:Infocube Error pz



    when i am loading data from psa to ods : no error

    ods to infocube i got error

    in ods data is correct

    in infocube i got error

    how to solve this problem

    DB:3.28:Infocube Error pz


    Hi Vijay,

    Can you explain what was the error...there can be different solutions based on the problem.

  • RELEVANCY SCORE 3.28

    DB:3.28:Can We Execute The Reporting While The Data Is Loading Into That Ods/Cube. ka



    Hi Friends,

    Can we execute the reports on particular ODS/InfoCube in the following cases

    1) When the data is loading into that ODS/Infocube.

    2) When we are Archiving the data from that ODS/Infocube

    Thanks Regards,

    Shaliny. M

    DB:3.28:Can We Execute The Reporting While The Data Is Loading Into That Ods/Cube. ka


    Hi Shaliny,

    First of all you are in the wrong forum, in Business Intelligence Old Forum (Read Only Archive) you will find better support.

    In case you are loading data in an infocube you will be able to have report only until the request that has the icon ready for reporting filled. In case of an ODS object i don't think you will be able to have valid reporting since the ODS data firstly needs to be activated.

    Nevertheless please post your question in the above link.

    Kostas

  • RELEVANCY SCORE 3.28

    DB:3.28:Delta Loading fa



    hi,

    I want to load data from one ODS to another ODS by delta loading.first ODS has 30,000 records.after I have created a request ,it quickly activate and give message as "0 records from 0 " why it happened?

    DB:3.28:Delta Loading fa


    Hi,

    First u need to do a initialization. and then run a delta.

    So do the following steps.

    1. Do a init without data Transfer. this will bring 1 record.

    2. And then Do a Repair Full load.This will bring records in ur case it should bring 30,000 records. For this u should do the setting in the Infopackage i hope u know this....if no then pls ask......

    3. and then do the setting for Delta in the Info package which u will be using later in Future.

    Assign Points if this helps u........

    Thanks,

    Nagesh.

  • RELEVANCY SCORE 3.26

    DB:3.26:Loading Data From Ods To Infocube 1s


    Hi,In ODS data is there but when i try to load it to cube it is not coming correctly. What all the steps i have to follow??

  • RELEVANCY SCORE 3.25

    DB:3.25:Data Loading From Cube To Ods Is Possible ? fj



    Hi,

    I have some doubts..which you

    data loading from 1.cube to ods 2.ods to ods is possible.

    is it possible to generate Bex Reports on Infosets.

    Thanks,

    Madhu

    DB:3.25:Data Loading From Cube To Ods Is Possible ? fj


    Hi,

    It is possible to load data from Cube to ODS. But it is not advisable.

    Yes. You can create reports on infosets.

  • RELEVANCY SCORE 3.25

    DB:3.25:I Want To Load From Two Datasources To Ods Then Ods To Infocube k7


    Hi Experts,I want to load the data from Two datasources to one ODS.Once i completed ODS loading i need to load to infocube.Please anybody tell me what're the steps to complete this task.RegardsSuresh

    DB:3.25:I Want To Load From Two Datasources To Ods Then Ods To Infocube k7

    My probelm has been solved with you guys suggestions.CheersSuresh

  • RELEVANCY SCORE 3.25

    DB:3.25:Error While Loading Data From Ods To Infocube js



    I am trying to load data from ODS to Infocube thru Update ODS data into data target. My requirement was to take a small subset of fields from ODS and design IC and load the data.

    My load fails at Extraction process as I get 0 records from total number of records sent in each package. Please let me know if you need more information.

    Please advise.

    Thanks,

    RR

  • RELEVANCY SCORE 3.25

    DB:3.25:Loading Data Form Ods To Infocube ax



    HI,

    I am loading data form ODS to Infocube (delta)..But job is running long time and showing zero from zero records

    Can you plz give some inputs

    Thanks,

    Sreenu

    DB:3.25:Loading Data Form Ods To Infocube ax


    Hi Sreenivas,

    Are there any other processes running in the system? May be the background processes are not free.

    Veerendra.

  • RELEVANCY SCORE 3.24

    DB:3.24:Cube Before Ods jj



    Hi, when we get data from R/3, first we load it in ODS. Why do we load always in ODS before loading into Cube?

    Thanks,

    Radha

    DB:3.24:Cube Before Ods jj


    Hi Radha,

    If your client need Lineitem data in reports then we use ODS and we use ODS for change logs(Deltas).

    If we want detailed level of information inspit of dimensional analysis we go through for ODS.In Infocube we can find summetion data only.And infocube stores the data redanently.Whereas ODS have overwrite functionality.

    I hope this will help you.assign points if this helps.

    Regards

    Nath

  • RELEVANCY SCORE 3.24

    DB:3.24:Loading Data From 2 Ods To 1 Ods js



    Hi All,

    In Modeling there are 2 ODS.

    ODS 1 : FI

    ODS 2 : SAP

    And for ODS 1 the Keyfield is Accounting document No and Item No and data field be Created by,Sales Order No and Date 1

    And in ODS 2 the Keyfield is Sales document no. and data field be date 2

    And in Final DSO, the data should load in the below manner.

    Accouting document noitem nocreated bydate 1Sale order nodate 210001111raj01-02-20124010110001-02-201110001112Raj01-02-20124010110001-02-20111001121Raj01-02-20124010110101-02-20111001131Raj01-02-20124010110201-02-2011

    Can you pls suggest on this.

    Thanks Regards,

    Jelina.

    DB:3.24:Loading Data From 2 Ods To 1 Ods js


    Hi,

    Please check the below contents

    In GL DSO

    key fields:- 1. company code

    2.chart_accts

    3.glaccount no

    4. fiscial period

    5.accounting doc number

    6. item no

    data :fields 1. notification no

    2 amount

    warranty dso

    key fields 1. Notification no

    data fields : 2 .date

    But in final DSO

    i am getting 2 different records

    Please help.

  • RELEVANCY SCORE 3.24

    DB:3.24:Dynamic Lookup pz



    Hi ,When is it best to use a dynamic lookup. I am loading data from source to ODS and then ODS to data mart, both loads are incremental. For load from source to ODS (staging area for data mart) it is better to use dynamic lookup or static

    Thanks

    DB:3.24:Dynamic Lookup pz

    It is better from a performance perspective to use a non-dynamic lookup if it meets your business logic needs. Dynamic lookups add or modify cache data as the session runs, so this puts an additional cpu and possible i/o load on the process. However dynamic lookups offer additional functionality over non-dynamic, so in many cases it's not a question of choice.

  • RELEVANCY SCORE 3.24

    DB:3.24:Basic Bw Doubt dz



    Hi,

    First of all excuse me for asking basic questions.

    assuming i've a ff and i'm trying to load to ods and then onto a cube from the ods. my ff is of this order:

    custid, matid, quantity.

    i;m first loading values like

    cust01 mat01 49

    after loading this i'm loading again with values

    cust01 mat01 83

    how will the records look in ods and in cube

    during reporting how will it look like.

    ~rahul

    DB:3.24:Basic Bw Doubt dz


    andrzej- i meant flatfile by ff. infact i could have ignored that statement.

    siggi - thanks for the answer. im clear now.

    i've assigned pts for both.

    ~rahul

  • RELEVANCY SCORE 3.24

    DB:3.24:Load Failed From Ods To Ods And Ods To Infocube mk



    Hi Friends,

    I am new to sdn.How to rectify when the load fails when loading data from ODS to ODS and ODS to Infocube and pls explain when it is Full load how can we rectify and when it is Delta load how can we rectify?

    Regards,

    Bhavani

    DB:3.24:Load Failed From Ods To Ods And Ods To Infocube mk


    Data mart deletions comes in to picture only for delta loads..with in BW system( It might be ODS to ODS or ODS to CUBE)....

    It depends on the failure reason... if u have PSA in between u can rectify the error in PSA itself and load it from PSA to target....

    You can find a lot of scenarios by searching forum

    Regards,

    B

  • RELEVANCY SCORE 3.23

    DB:3.23:Steps For Loading Data In Ods p7



    Hi

    I am working on BW 3.5, I need to load data from a table into an ODS. tables are in the BW system the Update rule is also active. Now I need to know what will be the steps to load data into ODS

    Thanks in advence

  • RELEVANCY SCORE 3.23

    DB:3.23:Deletion Of Ods Change Logs, Performance Gain? 7k


    HiWe have currently not done any deletion of ODS Change logs in our BI system(BI 7.0).Is there any major performance gains when doing this? When loading to and from an ODS after a change log deletion has been done. I assume that it would also benefit discspace use.

    DB:3.23:Deletion Of Ods Change Logs, Performance Gain? 7k

    HI,Change log maintains the history of records,it will be difficult to track if you have more records. Change log table will have history of added records as it works on before and after image.Hope this helps..

  • RELEVANCY SCORE 3.22

    DB:3.22:Ods 89



    hello SDN,

    1.)

    If Full load is loaded into ODS from R/3, does this data get recorded in change log also , assuming no delta init is set?

    2.)

    And can I subsequently do a delta init from this ODS to a cube? If so, where does this delta come from within the ODS?

    For the above, I just like to confirm that my understanding is correct for the 2 situations:

    1.) No data is stored in change log in this case.

    2.) No delta possible from ODS to cube given that initial loading from source system to staging ODS only contains full load overwrite.

    Regards

    Suzie

    DB:3.22:Ods 89


    Yes, that is correct.

  • RELEVANCY SCORE 3.22

    DB:3.22:Contains Invalid Characters While Loading From One Ods To Another Ods fk



    Hi all,

    I am getting an error message. While loading the data from one ods to another ods

    Value '!' (hex. '0021') of characteristic zaaaa contains invalid characters

    From one ods to another ods and hence i cant find any psa data to delete the hex decimal values.

    How to handle this error

    one to another ods through the expert routine

    Thankks

    DB:3.22:Contains Invalid Characters While Loading From One Ods To Another Ods fk


    in the expert routine, you can write a code to check if there is really some invalid character in the data_package...

    this will permenantly fix the problem..

    if you need any help with code.. you can paste your expert routine here and point the field which has invalid data

  • RELEVANCY SCORE 3.22

    DB:3.22:Ods To Ods k9



    Hello Experts,

    I have a ODS say ODS1. I need to get all the data to ODS2 with some changes which i have incorporated in the start routine. When I am loading data, it doesnt copy from source to target?

    What might be the reason or possibility for this

    DB:3.22:Ods To Ods k9


    hi,

    it might be the problem with ur start routine(u r logic maynot fulfill ur requiremnt).. u can 'debug' the start routine by putting break-point and triger the infopack

    here u can able to the source records and targeted records in the debugging session

    thanks

  • RELEVANCY SCORE 3.22

    DB:3.22:Ods To Cube In Process Chain 1x



    I am loading data to an ODS and then from the ODS to the cube. I can do this manually by saying "update ods data in data targets" but how can I do this in a process chain? I can figure it out till the ODS part but not from the ODS to the Cube. Thanks.

    DB:3.22:Ods To Cube In Process Chain 1x


    Hi

    Check out the link to create the Process chain

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/b0afcd90-0201-0010-b297-9184845346ca

    Thanks=Points in SDN

    SANJEEV KUMAR HAMSALA

  • RELEVANCY SCORE 3.22

    DB:3.22:Performance: Loading With/Without Psa 3x



    Hi friends,

    While loading data from ODS to ODS (Full Load) which is best option in case of performance point of view.

    1)Loading PSA and Target parallel

    2)Loading PSA and then Target

    3)Loading only to Traget without PSA

    I feel point 3 that loading to only to Target without PSA is best to decrease the time of loading ?

    Please help me to understand.

    Thanks

    Tony

    DB:3.22:Performance: Loading With/Without Psa 3x


    HI Dev,

    it depends upon scenario...

    if u just uploading the same data . than go for .. DATA TARGET only.

    Regards

    Rahul

  • RELEVANCY SCORE 3.22

    DB:3.22:Does Activation Fails In Ods When It Is Acting As Source Loading Data px



    Hi All,

    If i am loading data from ODS to cube which is nothing but repair full (data from active table), i bring delta to ODS start ods activaion of the delta request will it fail due to the lock on the active table?

    Thanks in advance

    DB:3.22:Does Activation Fails In Ods When It Is Acting As Source Loading Data px


    Yes........There will be lock and your load fill fail..

    Functional Restrictions on the Process (Refer BW 330)

    During the Loading Process:

    . To delete the contents of the DataStore object

    . To archive data

    . To delete on a request basis

    . To delete selectively

    . To activate

    During Activation:

    . To delete the contents of the DataStore object

    . To delete on a request basis

    . To delete selectively

    . To delete master data

    . Toarchive

    . To reactivate

    . To update data to further InfoProviders

    During Deletion on a Request Basis:

    . To delete the contents of the DataStore object

    . To delete on a request basis again

    . To delete selectively

    . To activate

    . Toarchive

    . To update data to further InfoProviders

    During Selective Deletion:

    . To delete the contents of the DataStore object

    . To delete on a request basis

    . To delete selectively again

    . To activate

    . Toarchive

    . To update data to further InfoProviders

  • RELEVANCY SCORE 3.22

    DB:3.22:I Got Error When Load Data From Ods To Cube c9



    Hi All,

    i got error when loading data ods to cube.

    error: EDI Partner profile not active

    pls help me

    thanks

    kamal

    DB:3.22:I Got Error When Load Data From Ods To Cube c9


    Hi

    Please check whether self source system is connected properly or not...

    BW should be connected to BW as a source system...

    RSA1toolsmanage source system...here the source system assignment should be green.and also check

    RSA1toolsassignment of source system to source system id...

    Hope it helps

    Thanks

    Teja

  • RELEVANCY SCORE 3.22

    DB:3.22:Ods Activation Error- Urgent!!! 8x



    Hello,

    We have a problem, in process chain ods activation failed,

    Here is the scenario,

    we have one Info package which is updating to 2 ODS (ODS1 AND ODS2) and its a delta update.

    ODS 1 is activated fine but ODS 2 last month its not activated so even this month it failed to activate.

    This is a monthly loading.

    When i tried to activate ODS 2 for last months request and this month manually it is giving error (ODS Built in In correctly can not update from PSA REQU**). Init load for this ODS 2 is done 6 months back.

    Now how will we go about activating ODS 2 for last month and this month`s request in ODS 2.

    Please suggest, as the records have arrived but no reporting symbol in ODS 2 as it is not activated.

    Thanks in advance

    Mahesh.N

  • RELEVANCY SCORE 3.21

    DB:3.21:Dso/Ods Over Writing Issue... kx



    Hi Floks

    Can any please through some light on this issue..

    We are loading data to 1 ODS and from there it is going to Cube. we are getting data from R3 for this ODS.

    we are using standard extractor 2LIS_13_VDKON and Custom ODS on Bw side.

    While loading data to ODS we have Key Fields (Billing Doc Number,Condition Type , Billing Item and counter)

    *When we are loading the data to ODS we are facing Billing Date is not OVER WRITING with the new Billing DATE for

    Certain Condition Types for some times.

    In PSA Data is availble in proper way.

    Purushottam

    DB:3.21:Dso/Ods Over Writing Issue... kx


    HI,

    Please check for the corresponding entries in change log with thier record modes.

    -Vikram

  • RELEVANCY SCORE 3.21

    DB:3.21:Datasource Has To Be Replicated Error Message kx



    Hi,

    i am loading data from R/3-ODS-Cube. I got timestamp error at ODS level.

    I have replicated ODS, but i am not able to activate the transfer rules.

    the infosource is not in change mode.How to activate the transfer rules

    Please help me in solving this problem.

    Thanks

    DB:3.21:Datasource Has To Be Replicated Error Message kx


    Goto Info source tab and search for 8ODS NAME

    Right click on that and say replicate data source .

    Then activate the transfer rules 8ODS NAME with the pgm RS_TRANSTRU_ACTIVATE_ALL

    then load the data.

  • RELEVANCY SCORE 3.21

    DB:3.21:Regarding Loading Data From Ods To Infocube ax



    hai

    just tell me what is the advantages and disadvantages of

    "Scheduling the data from ODS to InfoCube by creating Infopackage or by using the context menu of 'update ODS data into datatarget' "...

    I got so many shortdumps by using the option of 'Update ODS data into datatarget' while loading from ODS to InfoCube .

    Then i created many Infopackages and loaded the data bparallely/b from ODS to InfoCube..

    SO please tell me

    i ll assing the points

    bye

    rizwan

    DB:3.21:Regarding Loading Data From Ods To Infocube ax


    Hi Rizwan,

    Also check this link:

    http://help.sap.com/saphelp_nw04/helpdata/en/2c/749bbb595511d4b2bc0050da4c74dc/frameset.htm

    Bye

    Dinesh

  • RELEVANCY SCORE 3.20

    DB:3.20:Ods Activation Errors a3



    BW Experts

    I get the following errors when Activating a ODS via a Process Chain although the Loading Packages is green in the ODS I still get the error - please advise on how to fix or possible checks that I can perform

    Request REQU_C0WBH5QZMWMQZ0V6UF3ZNE9RX in ODS ZMMINV51 must have QM status green before it is activated

    Activation of data records from ODS object ZMMINV51 terminated

    DB:3.20:Ods Activation Errors a3


    Hi,

    Can you explain us how it is sorted?

    Regards,

    anil

  • RELEVANCY SCORE 3.20

    DB:3.20:Very Urgent Load Failed From Ods To Cube Using Data Marting z7



    Hi All,

    Loading from ODS Cube is failed. strictly speaking it's not failed.it's not picking the delta load from ODS to Cube. i tried to reset the Data martsetting in ODS and i tried delta still delta records showing 0 records.

    please guide me. I don't have any option for Repeat delta while loading the data from ODS to Cube.

    Regards,

    Nagesh Ganisetti.

    DB:3.20:Very Urgent Load Failed From Ods To Cube Using Data Marting z7


    Hi Nagesh,

    Deltas should be handled very carefully. May be your deltas got corrupted. You can proceed with two options:

    You can do an inti with out data transfer by creating a new delta bridge and can continue with your loads.

    Or check if you have data in PSA? If so then try deleting the old request in ODS as well and try loading the ODS and then cube.

    Hope this helps you,

    Bye,

    Naga.

  • RELEVANCY SCORE 3.20

    DB:3.20:Better Approach - Ods To Cube Or Cube To Cube? s3



    Hi,

    Our present flow is ODS -- cube -- cube. There are no update rules between ODS and first cube.

    I just want to know the impact of loading the two cubes simultaneously from the ODS instead of how it is done now.

    Any comments?

    Thanks Regards,

    vamsi.

    DB:3.20:Better Approach - Ods To Cube Or Cube To Cube? s3


    Hi

    In ODS you always store detailed data (EX: Sales order and item wise)

    In cube you mostly store aggregated data (Ex: material and customer)

    Its not mandatory for data to flow from ods to cube. But it depends on the extractor. If the extractor is giving only after images then you should first load to ODS and then Cube (Ex: FI data).

    If there are no update rules for the first cube, then you directly load from ODS to cube2.

    Hope its clear

    Regards

    Srikanth

  • RELEVANCY SCORE 3.19

    DB:3.19:Problem With A Process Chain(Related To Crm) z3



    hello everyone,

    i am having two data targets- ods and cube.

    for both ods(data target) and cube(data target) we have two datasource. i.e two more ods.

    from this datasource(two more ods) data is flowing to data target(cube) but not to another data target(ods).

    flow of process chain is as follows:

    1) start process

    2) Indexes- delete index (cube name)

    3)load data- loading 1st data source.

    4)load data-loading 2nd data source.

    5)activate both ods.

    6)further processing of 1st data source(ods).

    7)further processing of 2nd data source(ods).

    8)activate the data target(ods).

    9)create index of the cube(data target)

    plz help.

    DB:3.19:Problem With A Process Chain(Related To Crm) z3


    hi raj,

    thanks for replying.

    there is no problem with the update rules. same update rule is being used in for another data target and its working absolutely fine.

  • RELEVANCY SCORE 3.17

    DB:3.17:How To Load Data From Ods To Ods Through Data Marts(Through Infopackage)? ff


    Hi all,I have to load the data from one ods to another ods? can anyone let me know the procedure for loading the data through an infopackage(datamarts)thankspooja

  • RELEVANCY SCORE 3.16

    DB:3.16:Loading Data From Ods To Cube. z7



    Hi mates,

    iam loading data from ODS to cube, right click on ods select option update data in to targets. once i do that where i get window to select full load and delta , but where i can see those infopackage of cube .

    hari

    DB:3.16:Loading Data From Ods To Cube. z7


    Hi hari,

    yes it will create a DataSource, an InfoSource (8ODS), and then you will need to create your Update Rules.

    InfoSource will be stored in DataMart Application Component (if not present activate it from Business Content - First check in Generated Option objects).

    I do not remember but if I am not wrong it also create an InfoPackage: if so do not use this one (because generally you are not able to change anything) create your custom one.

    PS: Also Kedar is answering you in a correct way: I always think that is better to enlarge friends club

    Ciao.

    Riccardo.

  • RELEVANCY SCORE 3.16

    DB:3.16:Problem When Loading Data From Psa To Ods dk



    hai Gurus

    Actually i got one error when i was loading data from PSA to ODS.

    I rectified the error and I deleted the bad request from ODS.

    Again when i came to Reschedule the data from PSA, I am unable to find the DATA TARGET( ODS name) in the Data Target tab.

    I dont know what to do

    Can anybody suggest me to solve the problem

    Thanks Regards

    Mahi

    DB:3.16:Problem When Loading Data From Psa To Ods dk


    Hi Mahi,

    If the particular request is in ODS, could you try with using the Reconstruction functionality. I think it should help.

    Regards.

  • RELEVANCY SCORE 3.16

    DB:3.16:Delta Not Working From Ods To Cube pz



    Dear All,

    In one of the system, we have delta working properly from source system to ODS. But, while loading data from ODS to cube, delta brings only zero records. Earlier, change log table for ODS was corrupted, so we had activated ODS directly in the system using program RSDG_ODSO_ACTIVATE.

    I have checked evry thing including correct INIT and all, but RSA3 only doesnt bring any delta records, although there is delta in ODS below. Please let me know, for any other thing I can check and try.

    Best Regards,

    Harpal

    DB:3.16:Delta Not Working From Ods To Cube pz


    Hi, Harpalsinh Gohil

    Maybe you have changed the extraction structure(start as 8xxxxx from ODS to Cube)occasionally, you can try to the following steps:

    1.right click ODS;

    2.select addtional function-generate export datasource;

    3.activate datasource 8xxxxxx;

    4.initialize delta process for the infopackage;

    hope it helps.

    Carina

  • RELEVANCY SCORE 3.15

    DB:3.15:Load Data From Flat File To Transactional Ods 8f



    Hi SDN

    I need step by step procedure of loading data from flat file to transactional ODS.

    Thank you in advance.

    Regards

    Chris

    DB:3.15:Load Data From Flat File To Transactional Ods 8f


    Hi,

    /message/2053332#2053332 [original link is broken]

    look the APD suggestion by Peter

    regards

    Happy Tony

  • RELEVANCY SCORE 3.15

    DB:3.15:Extraction 78



    Dear Gurus,

    I am facing the problem while loading, i am getting the data in ODS from the datasource 2lis_13_vditm. i am geeting the data in ods

    and while i am loading into cube it is not loading and throwing an error that No corrected request has arrived in the ods/cube. will

    anybody throw light on my thread, i tried for other datasources loading into ods , it is geting loading upto ods while loading into

    it not getting, and in status tab it is showing no data in datapackets and no idocs has arrived in the source system

    _

    No corresponding requests were found for request REQU_4GY9FW9M32E9OKDC1NQ0SXQG4 in the ODS/Cube

    Message no. RSBM043

    Edited by: RADHA AGARWAL on Feb 24, 2010 7:55 AM

    Edited by: RADHA AGARWAL on Feb 24, 2010 8:00 AM

    DB:3.15:Extraction 78


    HI Radha,

    Check whether SAP NOTE 542872 is relevent for your problem.

    Also go thru the following link :

    No corresponding request s were found for request reqxxx in the ODS or cube

    Regards,

    Srikanth.

  • RELEVANCY SCORE 3.15

    DB:3.15:Ods To Ods And Cube Help! xa



    Hi

    We have two ODS's (ODS A and B)loading from ECC and these ODS data is loading in to several cubes and other ODS's.

    We have some issues with ODS A load to cube so we deleted the cube data and reinitalized from ODS A. this ODS A is

    also loading to other ODS's (ODS B , then ODS B loads to ODS C) etc...All the ODS have the KF as overwrite option. Now I'm wondering when

    I reinitialized from ODS A to cube do I need to load that init req to ODS B aswell or not ? If not please let me know

    how can I make sure everything is getting correct. If yes, can I just go ahead load in to ODS B and then ODS B data to ODS C and cube B etc..?

    Please let me know asap.

    Thanks

    Sam

    DB:3.15:Ods To Ods And Cube Help! xa


    Do you have the flow from ODS B to Cube B ?

    if so run the delta load and then you need to delete Init req

    ODSB to CubeB

    ODSB to ODS C

    and do Init without data and then delta

  • RELEVANCY SCORE 3.15

    DB:3.15:Ods sa



    hi friends,

    I created one info src for 2 ods in bw. while loading data i absorved two req in 2 nd ods and one req in 1 st ods.

    i need clear picture when u trigger IP what will happen to two ods.

    And one more if you delete 1 st req then data is also delted from new table.

    Can we delete the selected req in ods before activation.

    Pallavi P S

    DB:3.15:Ods sa


    Hi,

    As u asked about deletion of ods request , i think u made it in automatic activation mode.First uncheck the ods activation setting.

    So that before u can do activation manually.Here u can deleted the request before activation.

    Thanks,

    Ranjan

  • RELEVANCY SCORE 3.15

    DB:3.15:Master Data Into Ods? 8f



    Hi everyone

    Is there any difference between loading transaction data and master data into ODS?

    How to load master data(attributes,text,hierarchy) into ODS from flat file?

    Let me know the step by step scenario

    If u have documentation on this please mail me at jangareddy_d@yahoo.co.in

    thanks and regards

    dj reddy.

    DB:3.15:Master Data Into Ods? 8f


    Jabgareddy

    If I understood correctly your problem you don't have to load Master data to ODS in order to activate this. While building the ODS Object just drag and drop some of the infoobjects in to Data fields and Key fields depends on your requirement and activate the ODS Object.

    Thnaks

    sat

  • RELEVANCY SCORE 3.15

    DB:3.15:Gurus, I Am Struck With Loading Data From Ods To Cube sd



    I have new ODS and Cube and this is the first time we r running the jobs to load data from ODS to Cube.

    Load from ODS to Cube is delta, though we don't have data in ODS when we trigger job from ODS to Cube it is still showing "not yet completed/warning".

    Its almost 40mts and it is still in the same status.

    Pls revert me back with ur suggestions...Its bit urgent

    DB:3.15:Gurus, I Am Struck With Loading Data From Ods To Cube sd


    Hi BW,

    change that setting(given by Srini) to GREEN which means that if 0 records are present,then request is judged to be successful.

    after doing this..do the steps given by Dinesh and try to reload.Will work.

    cheers,

    Vishvesh

  • RELEVANCY SCORE 3.15

    DB:3.15:Data Load Issues From Ods To Ods In Bw 83



    Hi,

    Data loading taking long time from ODS to ODS.

    I have one ods and and data sending from source ODS to 3 taget ODS.Request is yellow for long time whn i am running through initialization without data transfer.

    There is no log in sm37.

    Kindly anybody tell me what is the reason and how to solve this problem.

    Sidhu.

    DB:3.15:Data Load Issues From Ods To Ods In Bw 83


    Hi

    When you do Init w/o data transfer then it will load just 1 record. Yes, it is correct.

    When you follow it with delta then the records the source ODS should get loaded. I would suggest you to try one more method :

    Remove 2 target ODS from the DTP and load data into only 1 ODS and check.

    Cheers

    Umesh

  • RELEVANCY SCORE 3.15

    DB:3.15:Duplicate Records In Cube Level ( Bi 7.0 ) a1



    Dear All

    I am working on BI 7.0 , I have an issue , i am loading the data from Flat File to ODS and from ODS to Cube . In ODS we are selected Overwrite option, in cube level we have an Summation option. the problem is while loading the data from Flatfile to ODS records are fine . from ODS to cube data loading also fine but here i am getting the Duplicate records .

    what are the best options to go ahead in such a situations??

    Regards

    KK

    DB:3.15:Duplicate Records In Cube Level ( Bi 7.0 ) a1


    I am sharing a case occured for me. Please see if its applicable for you.

    Sometimes, in the step loading to Cube, when any type of problem occurs, we restart the load. If the cube load prompts saying 'the lost load was unsuccessful.... reload?', this problem may occur. It will load the records in the previous load also.

    Verify what has been duplicated from the ODS changelog table and the cube load record count. If you see the number of records updated being the total of the records in the different ODSR request (in the change log table). Delete the previous load in the cube. (provided no other side effect is produced e.g from start routine etc)

    Cheers.

  • RELEVANCY SCORE 3.15

    DB:3.15:Loading Ods From Inventory Cube a1



    I am loading an ODS from Inventory cube. There are two keyfigures in ODS which are calculated in start routine of Update Rules on the basis of keyfigures from Infocube. The ODS is initiallized and regular Delta loads are taken from Infocube(which itself is getting loaded from R/3).

    More often, after Delta loads, values for 2 calculated key figures of ODS have wrong values . If this request is deleted and reconstructed,then above 2 keyfigures show correct values.

    Has anybody come across such problem...any insight will be appreciated.

    DB:3.15:Loading Ods From Inventory Cube a1


    I am loading an ODS from Inventory cube. There are two keyfigures in ODS which are calculated in start routine of Update Rules on the basis of keyfigures from Infocube. The ODS is initiallized and regular Delta loads are taken from Infocube(which itself is getting loaded from R/3).

    More often, after Delta loads, values for 2 calculated key figures of ODS have wrong values . If this request is deleted and reconstructed,then above 2 keyfigures show correct values.

    Has anybody come across such problem...any insight will be appreciated.

  • RELEVANCY SCORE 3.15

    DB:3.15:How To Fileter Particulour Infoobject In Dtp? k9



    Hello BI Guru

    I have requirement that dat is loading from one ODS to two ODS.

    One of the ODS need to restrict with the infoobject at DTP so that it will bring the data which is related to the restricted infoobject.

    How to do it at DTP level?

    DB:3.15:How To Fileter Particulour Infoobject In Dtp? k9


    Hi,

    In the Data Transfer Process expand that In the right side screen , Under the Data package Loop u have a Filter option...

  • RELEVANCY SCORE 3.14

    DB:3.14:Ods To Cube 97



    Hi ,

    i am loading data from ODS to Cube.

    in rsmo i recived msg.

    error : Time conversion from 0CALDAY to 0FISCPER (fiscal year ) failed with value 20071021 .

    iam actiavting all ( IC , ODS, UR's ) from BCT only.

    how can i correct this error ?

    i assign points..

    regards

    PSR

    DB:3.14:Ods To Cube 97


    Hi,

    Are you doing for any of these two cubes.0PP_C03 and 0PP_C04.If yes then

    once refer SAP Note Number: 630993.

    refer this link for that.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_bct/~form/handler

    Also refer this thread.

    0PP_C14 time conversion failure in update rules

    Regards

    Karthik

  • RELEVANCY SCORE 3.14

    DB:3.14:Ods To Cube Data Load mx



    Hi All,

    I am loading data from ODS To cube both are daily delta loads.

    Is cube get data from change log / active table of ODS ; remmber both are delta loads.

    Please help ASAP.

    Regards

    Karuna

  • RELEVANCY SCORE 3.14

    DB:3.14:Deleting Ods Request cp



    Hi Experts,

    I want to delete the ODS request without deleting the CUBE request,

    assume that the data is loading from ODS to cube.

    if there is any program for that

    Points will assigned to the valid answers.

    Thanks in Advance

    DB:3.14:Deleting Ods Request cp


    Hi Experts,

    I came to know that we can delete the request in ods without deleting the cube request.

    the thing is we can not delete the data but we can delete the request in ODS.

    The procedure is Go to SE11rsiccontdisplaytable contentsgive the parameters like

    Request no and the data target nameexecutedelete your request.

    Thanks a lot for giving support in this regard.

  • RELEVANCY SCORE 3.14

    DB:3.14:Loading From Ods To Master Data Object cj



    Hi Friends ,

    Please let me know how to load from ODS to a master data object.

    Thanks,

    krishna

    DB:3.14:Loading From Ods To Master Data Object cj


    Hi Krishna,

    You can re-generate the export datasource out of the ODS and check in the datamart section of RSA1(Infosource).

    Bye

    Dinesh

  • RELEVANCY SCORE 3.14

    DB:3.14:Delta jk



    dear Gurus,

    I need your help to clarify ODS delta concept.

    The scenario:

    1. To handle delta from source system , I am loading into ODS by init'g delta on ODS 1st. From here, the changes goes into the cube and aggregation will reflect the changes.

    Whats unclear to me is, do I do another init delta from ODS to cube or full load?

    Hope to get your advice.

    best regards

    Suzie

    DB:3.14:Delta jk


    Thanks Dirk, Vijay and Chris. Points all round.

  • RELEVANCY SCORE 3.14

    DB:3.14:Subsequent Loading Data In To Base Ods xj



    Hi Expeterts,

    can I load data into Base ODS and activate that particular request while datamart is running(ie. data is updating from Base ODS to different data targets).

    please help me in this regard.

    Thanks,

    Bala

    DB:3.14:Subsequent Loading Data In To Base Ods xj


    No not possible.If done that way then u will face in consistency of the data.The remaining load will not be updated into the ODS .

  • RELEVANCY SCORE 3.14

    DB:3.14:Error Occured While Loading From 1st Level Ods To 2nd Level Ods 9z



    Dear Friends,

    I have an issue that is when i try to load the data from 1st level ods to 2nd level ods i get error message as

    Request requ_4evs0l8j561xzy5mw121tkmzs(446,276) has not or not currently been updated.

    Activation of data records from ODS object ..... terminated

    Am running it as INIT without Data transfer but am getting same error.

    I have deleted the complete request and started loading from the scratch but still i am getting the same error.

    Can someone pls help me out in this as am facing his issue in PRD system.

    Thanks

    DB:3.14:Error Occured While Loading From 1st Level Ods To 2nd Level Ods 9z


    Do you already have a Full request in the DSO? What is the error message other than "Activation of data records from ODS object ..... terminated". Click on the log in the manage screen of the DSO for this failed request and let us know the error message.

    If you already have a Full request then Delta is not possible on it. You need to change it to a Repair Full before starting delta's. Check this thread. It gives you steps to change the update mode Flag:-

    Loading FULL and DELTA into a DSO

  • RELEVANCY SCORE 3.13

    DB:3.13:Bc Ods For 2lis_13_Vditm 78



    Hi All

    Would anybody help me in knowing the BC ODS for loading from BC infosource

    2LIS_13_VDHDR and 2LIS-13_VDITM i.e billing data.

    R

    DB:3.13:Bc Ods For 2lis_13_Vditm 78


    Hi,

    There is no standard ODS or Cubes for Headed or item level information of Billing Documents. So you need to create it.

    With rgds,

    Anil Kumar Sharma .P

  • RELEVANCY SCORE 3.13

    DB:3.13:Cube- Ods pp



    Hi,

    I am loading the Data from ODs to Cube it is fresh Init with data transfer load.... Its giving me an error Missing Indexes ..

    Can anyone will help..

    DB:3.13:Cube- Ods pp


    Hi,

    before loading data from ODS to Cube first Delete Index on Cube.

    below are the steps:

    T-code RSA1

    Right click on cube - Manage

    go to Performance tab

    Check index,

    then delete index

    load data from ODS to cube.

    Hope this helps

    Regards

    Daya Sagar

  • RELEVANCY SCORE 3.13

    DB:3.13:Loading From Ods 98



    Hello All,

    I have a question short time.

    I have a following senario,

    ODS-A is loading infocube-B with delta load every night. Now I want to start full load to new cube say C from same ODS-A.

    I want to know, whether it will diturb my delta ??

    Thanks in advance for helpful answer.

    Suneel

    DB:3.13:Loading From Ods 98


    yeas Mr S Patil.

    U can do that only thing is that ODS should not load data to data target automatically. u have to use different infopackages for the different data targets. lets say e.g for cube A setting will be for delta loads and for Cube B settings will be full load with deletion of previous data. and then u haev to schedule these data loads.

    Hope it helps.

    assign the points of it works for u.

  • RELEVANCY SCORE 3.13

    DB:3.13:Ods Delta Daily Load And Cube 3 Tmes Per Week Load m7



    Hi ,

    I am loading delta goods movement data from R/3 into ODS on daily basis (DELTA) and loading from ODS into CUBE 3 times per week .

    My questions is :

    Ex: Tues delta load into ODS with request : REQ1

    Wednes day delta lado into ODS with REQUEST REQ2.

    Wednes day planning to delta load into CUBE (REQ1,REQ2).

    Will REQ1,REQ2(both the requests) load into cube on wednes day from ODS ?OR only latest request REQ2 from ODS load into cube ?.

    please can any body help me

  • RELEVANCY SCORE 3.13

    DB:3.13:Data Loading From Ods To Infocube mx



    Hi experts,

    I tried to load the data from ODS to infocube:

    Steps:

    right click ods and click generate export data. its showing infosource stats with 8 created successfully. where will i go and find that ods?

    but i didnt get the infopackage also?

    what should i do for this?

    DB:3.13:Data Loading From Ods To Infocube mx


    Are you using BW or BI.

    And could you explain properly what the issue is.

    Are you unable to extract data into Icube from DSO.ie (ODS)

    Well if you in BI.

    You need to right click on the Icube and create Data Transfer process

    and when it pops up with another screen choose the ODS you need to transfer the data from. It wud populate rules by itself. Now save the DTP and activate it. After activation. go to the last tab Execute it.

    Well if you using BW then check on the update rules which u wud find below between the Icube and the DSO.

    Hope I am going in the right direction.

    Explain in details what exactly is going on.

    Good Luck,

    Raj

  • RELEVANCY SCORE 3.13

    DB:3.13:Loading From Ods To Cube! s7



    Hello Experts!,

    I have been trying to load a flat file to ods and then to cube.

    I am using 0calday in my ods and cube.

    so when i load the flatfile to ods i can see the values for 0calday getting updated.

    --But when i load from ods to cube everything is updated except this 0calday.All the rows for 0calday remain empty.

    I am not sure why it is not getting updated when i load it from ods to cube.

    flat file date field is of format yyyy/mm/dd

    Appreciate all your help.

    Thank you

    DB:3.13:Loading From Ods To Cube! s7


    Hi,

    Refer the OSS note

    Format for date (0CALDAY) when loading from flatfiles :

    b161506/b.

    Regards-

    Siddhu

  • RELEVANCY SCORE 3.13

    DB:3.13:Delete Psa Data fm


    Hi friends,I am loading data from Base ODS to Regional ODS in between them there is on PSA,when i delete data in PSA table then automatically da in changelog table of Base ODS,Is there any soiution to delete only PSA data.Thanks,PAVAN.

    DB:3.13:Delete Psa Data fm

    Hi,You can delete the data from PSA thruogh entire data delection through PSA Request deletion schedule. there you can keep the data how long data data you want mention like 1 week,3 days .Regrds,Krishna Reddy

  • RELEVANCY SCORE 3.13

    DB:3.13:Ods p7



    HI Gurus,

    I have an ODS where it got the combined data of Europe and US. I would like to load the Europe data to anothere ODS say(Europe ODS) and US data to another ODS say(US ODS) from the original ODS.

    I have written the following start routines as follows in the target ODSs

    Loop at Data_package.

    If Data_package - 'Area Code' EU.

    Delete Data_package.

    Endif.

    endloop.

    But, even I can see that the loading is not dome with filtering.

    Please help me out.

    Thanks,

    ND

    DB:3.13:Ods p7


    Hai,

    Goto the declaration part of the DATA_PACKAGE_STRUCTURE. Double click on your original structure. I am exacty pointin the below code:

    TYPES:

    BEGIN OF DATA_PACKAGE_STRUCTURE.

    INCLUDE STRUCTURE [your orignal structure].

    Once you double click on the original structure, you will take to the structure details. There you can identify your original Area Code field name.

    If Data_package - 'Area Code' EU.

    In this line remove 'Area Code' and give the actual Area Code filed name. Dont give any space between DATA_PACKAGE and Area Code.

    Regards,

    Vivek V

  • RELEVANCY SCORE 3.13

    DB:3.13:Activating Ods To Cube (Urgent) mj



    Hello Gurus,

    I'm running an process chains where it loads data to ODS and activating ODS and loading data from ODS to CUBE ....

    bwhere my problem is while doing further processing for ODS to CUBE i'm getting an error as follows/b

    1.Error 8 when starting the extraction program

    2.Error in source system

    3.Error occurred when updating data from ODS

    b

    Plz through some light/b iurgent/i

    Regards

    Sandy

    DB:3.13:Activating Ods To Cube (Urgent) mj


    Hi Sandy,

    1. Check if the data request is active in the ODS.

    Run the two tests for ODS from RSRV

    All Elementary Tests - ODS Objects - Foreign Key Relationship of Reporting-Relevant ODS Object and SID Table Characteristics

    All Elementary Tests - ODS Objects - Check How Up-To-Date the Generated Programs of an ODS Object Are

    2. generate export data source.

    3. Activate the communication structure and transfer rules.

    4. Activate update rule

    5. try loading.

    hope it helps.

    Regards.

  • RELEVANCY SCORE 3.13

    DB:3.13:Data Mart In Process Chains mc



    Hi Gurus,

    I am using a standard ODS for FI_AR and also the standard FI_AR cube which recieves data from this ODS.

    I have created a process chain for dataloading in ODS and the subseuqent process that is data mart from ODS to cube is failing in Process chain.

    Could anyone guide me how to include this further processing i.e from ODS to CUBE loading process in Process chain.

    Thanks in advance.

    Regards,

    Satya

    DB:3.13:Data Mart In Process Chains mc


    Hi Satya,

    Check also in ST22 for a more detailed error message.

    In any case try with solution I have sent you in previous message.

    Ciao.

    Riccardo.

  • RELEVANCY SCORE 3.13

    DB:3.13:Uploading Request From Ods To Infocube Failed? zc



    Hi

    While iam loading the data to INFOCUBE using ODS, while uploading the Request from ODS to INFOCUBE the request is failed, How should you again upload the request to INFOCUBE, Plz clarify my question.

    Regards

    manikanta

    DB:3.13:Uploading Request From Ods To Infocube Failed? zc


    hi

    if the flow from ods to infocube is in delta, supposing you have a 0calday field.

    then in the infopackage, schedule menu, take it as a repair request, and in the selection tab of the infopackage for 0calday select only the date on which request failed and schedule once again.

    raj

  • RELEVANCY SCORE 3.13

    DB:3.13:System Error Occured Rfc Call While Loading s8



    Hi Guys,

    while loading the data to ODS i got below error message ,

    *System error occured RFC call

    *Task 0083 for parallel SID assignment terminated with errors

    *Activation of data records from ODS object 0RSL_DS01 terminated

    *Error getting SID for ODS object 0RSL_DS01

    Can plz suggest wat to do?

    DB:3.13:System Error Occured Rfc Call While Loading s8


    Hi

    Just have a check if the RFC connectuion is fine...you can check it in this way -

    Go to RSA1 source systemright click on the source system form which you are extracting data.-- CHECK

    You will get a error if connection in not in place.. See the Reson of Connection failure.

    You may need to to contact Basis people to reestabilish the connection.

    Get back to me in case of any issues.

    Nandita.

  • RELEVANCY SCORE 3.13

    DB:3.13:Loading Issue mm



    Hello gurus,

    we have a ODS, which is feeding another 2 ods and it was fine for many days. Now we have realised the importance of another ODS and we want the data for this ODS by the same ODS which is feeding another 2 ods and we want to delta enable this. There is huge data in the base ODS. How can we make delta for all this 3 ods(2 old and 1 new) from the base ods. I should not disturb the 2 old ods. Any Ideas? Pls help me. I will assign the points you need.

    Thanx in advanve,

    raj.

    DB:3.13:Loading Issue mm


    hi Raj,

    say you have odssource, update to ods1 and ods2, now coming ods3 to be updated and 'delta'.

    try do 'full update' from odssource to ods3, and then 'initialize without data transfer' to all ods1, ods2, and ods3. this won't disturb ods1 and ods2.

    to full update, right click odssource 'update data target' and choose 'full update' and in infopackage schedule screen, mark data target ods3 only.

    after that 'update data target' again from odssource, and choose initial, and mark 'without data transfer' option and choose 'all data target' option.

    hope this helps.

  • RELEVANCY SCORE 3.13

    DB:3.13:Loading From Ods To Cube In Process Chain zs



    Hi Experts,

    How can I do a full load from ODS to cube when using further processing in process chain? Your help is much appreciated.

    Thanks,

    Bill

    DB:3.13:Loading From Ods To Cube In Process Chain zs


    Hi,

    You can use a DTP for this.

    Create transformation between DSO and cube.

    Create DTP and run it.

    Loading data from one cube to another cube.

    Cube to cube data loading

    how to upload data from cube to cube

    Can we pull data from one cube to another cube

    Data Load Steps:

    Reading data from another cube

    Hope this helps.

    Thanks,

    JituK

  • RELEVANCY SCORE 3.13

    DB:3.13:Error While Loading Data From Ods To Ods 77



    Hi Experts,

    When i'm loading the data from ods to further ods, i'm facing an error while activating the data saying that 0ref_doc_no consists of invalid characters.Also it is saying that Error when assigning SID.

    I'm unable to see the long text for further information.

    Regards,

    Vijay

  • RELEVANCY SCORE 3.13

    DB:3.13:Ods Activation Failure ma


    Hi,While loading data to ODS the data available in New data table.After Activating ODS manually , it throws error like this,"ODS Object Activation SID changed; from 0 to 27"Whats the meaning of this error? and How to slove this error?Thanks Regards,Arun.M.D

    DB:3.13:Ods Activation Failure ma

    Hi,SID error comes during activation of ODS because the related MD is not available for assigning SIDs.So as a first step ensure that the related master data is loaded and Attribute change run has been triggered.Or Load the MD and Activate the MD (Modeling InfoObject Search the Infoobject Right click Activate Master Data)Once you perform this you can retrigger the activation. It should work fine.Else as a workaround you can blank out these particular values and activate.There is also one more workaround wherein you can create the Master data entries directly in BW itself. But both the above step should be done after consulting Business and considering data volume that needs to be edited/created.In most case once you perform the loading and activation of MD your activation should work fine when repeated.There are cases where it failed again with the same error. In that case try this also (ensure that PSA is there).Delete the request in red.Go to monitorEdit Setting for further update Packet should be processed in the background.Edit Update Reversal Read everything manually YesBackground processing successfully scheduledThen you can see the Load running again.Once this is done perform activation again.Thanks,JituK