Smart View conflict when mixing Label and Alias when using HS_GET_VALUE function
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.