Skip to Content

Mass List /update HANA view properties

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Sep 15, 2016 at 05:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded