dbTalk Databases Forums  

Cube Drill through not working on some machines

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


Discuss Cube Drill through not working on some machines in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Web1987
 
Posts: n/a

Default Cube Drill through not working on some machines - 01-03-2006 , 08:51 AM






When drilling through on cubes, certain machines, the spawned window will
have a red x in the upper left hand corner. Machines are running Windows XP,
Office 2003 and OWC11.

Reply With Quote
  #2  
Old   
Peter Yang [MSFT]
 
Posts: n/a

Default RE: Cube Drill through not working on some machines - 01-03-2006 , 09:40 PM






Hello,

On the client computer with issues, please install ptsfull.exe (Pivottable
service + MDAC) again on the problematic client machine and reboot it.
Check the msolap80.dll file
(C:\Program Files\Common Files\System\Ole DB) & MSOLAP80.RLL. You could
download SQL 2000 SP4 and refer to the following article to reinstall
ptsfull.

829747 PRB: OLAP Cubes in an Analysis Services Database Are Not Accessible
After You Apply Analysis Services SP3
http://support.microsoft.com/default...b;EN-US;829747

Note: The folder is the same on SP4 install path.

Also, I suggest that you check if the users on these machine are in olap
admin group. If not, you may want to add them to the group to isolate
security issue

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
Quote:
Thread-Topic: Cube Drill through not working on some machines
thread-index: AcYQdR594nf614LVRL6lW6/rZy6sIQ==
X-WBNR-Posting-Host: 204.152.32.251
From: "=?Utf-8?B?V2ViMTk4Nw==?=" <Web1987 (AT) nospam (DOT) nospam
Subject: Cube Drill through not working on some machines
Date: Tue, 3 Jan 2006 06:51:03 -0800
Lines: 3
Message-ID: <25B94A6C-381B-4060-BD49-1EB530DBA6FE (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:65859
X-Tomcat-NG: microsoft.public.sqlserver.olap

When drilling through on cubes, certain machines, the spawned window will
have a red x in the upper left hand corner. Machines are running Windows
XP,
Office 2003 and OWC11.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.