How to copy calc. view with dependencies between packages

[Former Member]

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.

[Former Member · Accepted solution]

Hi Yang,

There is Mass Copy feature to solve the same requirement, using which one package models can be copied to another package with dependencies.

Choose Mass Copy link from Quick View and choose source and target packages

Click Next and add view from source package to target package

Click Next and Finish

All the models with dependencies will be copied from source to target package.

Best Regards,

Shireesha

[Former Member]

Hi Jiujiang,

Are you still facing the issue? Could I please know the status?

Regards,

Shireesha

[Former Member]

Thanks a lot, Shireesha.

That's almost a perfect alternative for my issue.

But MASS COPY will also copy the hierarchy of source package to target package.

What we need is ONLY copying views to another package without package hierarchy.

It will be perfect if there's an option to avoid hierarchy copy.

Regards,

Jiujiang