Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Decimal value loading

652244Mar 24 2010 — edited Mar 24 2010
Hi Experts,

We are using Hyperion FDM 9.3.1 to load data to HFM. When we load decimal values , the output data file generated by FDM looks fine. But after loading the data to HFM, the decimal point does not appear. For example, when we load a value 698.7 , the value gets loaded as 6987 in HFM. Is there any setting in FDM that has to be set. This is happening only for certain locations.

Thanks
Kannan.

Comments

Günter

If your stored procedures are huge maybe a Java heap space problem ?

Billy Verreynne

Recompiling a stored proc requires an exclusive lock on the meta data object for the stored proc. Sessions using and executing a stored proc, or objects with dependencies on that stored proc, place a shared lock on the stored proc meta data object. This is to prevent runtime issues and errors to occur by changing the code of an in-use stored proc.
Thus a recompile session call can wait for an extended time for obtaining an exclusive lock for changing the stored proc.

3 people found this helpful
jflack

So, if your database is busy, and your procedures are being used a lot, let me suggest that you use edition-based redefinition to make your changes.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 21 2010
Added on Mar 24 2010
#business-intelligence-applications, #fdm, #financial-data-management, #import, #performance-management-applications
2 comments
1,669 views