Using COMPRESSION any Problem in Production ?

[Former Member]

Hi All,

we are woking in SD application in BI7.0.

We plan to use the compression in SD application area for the Sales Cube (VBAK and VBAP), Delivery Cube(LIKP and LIPS ),Billing Cube (VBRK and VBRP ) and Shipping Cube ( VTTK and VTTS).

The infoproviders are used in the infoset.The below mentioned scenario occurs in the data loads of the infoproviders because of which decided to use the COMPRESSION:-

Sales Cube Delivery Cube

Sales Doc Sales Qty Delivery Doc Del Qty Sales Doc

1 11 1 11 1

1 -10

1 10

InfoSet ( Before Compression)

Sales Doc Delivery Doc Sales Qty Del Qty

1 1 11 11

1 1 -10 11

1 1 10 11

The report developed on the will show Sales Qty = 11, but Delivery Qty = 33. Which is incorrect.

To avoid the above incorrect data planned to use the COMPRESSION so that the infoset will get the data as mentioned below

Infoset(After Compression):-

Sales Doc Delivery Doc Sales Qty Del Qty

1 1 11 11

The report developed on the compressed infoproviders will show Sales Qty = 11 and Delivery Qty = 11. Which is correct.

Please give your suggestions that using the COMPRESSION do create any problems in the Production or is there any other way ?

Thanks in advance.

LNV

[Former Member · Accepted solution]

Compression may not create any prob in your scenario. If the compression job is too huge, you may need to check on system resources.

[Former Member]

Hi ,

Thankyou for the above reply but as a precaution like to know that what are the scenarios where the COMPRESSION of the infoprovider creates a problem in Production System?

Thanks in advance.

LNV

[Former Member]

Hi,

When you compress the data, you are going to loose the Request ID and will not be able to delete any records in future incase you had to do some cleanup since there is no request ID for system to delete the records.

Hope this helps.

Datta.