Question Re: delete data content for cube in QA??? in Technology Q&A

delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 08:05:09 GMT

Hi all,

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

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 08:49:18 GMT

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

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 08:56:26 GMT

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 CUBE. Delete the redundant/extra request.

Hope it Helps

Srini

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 08:57:30 GMT

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,

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 09:13:57 GMT

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.

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 11:24:45 GMT

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.

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 12:50:49 GMT

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

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 14:20:30 GMT

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

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 15:40:27 GMT

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.

Re: delete data content for cube in QA???

majeed_mohammedabdul — Fri, 14 Apr 2006 17:15:44 GMT

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

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 17:21:03 GMT

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

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 17:23:58 GMT

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.

Re: delete data content for cube in QA???

Former Member — Fri, 14 Apr 2006 17:31:43 GMT

Hi John,

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

Bye

Dinesh

Re: delete data content for cube in QA???

majeed_mohammedabdul — Fri, 14 Apr 2006 18:42:34 GMT

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