 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Data Warehousing / July 2006MS Analysis service over the web
Can I access the MS Analysis service over the web to delivery data to my customers that use Pivot Excel tables? RMelo yes, you can with AS2000 you need the enterprise edition. (search for the msolap.asp file) with AS2005 the standard and enterprise edition support this feature. In AS2005 the performance is better then AS2000 (take a look at the msmdpump.dll file) in the 2 cases, the connection go through IIS. > Can I access the MS Analysis service over the web to delivery data to my > customers that use Pivot Excel tables? > > RMelo Good! There is a good book about AS2005 that talk about this kind of tips? > yes, you can > [quoted text clipped - 10 lines] >> >> RMelo all you need is here: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx > Good! There is a good book about AS2005 that talk about this kind of tips? > [quoted text clipped - 12 lines] >>> >>> RMelo Hello RMelo, Agree with Jeje that you could config HTTP access to AS 2005 and you could use both OWC pivottable and Excel Pivottable. However, if you 'd like to manage AS 2005, you need to use AMO as mentioned in "Client tools to view cubes" thread you posted. If you have further questions on this, please feel free to let's know. Thanks. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at <http://msdn.microsoft.com/subscriptions/support/default.aspx>. ==================================================  SignatureThis posting is provided "AS IS" with no warranties, and confers no rights. Hello RMelo, Agree with Jeje that you could config HTTP access to AS 2005 and you could use both OWC pivottable and Excel Pivottable. However, if you 'd like to manage AS 2005, you need to use AMO as mentioned in "Client tools to view cubes" thread you posted. If you have further questions on this, please feel free to let's know. Thanks. Best Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at <http://msdn.microsoft.com/subscriptions/support/default.aspx>. ================================================== SignatureThis posting is provided "AS IS" with no warranties, and confers no rights. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.