My Oracle Support Banner

HSP_TEXT_CELL_VALUE Stores Decimal Places for Numeric Values Entered in Cells of Text Datatype within Planning Form in Smartview (Doc ID 1645218.1)

Last updated on APRIL 02, 2019

Applies to:

Hyperion Planning - Version and later
Information in this document applies to any platform.


Storing INTEGER value x in text data type cells automatically adds .000000 in the table HSP_TEXT_CELL_VALUE resulting in x.000000. Planning retrieve also provides the same result.

If the Smartview formatting options for decimal has been set to Default with decimal places to be displayed as 0 from the beginning, this issue does not occur. However, if the decimal places is set once to a number more than 1, it will store the values with the decimal places in the table and provides the same on retrieve. Even if the decimal places is set to 0 after that, it will still store the values with decimal places in them.

Issue occurs only in Smartview not in Planning web.

Steps to reproduce the issue:

1. Launch excel and connect to a Planning application via Smartview.
2. Open a form with a cell having a member of text data type.
3. Initially, when the decimal is set to default, enter some value for the text datatype member e.g 555 and submit it.
4. In smart view, the value shows as 555 and tool tip is not showing. In Planning web also its showing as 555, which is correct behavior.
5. Now set the decimal place to 1 or any other number by Smart View > Options > Formatting.
6. Change the cell value for the member from 555 to 777 and submit it.
7. Now if you select the data cell with value 777, tool tip is showing as 777.000000. The value in Planning web shows as 777.000000 which is incorrect.
8. This happen when numeric data for text data type cell is submitted and decimal value is set to any number except default.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.