Dynamic calc members crossing dim with smart list member does not calculate
Summary:
Content (please ensure you mask any confidential information):
Hello, I have the following calculation
Sparse_DimA = @MEMBER(@CONCATENATE("HSP_ID_",@HSPNUMTOSTRING("SmartList Member")))→Sparse_DimB
Where [Sparse_B] is a dynamic calc parent. In this case, the operation is not working. When I change the [Sparse_B] with a level0 store member it does works, and if I try replacing the @MEMBER(@CONCATxxx logic to get the smartlist member value with a fixed member it works as well.
So, it seems the @MEMBER(@CONCAT…. operation is the issue, I tried with
SET HYBRIDBSOINCALCSCRIPT FULL;
SET FRMLBOTTOMUP ON;
SET FRMLRTDYNAMIC ON;
Tagged:
0