How to call a Primary Instance of a Shared Member in a rule?
Hello everybody,
I need to call only the @RELATIVE("S200000001",0) that have the attribute "X531" with an @INTERSECT function. I tried to do it in this way:
"9EX50010P0_" = @SUMRANGE("EX5001C"->"A4",@INTERSECT(@RELATIVE("S200000001",0),@ATTRIBUTE("X531")));
The problem is that the @RELATIVE("S200000001",0) are Shared Members and when I launch it anything is calculated, so, from what I have read, the shared members can not be called by an attribute, at least for calculations, because in Smart View I can cross a shared hierarchy with an attribute.
Does anybody know how can I call the primary instances from a list of a shared members? Is there any function? Is there a workaround to achieve what I am trying?
0