Mass List /update HANA view properties

[former_member184969]

Hi Experts

Working in an environment with multiple Clients on multiple replicated system, we have to modelize all of our vies with the 'Default Client' property set to 'Cross Client'

This is quite tricky as this parameter does not stand on the view creation form, and has to be modified once the view is created.

Developers sometime (often) forget to set it properly, which causes hazards with users not having a default client.

I am looking for a handy solution to list all views from a given package and check the values of Semantic properties. I could'nt find the system view for this.

Any hint is welcome.

Regards

[pfefferf · Accepted solution]

Hello Stéphane,

to my knowledge there are no dedicated columns in systems view which represents the semantic properties. They are stored in the XML of the information view.

The select

select *
from "_SYS_REPO"."ACTIVE_OBJECT"
where object_suffix in ('calculationview', 'attributeview', 'analyticview')
and cdata not like '%defaultClient="crossClient"%';

for instance returns all information views which default client is not set to "Cross Client" (on XS classic systems).

A restriction to a specific package can be done by restricting on column PACKAGE_ID in that table.

Regards,

Florian