cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member383962
Participant
0 Kudos

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

gireesh0909
Member
0 Kudos

how to get list of calculations views in a DEV/QUA environment in Hana?

Based one above sql query we will get he particular package list of objects, but my case need the list of TEST objects(calculation views) created in DEV environment.

We are doing cleanup activity for this needs to list out all the TEST objects in a Dev environment.

Could you please provide sql query for this requirement.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor

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

former_member383962
Participant
0 Kudos
Thanks florian.pfeffer

Regards

Kabil

Answers (0)