OLAP cube from Excel -
08-03-2006
, 04:46 PM
Hi all,
i have the follwong situation:
I have designed OLAP cube using Analysis Manager (MSSQL 200). Next I try to
open this cube using Excel 2003 and using OLAP data source. And if when I am
logged using administrator login then I see all data and I can drillthrough
any dimension. But when other user from users group try to do the same then
he can see the data but he can not drillthrough any dimension. Excel asks
about user id and password but any valid user id and password does not allow
to end this process sukcessfully. Who know what is the cause of this
problem?
TIA,
MP |