I have a script which looks like this
fix ("A",@relative("B",0),@relative("C",0))
"GP" = @Parentval(Product,"GP") * "V";
endfix
I am trying to understand and analyze how this script is working in Excel using smart view.
What I am trying to do is maybe make a pivot with "A", @relative("B",0), and @relative("C",0) by manually selecting those 3 from member selection.
Then I want to @Parentval(Product,"GP") and "V" then compare the result of the multiplication to "GP".
Is there a way to list the members that come up with @Parentval(Product,"GP") in excel using smart view?
Is there is a way to list the members that come up with commands like @Decendents() etc.?