I have a situation where i need to designate "user A" to use
"hierarchy 1" and "user B" to use "hierarchy 2" when they both open
the same cube in Excel. Can I control this based on their
authenticated ID? If so, How?

Thanks...

The closest thing Analysis Services has is dimension security. Look at BOL
for additional information. While it can't control entire hierarchies, you
can control what members in a dimensions that each user can see.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rico Cali" <ricocali (AT) hotmail (DOT) com> wrote

Dave,

I looked at Books Online for Hierarchies and Security and cant find
anything. Any hint of what I should be looking at?

Thanks,
Rico

you can simply disable the access to the dimension B to the user A and
dimension A to user B
This cause the user to see only accessible dimensions, but if a user A save
an excel document with a dimension A and send it to the user B, the
dimension disappear, and the user B must manually put the dimension B in the
report.

does this answer your problem?

"Rico Cali" <ricocali (AT) hotmail (DOT) com> a écrit dans le message de
news:675e1895.0408140603.427459d7 (AT) posting (DOT) google.com...