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

Remodel

Hi,

I have a datastore and some data in it. Also the data is further uploaded to another cube. Now I want to remove an infoobject from my datastore.

Do I have to delete the data in my datastore to do this?

Also do I have to remove the data in the cube that I uploaded using this datastore?

Thanks,

Dona

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 03:03 PM

    Hi Dona,

    Suppose you have lots of data in your datastore coming from more difficult and timeconsuming extractors, it might be worth to consider a second option I have indicated.

    For example, suppose you need to reload all sales order data for 3 years from the source system. You will first need to schedule setup jobs to collect the data in the source system and subsequently transfer this data to BW.

    This collection of data and the subsequent trasnfer can be very timeconsuming.

    In this case I would recommend to make a copy of your datastore, make update rules or transformation to it (this will be just 1:1 easy mapping) and load your old data into the copy DS. After succesfull data transfer you delete the data in your original DS, and remove the field. Create update rules or transformation from copy to original and load data back into the original datastore.

    However, I would only do this (copy) in exceptional cases.

    E.g. it could also be timeconsuming to transport to copy model to production and cleanup afterwards, depending on the rules in your company. (Of the record : if you cannot create this copy model direct in production, I find it too much of a hastle to transport...).

    Also some technical impact to be considered is that you will have only 1 request ID left in your DS after the copy and that it will be more dangerous to activate an enormous dataset in one go (might need extra system resources)

    Hard to say when you could consider to copy and copy back.

    Using the standard is always best, unless you need to load 15 million order of course....

    Hope I did not confuse you too much...

    regards,

    Olav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 02:40 PM

    Hi Dona,

    In order to delete a field from your datastore you will have to delete the data contents first.

    Remodelling is not supported for datastores.

    You can reload from the source system afterwards or make a temporary copy to store the data in order to cop^y it back afterwards.

    For your infocube you could use the remodelling option but I feel it is not very stable at the moment.

    (SAP recommends to take a backup of your data before starting the remodelling, that says enough)

    If you are loading your cube from a datastore and you have no problem with historical data (e.g. no weekly snapshots of data contents in your cube), I would recommend to just delete the data from your cube, remove the field and reload it from your datastore.

    Hope this helps.

    Do not hesitate to ask further questions.

    Please assign points if this was usefull to you.

    Best regards,

    Olav

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Olav,

      Thanks for the solution.

      I have a quick question again.

      "You can reload from the source system afterwards or make a temporary copy to store the data in order to copy it back afterwards."

      Do you mean I make another copy of my datastore and load the existing data and reload it back to my original datastore after I removed the InfoObj that I dont need?

      Thnx,

      Dona

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.