Implementing ESSBASE script in Excel smart view

380 views Asked by At

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.?

0

There are 0 answers