Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

HsSetValue not working with HFM application

User_YZQL2Jul 11 2018 — edited Aug 6 2018

Hi All,

I have a HFM application and am trying to create a smartview template for data submissions. The submissions would mostly be done using HsSetValue function and validated using HsGetValue. The issue is that while HsGetValue is working fine using the same POV(mentioned in different cells in the excel), HsSetValue throws error saying 'The POV is invalid' . Below is a brief on the setup and the issue I am facing

pastedImage_0.png

Above is how the grid has been designed. The cell(J3) has the HsGetValue being used which works fine, while cell(K3) has the HsSetValue functions, which when run gives the following error

pastedImage_3.png

Below are the HsGetValue and HsSetValue functions that have been used

=IFERROR(HsGetValue("HFM_conn","Custom_dim2#"&$E3&";"&"Account#"&$B3&";"&"Period#"&$J1&";"&"Custom_dim1#"&$D3&";"&"ICP#"&$C3&";"&"SubAccount#"&$F3&";"&"Custom_dim3#"&$G3&";"&"Custom_dim4#"&$H3&";"&"DataType#"&$I3&";"&"Year#"&$F8&";"&"Scenario#"&$G8&";"&"View#"&$H8&";"&"Entity#"&$I8&";"&"Value#"&$J8),"")

=hssetvalue(100,"HFM_conn","Custom_dim2#"&$E3&";"&"Account#"&$B3&";"&"Period#"&$J1&";"&"Custom_dim1#"&$D3&";"&"ICP#"&$C3&";"&"SubAccount#"&$F3&";"&"Custom_dim3#"&$G3&";"&"Custom_dim4#"&$H3&";"&"DataType#"&$I3&";"&"Year#"&$F8&";"&"Scenario#"&$G8&";"&"View#"&$H8&";"&"Entity#"&$I8&";"&"Value#"&$J8)

Lastly, the submissions are working fine using a data form and even through an adhoc grid. But for my process to work, I need the HsSetValue to work. Any help here is much appreciated.

Thanks,

Dev

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2018
Added on Jul 11 2018
6 comments
968 views