delete data content for cube in QA???

[Former Member]

Hi all,

I found that I have <b>double load</b> issue for my CUBE in BWQ because <b>each record shows twice in the cube</b>. Can someone tell me what it happened and how to resolve it? Thank you.

J.

[Former Member · Accepted solution]

Hi John,

There would be no issues in deleting a request even in Production if you have duplicate data.

Bye

Dinesh

[Former Member]

Hi John,

In case it is a full load then delete any of the requests (if both the requests are same). RSA1 -> Infoprovider -> Cube -> Manage -> Select the request and click the "delete" button.

Bye

Dinesh

[Former Member]

View the cube contents.See that u have also selected request ID and request number in the field selections for output.

Sort the viewed records in such a way that u can view some doubled up records adjacent to each other.

Note the request numbers from a pair of doubled up records.

Go to the manage screen of the ODS and view the requests tab.There scroll to the right and there will be a column which shows the request ID and also another column that shows the request number.

Check the request ID's noted earlier.Most probably full update got doubled.Choose and delete one of them.

cheers,

Vishvesh

[Former Member]

Hi all,

I deleted the data content of CUBE in the BWQ and it requested me to reactivate cube (created request #). But I know that it is bad to do that in the BWQ. Is there any way I can fix it and avoid to create request in BWQ?

Can I re-transport cube to BWQ so the cube will be activate by it? Thanks.

J.

[majeed_mohammedabdul]

HI John,

Yes to have a consistency in all the systems , do the changes in the dev and then transport the changes to Q.

But first of all I wud try find out y it deactivated.

Because by dropping the data it wud not ask u to reactivate , u must have done something else or check the transports for last cpl of days , see if anything has been done by the transports.

Cheers

[Former Member]

Hi Majeed,

I was wondering the same thing too. Here is what I did:

go to cube-> select 'delete data content'-> then the cube is deactivated.

Do you know why?

Thanks

J.

[Former Member]

Dinesh,

Do you mean to delete 'previous request' and keep the latest one, then I can delete double loaded? If so, will it cause any problems in BWQ? Thanks.

J.

[majeed_mohammedabdul]

I dont know what happened, It shd ask u to reactivate the cube when u drop the data.

As for removing the double records , check from when u r seeing this double records and check the requests which are identical and delete the one of them . take care to delte the requests .

I wud check from when the records are being doubled and check the requests which caused them and then remove the requesrts which are identical.

Cheers

Majeed

[Former Member]

Hello John,

Shreya's suggestion will be valid in case of ODS.

In case of a cube you won't have that option.

go to manage screen of ur cube, find out the duplicate request(assuming it's a full load), and delete one of the requests, if both have same selection conditions and same no. of records.

This should resolve your problem.

Thanks,

[Former Member]

Hi John,

This can be due to the selections you have taken and if its a full load as specified by ABY, then find the duplicate request and just delete. If its compressed, it should be dealt in another way , Please let me know.

Thanks,

Krish.

[Former Member]

John

If your cube holds data from LO cockpit extractor (2LIS*) then may be some one had carried out fill set up table twice in SAP R/3 . Please validate this at your end.

[Former Member]

Hi John,

I think loaded twice. Check the requests(No) of the 2 records. You cant make to Overwrite while you are loading into a <b>CUBE</b>. Delete the redundant/extra request.

Hope it Helps

Srini

[Former Member]

Hi,

Instead of 'Add' select 'Overwrite' option from the update rules ....

If you want to suppress these doubled records you need to perform a compression on the InfoCube.

-Shreya