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

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 How Cube can be displayed on Webpage

Author  Topic 

Kirun
Yak Posting Veteran

60 Posts

Posted - 2009-02-17 : 07:21:20
This is getting me mad actually. I have cube in my AS 2005 and i want to display it on webpage on intranet. I tried to export cubes from excel to make a webpage but it works fine on my machine but as soon as i accessed it from other user machine with other user's credentials it gives me error that "the query could not be processed".is this the error of some kind of authentication issue on cubes or some thing is missing from client side. do i need to install some thing on client side too to remove this error please sugegst.
I also tried to use OWC 11 from Visual Studio.net and tried to give my password and userid.Still it havent work.

Suggest what can be the problem or suggest any other way to display cube with pivot table functionality to my intranet users.

gedwards
Starting Member

19 Posts

Posted - 2009-02-17 : 11:22:50
It sounds like you have the website on one machine, and SSAS on another. Have you looked into setting up Kerberos?
We use Windows Authentication, have Kerberos setup, and access our cube on another server.
Greg E

Greg E
Go to Top of Page

Kirun
Yak Posting Veteran

60 Posts

Posted - 2009-02-19 : 00:34:08
no the website and the SSAS are on the same machine and still when i access it with any other client on my domain machine it gives me error of query cannot be processed .. i wonder what is causing this error ... any body have any idea or any other way.. i dont know about kerberos ? what is this .. please explain ... thanks
Go to Top of Page
   

- Advertisement -