I want to enable visual totals on a parent-child dimension using DSO. I
cannot find a way to directly enable visual totals. The only documented
way is to set the VisualTotalsLowestLevel attribute in the
MEMBERSECURITY element of the dimension security. However, I do not
know how to set the lowest level because the DSO objects only have a
single level in the parent-child dimension. While viewing the cube, the
levels get expanded based on the parent-child relationships in the
data. Does anyone know how I can get around this?

What I recommend is that you get a copy of the metadata scripter on the SQL
Server 2000 Resource Kit. You can setup whatever structures you wish using
Analysis Manager and then run the metadata scripter. It generates a VB6
program that duplicates the settings on the current objects. Then you read
the program to see how it does it via DSO.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"cneiltx" <c_rneil (AT) yahoo (DOT) com> wrote

Thanks for the reply Dave. I ran the metadata scripter but
unfortunately it does not help me because it simply pulls the
permission attribute value from the cube (which has been set by
Analysis Manager) and includes it in the script. It did at least
confirm for me that Analysis Manager is setting the
VisualTotalsLowestLevel to the lowest "blown out" level of the
parent-child dimension (in this case "Level 06"). My problem is that I
have no idea how to figure out the lowest level of the parent-child
dimension in order to set the property. How do I determine if it's
"Level 03" or "Level 10" or some other value? I haven't found anything
in the docs so far.

Dave Wickert [MSFT] wrote: