Adding new field in DSO and CUBE without deletion of Data

[pavneet_rana]

Hi to all,

I have one scenario; please can any one tell me the solution for that.

Example:  I have enhanced the standard extractor with field A, and I have replicated the datasource to BI production system.

But my DSO and CUBE already contain the data in Production system and I can’t delete the data from DSO and CUBE, due to huge amount of data.

Now I want to add new field A in DSO and CUBE with out deletion the existing data from DSO and CUBE, so that old data comes with new field data.

How to do that in production system, and without deletion of data, is that practically possible.

if it is possible, does it will Corrupts  the delta initialization in DSO.

Please can any one share some light on it.

I shall be thankful to you for this.

Regards

Pavneet Rana

[pavneet_rana · Accepted solution]

Hi to all,

How we can add the new infoobject to DSO without deleting the historical data of DSO.

If it is possible.

Regards

Pavneet Rana

[RamanKorrapati · Accepted solution]

Hi Rana,

Same like info cube in remodeling, there you need to give info provider as DSO name, remaining steps are same, adding new info in data fields or key fields as your business needs.

Regards

[pavneet_rana · Accepted solution]

Hi Raman,

I cant understand you reply.

Please can you Elaborate it.

I am still confused , wether we can add new infoobject to DSO without deletion of data.

Regards

Pavneet Rana

[RamanKorrapati · Accepted solution]

Hi rana,

yes we can add new info obj without deleting data in DSO.

https://scn.sap.com/thread/2084487

the way your doing re modelling to info cube, same you can do it.you just need to give dso name and remaining steps are same followed while adding to info cube.

Regards

[pavneet_rana · Accepted solution]

Thanks for reply,

But i am working on BI  7.0 , is that possible in 7.0

regards

Pavneet Rana

[RamanKorrapati · Accepted solution]

Hi Rana,

In your bw  system T Code RSA1, if you have Remodeling option like below, in administration tab below, then possible on your system.

Regards

[former_member182470 · Accepted solution]

Hi Pavneet & Raman,

Remodeling for DSO is not possible. You can only do it for Infocubes.

[RamanKorrapati · Accepted solution]

Actually i didn't tried practically, read from some thread and made above statement. 

Thanks Suman for your info.

Regards

[pavneet_rana · Accepted solution]

Thanks for reply,

Then how i will add new infoobject in datafield of DSO, without deletion of data from DSO.

And how to get historicall data for new infoobject after then.

Regards

Pavneet Rana

[former_member182470 · Accepted solution]

Hi Pavneet,

This is a sensitive task. please be careful before doing. Follow the steps below:--

Step 1: Take a copy of your DSO and create TR/DTP between your original DSO and the Copy DSO

Step 2: Just do a Full load from Original to Copy

Step 3: Goto Change mode of orginal DSO and right click on Data fields and hit Infoobject direct-input

Step 4: Put the required object and hit Check-->Save-->Activate buttons. So that your orginal DSO with new field will be activated. All your current Transformations/DTPs get deactivated

Step 5: Map the new field properly

Step 6: If you want to load historical data to the new  field, then you need to drop all the DSO data and reload

Step 7: you do not want history data for new field, then you can start doing loads. new data will be populated for the new field

Regards,

Suman

[anshu_lilhori · Accepted solution]

Hi,

You can simply add new infoobject to dso without deleting or dropping the data.

If all the keyfigures are in overwrite mode then no need to drop the data also you can simply load the historical data old data will get overwritten and the value will get populated in new field.

If you do not need historical data then you can decide a cut off date since then data will be available for that new field.

No need to reinitialize.

Please take care of the points mentioned by suman----DTP ,Transformations will get deactivated.

If this dso is being used in some infosets or multiprovider then they will also get deactivated so you need to activate them as well.

As soon as you will add the new infoobject in DSO and after activating it will generate log which will have detailed information about the objects which got deactiavted.

You can note it down as it will help you track the changes and make smooth transports.

Hope this resolves your confusion and queries.

Regards,

AL

[pavneet_rana]

Hi to all and thanks for reply to all.

What i have understood from above reply thta.

1. we can add new infoobject to infocube via remodelling, if cube contain data.

2. we can add new infoobject to DSO, only after deleting the data from DSO.

still have one doubt does i need to re-initailzed the delta load for DSO agian after adding new infoobject to DSO.

Regards

Pavneet Rana

[Former Member]

Hi Pavneet,

No need to initialize delta again after adding any field

Regards,

Saurabh Singh

[Former Member]

Hi Pavneet,

Unless you do remodeling of cube, you cannot add an infoobject to a dimension of an infocube without deleting data.

And for DSO's concerned, you can add a new field unless it contributes for key fields.

One more point: Why would you want to blank field in your DSO or cube with the existing fields.

Even though the volume is huge, it's always better to drop data, generate transformation for this new field and reload data

Br,

H

[anshu_lilhori]

Hi Harsih,

I do not agree with you.

We can add any infoobject in DSO as well as cube even if data is there,no need to drop the data.

Kindly check the same on your system .

Regards,

AL

[Former Member]

Hi,

Yes , you can add field witout deleting data by remodeling .

Please go through link.

http://help.sap.com/saphelp_nw04s/helpdata/en/58/85e5414f070640e10000000a1550b0/content.htm

Regards,

Anand Mehrotra.

[Former Member]

Hi Anshu,

I tried adding a new infoObject to a dimension of an infocube which contains data.

The system hasn't allowed me to add this.

If I delete the data, then it's allowing me.

I believe this is the reason infocube remodeling has come into picture.

Br,

H

[Former Member]

Hi Anand,

That is what I mentioned. ''Unless you do remodeling, we cannot add infoobjects to a cube which contains data"

Br,

H

[Former Member]

Hi Harish ,

You can add fields in DSO and Cube Without deleting data ......only if u want to remove field then u hv to delete the Data.

I have checked adding field in  cube dimension which has data , for me its working

Regards,

Saurabh Singh

[anshu_lilhori]

Hi,

You can add the new infoobject in DSO as well as cube without deletion of data.

You cannot delete the infoobject if data is their but addition is very much possible.

As far as historical data is concerned for that newly added infoobject you need to load the setup tables and all.

In 7.0 full is possible after delta so you delta wont get corrupted.But i would still suggest to test it dev sever.

Hope that helps.

Regards,

AL