Hyperion Planning – Form Cell Text Data Does Not Show After Migration


We migrated a Hyperion Planning form from one environment to another and the text data does not show up.

Check to see it the text string exists in the new HSP_TEXT_CELL_VALUE table.

If so, that means that the relational store was migrated without issue.

 

In Essbase (i.e. retrieval from Hyperion Essbase Smartview), you will need to confirm that the corresponding numeric value stored in Essbase for that. particular intersection is there

You should then discover that there is text associated to that same numeric value in Hsp_cell_text_value in Planning schema.

If so, the cell text should show up.

If, however, if you did not bring over ALL the Essbase data, and the numeric value is missing as data (or showing as a 0) in the Essbase intersection, the text will not show in Planning for that intersection.

FYI: The text-numeric mappings in Planning schema are not deleted even if a user deletes the text value from Planning web form. And a new mapping gets created even if there’s a slight change in text value from an existing value. On the other hand, if the text value mapping exists in schema, it will be re-used.

Here is an example of the data in the Hsp_cell_text_value table:

13 “Is your area requesting new funding to support its FY 2015-16 plans and activities? If yes, please complete a new funding request form for each individual request. ”

6 Is your area requesting new funding to support its FY 2015-16 plans and activities? If yes, please complete a new funding request form for each individual request.

2673 “””Is your area requesting new funding to support its FY 2016-17 plans and activities? If yes, please complete a new funding request form for each individual request.””

If the numeric value in Essbase is 13,6, or 2673 the cell text will show in planning. If it is #mi or 0 it will not.

 

As a test you can save one of the numeric values from your table to the cell and check planning for the text.

To correct the issue, copy all of the relevant data to the Essbase intersections.

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s