User cannot access virtual cube with calculated member

#1

I have SQL Server 2000 SP4 + Hot Fix and I am experiencing very strange
problem with Analysis Services.
I built 2 cubes and joined them in virtual cube. Actually, there are 2
versions of this virtual cube.
One with 'complicated' calculated member and one without.

Quote:

From the same account on which Analysis Services and SQL Server run but
from another machine I can easily manipulate both virtual cubes via

Excel 2000 Pivot Table.

Quote:

From another account, which is also in administrator group on the
server (and OLAP administrators as well) I can only manipulate the

easier version of virtual cube. When I try to refresh the more
complicated cube Excel hangs.
If you experienced similar situation please advise.

Thanks,
Mat

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

User cannot access virtual cube with calculated member

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

User cannot access virtual cube with calculated member - 10-24-2006 , 09:56 AM