Hi,
I'm on Hyperion EPM R11.2.8 on-prem. In HPCM, we can copy a POV via the POV Manager to another POV; however, this functionality is limited to one target POV at a time. I need to copy one POV including the configuration (model and data) to multiple target POVs. Currently, the only way to achieve this is by copying the source POV to a target POV several times which is very time consuming when a user is setting up future POVs like Forecast for the next 3 years (36 times). Has anyone come across a way to achieve the same programatically. I have checked the documentation and I understand that there's a possibility to upload different HPCM artifacts to an HPCM module including POVs via staging tables but the steps aren't quite clear. When I check those tables/views, I get no results. My idea is to populate these tables, if possible, by the source POV information in the relational database via a custom SQL script to create the required target POV's and then upload the same to the HPCM module. If not, are there other ways?
Appreciate your thoughts.