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
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
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