Skip to Content

how to get list of calculations views in a package in hana?

Hi Experts,

I want the list of Calculation Views in my particular package.

For Example:

Package : KABIL_PRACTICE

And it Contains 10 Calculation views. I want to take a list of Calculation views in my KABIL_PRACTICE Package.

Is there is any way to get the required result set in HANA....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 05 at 12:14 PM

    As you are (still) working with XS Classic you can get the information from table "ACTIVE_OBJECT" in schema "_SYS_REPO". Of course you need the required select privilege for the table.

    select * from "_SYS_REPO"."ACTIVE_OBJECT" 
    where package_id = 'KABIL_PRACTICE'
    and object_suffix = 'calculationview';

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded