My Oracle Support Banner

Smart View Refresh Does Not Work When Using The Now() Formula Against Hyperion Financial Management (HFM) (Doc ID 2692553.1)

Last updated on JULY 23, 2020

Applies to:

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


In an Excel sheet, connected to HFM via a Smart View private connection, the following layout has been set up:

Cell B1 contains the function =Now()
Cell B2 contains the function =TEXT(B1,"MMM")
Cell B3 contains the function HsGetValue (sample string shown below)


Excel will prompt to refresh the sheet, but attempts to do so yield no results. The specified POV is not applied.


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.