Delete CV and CV Dims still visible for some users in HANA Studio

[Former Member]

We are team of 5 and are in SAP HANA Development and we notice a strange issue. I deleted few CV Dims and CV which we are not using it anymore for our project,

When I login to SAP HANA studio I am not seeing that CV Dims and CV, but few of our developers when they login to SAP HANA studio and they see it. It is visible for some developers and not visible for others and I am not sure why there is a inconsistency in the display of packages?

I really apprecaite any replies to this issue.

[Former Member]

Hi Tagu,

I had faced this issue as well. It is because of have inactive version still available.

If two developers tried to work on same model sometimes due to inactive versions this happens and the way i fixed it was by trying to first identify if there are inactive versions :

SELECT * FROM _SYS_REPO.INACTIVE_OBJECT WHERE PACKAGE_ID='<Package Name>'

and then delete

DELETE * FROM _SYS_REPO.INACTIVE_OBJECT WHERE PACKAGE_ID='<Package Name>'

You can even search for a particular object by using the field OBJECT_NAME

Let me know if this helps

Regards,

Aravind.

[patrickbachmann]

Can you paste a small screenshot?  The reason I ask is you use the term CV and then you mention packages so I want to make sure what you are referring to if it's a package or calc view or whatever it is you are mentioning.

-Patrick

[Former Member]

Sorry for the confusion, I was referring about the calculation views and calculation DIMS that was created under a package.