Skip to Content
0
Former Member
May 16, 2016 at 09:58 AM

How to copy calc. view with dependencies between packages

717 Views

Hi, Experts

I'm facing an issue to copy a calculation view with dependent attribute views from Package A to Package B in a smart way.

Eg.,
Package A

---Calc View: CALC

------Attribute View: ATTR_1

------Attribute View: ATTR_2

After copy, We got:

Package B:

---Calc View: CALC

------Attribute View: ATTR_1

------Attribute View: ATTR_2

I know we can use IMPORT/EXPORT tools in HANA Studio, but we need to change package names in all export files before IMPORT into a new package.

Another function of HANA Studio REFACTOR can only move views to another package one by one. actually cut, not copy. which will remove views from Package A and move to Package B. That's not what I need.

I'm thinking of reading "CREATE STATEMENT" of those views from and using them to create new view in Package B.

But I can't find the table/view store "CREATE STATEMENT".

Do you know what is that table?

or Is there some other methods to solve this issue?

Thanks.