Need your help.. I was trying to built an dynamic input template on BPC on S4HANA(Embedded) using Analysis excel using sapsetdata() formula..
Process – User will select CostCenter & select GL from the drop down cell & enter $ and hit save..
The problem is sapsetdata() is throwing #VALUE error if the GL4 is not present in the report but works fine for GL2 which already exist in the report as shown..
So looks like sapsetdata() does not consider members which is not present in the report.
Question – How to achieve this in analysis?
Thank you for reading!