Skip to Content
0

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

Feb 05 at 09:15 AM

38

avatar image

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....

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Feb 05 at 12:14 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Thanks Florian Pfeffer

Regards

Kabil

0