Skip to Content
Author's profile photo Former Member

Issue while compression, table RSMDATASTATE

This is a real time scenario where I faced problem for the compression of an infocube.

  • In general there are scenarios where there is a delta upload to the infocube and when some data is missed you need to load it through Full load from another cube where data exists.

Issue:

  • Once you do full load from another info provider the cube stops compressing the info cube. When you try to compress it manually it throws a pop up saying the cube is already compressed.

Solution:

  • What happens internally is when you do a full load the table RSMDATASTATE is filled with the latest request in the field where ‘COMPR_DUAL ’: Request ID up to which InfoCube is compressed.

compr1.JPG

This field will be filled with the latest request id because of which the cube interprets that the compression is done completely.

What you have to do?

We need to change the request id in the field COMPR_DUAL and add the actual request till where the compression is done.

This solves the issue.

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      it took two days for me to find the solution for this problem, thank you santhosh.

      Author's profile photo Vinay Kumar P
      Vinay Kumar P

      Very useful point documented, Thanks

      Author's profile photo Former Member
      Former Member

      Hi  Santhosh,,

      Good blog..thanks for the sharing.

      Regards,

      Gurunath Kumar D

      Author's profile photo CH Raman
      CH Raman

      Hi Santhosh,

      Actually one person posted some abnormal statements in local language , so that' y i commented. its not related to content.

      Thanks

      Author's profile photo CH Raman
      CH Raman

      i think he may be deleted by seeing my reply. mine also deleted. No worrys.

      Author's profile photo Former Member
      Former Member

      Good work...bookmarked..

      Br,

      Arpit

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran

      Good one, thanks for sharing,,,

      BR,

      Prabhith

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Great work around... 🙂

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Nice info..