Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 OLAP in SQL Server

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2001-09-28 : 09:09:34
LYNN writes "Hello...

I would like to ask as we all know that Microsoft SQL Server has OLAP as an Analytical Processing.

My questions are :
1. How we can implement the OLAP through web browser by using pivot table in Excel as front end ? I have tried it several times but it can only be seen in my own web browser while others can't. The error message displayed is about the security authentication from times to times. Do we have to write mdx query manually ?

2. SQL Server has so many dts characteristics which are local packages, repository packages, and metadata. But I don't see the special characteristics and difference from three of them. Can you explain them to me shortly related to the implementation.

I will be waiting for your reply...

Thanks before

- Advertisement -