cancel
Showing results for 
Search instead for 
Did you mean: 

Delete infoobject from an infocube with data

former_member254358
Participant
0 Kudos

Hi,

I have just added an infoobject to an infocube which has data. Now, I need to delete that infoobject and I think that if the infocube has data I couldnt delete the infoobject.

How can I delete the infoobject without removing the data?

Thanks a lot in advance.

Regards.

Accepted Solutions (0)

Answers (6)

Answers (6)

0 Kudos

Hi,

If you hav data in Cube or any target you want to remove any object from that target,

for that you only one option ie. REMOLDING of target

-->Right click on infocube

-->Additional Functon -->Remodeling

-->Remodeling Rule as Test

-->Create

-->Click on Add

-->Select Delete Char  and brows the corresponding Info Object

-->Schedule it

-->Also check that in Further Flow i.e. (Multiprovider and Infoset)

-->Remove it from there.

I hope its work.....

Regards,

Satya.

0 Kudos

Hi David,

deleting an infoObject from an database table is everytime difficult. The correct solution depends on different requirements:

  • How many datasets are in the infocube - how large is the cube.
  • Can you reload the data from a source or an DSO
  • Does your release support remodeling.

The best solution would be - delete the data, transport your change of datamodel to prod system and reload the data. The second solution could be: create an copy of the actual infocube, load the the data from the original cube to copy, delete the data from original cube, transport your changes to prod system, load the data from copy to "new"original cube, delete the copy.

You can also try to use the remodeling function. But there is no guarantee that this will work correct. We made some good and some bad experiences with this tool.

Cheers

J.

0 Kudos

Hi,

I hope you have done development work or changes in Developemt System.

My first suggestion:

Please drop the data and remove the info object from cube and activate the cube and reload the data.

My second suggestion is : we can go for remodelling too...But in this case not required i think.

Please try to go with first suggestion.

if you are happy with my explanation please give points.

Regards,

Satya.

Former Member
0 Kudos

HI,

Remodelling RSMRT. or u can u select right click and remodelling.

If you want delete info object u need to create remodelling in that option is ther delete character select run the remodelling.  after create remodeling rule.

In 7.X.

Regards,

Abdul Rawoof 

RamanKorrapati
Active Contributor
0 Kudos

Hi,

At which server you need to delete the data for info object.

if your at dev, you can delete cube whole data and remove the info object thru change mode.

in bw7.x there is way to delete the objects without deletion of cube data.

Please explore more about Remodeling concept.

Thanks

mr_v
Active Contributor
0 Kudos

You may need to go with Remodelling concept.

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

This seems to be DEV system, so better you delete cube data and remove infoobject.