I have a requirement where in I need to find standard deviation of all the child nodes in a parent node.
Code looks something like this:
This works fine at all hierarchy. But when I apply filter on the cube browser for DIM_DEPARTMENT, the result is the same. Looks like Siblings function gets all the child node irrespective
of the filter. But if I apply filter on other dimensions, the formula gets standard deviation of filtered SalesCount, which is correct.
is the work around for this?
View Complete Post