Hyperion Essbase (MOSC)

MOSC Banner

Smart View conflict when mixing Label and Alias when using HS_GET_VALUE function

edited Jan 29, 2018 11:30AM in Hyperion Essbase (MOSC) 3 commentsAnswered ✓

Hello,

We have a Smart View workbook that makes extensive use of HS_GET_VALUE, such as this:

=HsGetValue(Connection,"Period#"&D$2,"Scenario#"&D$3,"Version#"&D$4,"Year#"&D$5,"View#"&D$6,"Currency#"&D$7,"Generic#"&D$8,"Source#"&D$9,"Type#"&D$10,"Account#"&$A20,"Department#"&$B20, "Entity#"&$D$1,"Location#"&D$11)

Some of the cell references are labels, and some are aliases. For me, every worksheet retrieves data correctly. For others, they get error messages that the account member is invalid. If they change the account member from the label to the alias, the data retrieval is successful. Some observe this issue on the Development environment, but get correct results in production. Some who experience this problem are admin users, so I think this rules out security.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center