Visual Totals in MDX and Role Security
Well I thought today we'd go over visual totals in MDX and also see how they may have an impact on how you assign role based security in you SSAS project.
Visual Totals in MDX are there to give you just what they describe – a sum on the children in a certain set. Child members which are not in the specified set will be ignored during the calculation. For instance, if I have a set that consists of: USA, New York, Washington and California, when I look at the total for USA, I will only see it's sum being consisted of that which belongs to New York, Washington and California. All the other states, such as Texas, Florida, Louisiana etc etc will not go into the calculation being run for the total for USA.
The basic syntax for visual totals would be: VisualTotals(Set_Expression)
In which case the "Set_Expression" would be the set you would like your calculations to run on.