Hello,
Is there a formula in App Studio to read the weight of an element in a parent in the hierarchy?
Thanks a lot, Zsolt
Yes - try something like =ROA("BestPracticesOLAP","ANALYSIS","[Period]","Member_Weight",B7)B7 has a hyperblock with the period dimension:
See also docs.infor.com/.../default.html
Maybe just to add that the dimension or hierarchy name must be enclosed in square brackets. First time I did this I missed that. The ROA parameters are documented but they are (Alias,Cube,Dim/Hier, Attribute, Element).I don't know if it's possible to change the weight with RWA but I would caution against it as it would cause OLAP to recrate the element and it would be in a difference creation order which can matter,
Thanks a lot, worked perfectly :-D