cancel
Showing results for 
Search instead for 
Did you mean: 

Mass List /update HANA view properties

former_member184969
Participant
0 Kudos
501

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

View Entire Topic
pfefferf
Active Contributor
0 Kudos

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