Migrating text data from Hyperion to Planning

Summary:

Migrating text data from Hyperion to Planning

Content (please ensure you mask any confidential information):

Hi,

We are trying to migrate text data from Hyperion to Cloud planning. However, we notice that the text data is not stored in the Essbase, instead, there are some ID used to represent the data and the actual text value is stored in Application's relational data.

We can use smartview to do this migration manually, however, due to the volume of the data, this become impossible. So we are trying to find another way (i.e. via Data integration) to achieve this.

I believe I can still upload the Hyperion export to Planning, but I am not quite sure how we can get the relational data part to planning. I tried manually update the relation data artifact in planning but it doesn't work and I got below error.