dbTalk Databases Forums  

Problem with excel and AnalysisServices

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


Discuss Problem with excel and AnalysisServices in the microsoft.public.sqlserver.olap forum.



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

Default Problem with excel and AnalysisServices - 03-09-2005 , 10:49 AM






Hello everybody,
I've this problem:
Scenario
Our project is to do HTTP reporting on an AS cube, using PTS and dynamical
tables.
Our environment is: SQL server 2K on a windows 2k server. We have
domain, IIS 6. Clients are using win2k pro or Winxp pro + excel 2000. All
clients have latest PTS / MDAC / OWC etc.
We tried HTML and ASP pages.

Problems
If i export in a workbook the pivot table from the ASP page to excel i've
not problems.
If i create a workbook with 2 worksheet, both of them with a pivot table
linked to a different OLAP Cube, it is happens that everytime i click on
every field or dimension, it appears the domain login/pwd form.
Help me please.
Tanks

Reply With Quote
  #2  
Old   
Sunshine Lee via SQLMonster.com
 
Posts: n/a

Default Re: Problem with excel and AnalysisServices - 03-09-2005 , 09:07 PM






I meeted the same problem in Excel 2000. But in Excel XP, it doesn't happen.

--
Message posted via http://www.sqlmonster.com

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.