SQL Server Performance Forum – Threads Archive

Accessing Analysis Services through a web page

Hi I have just started using Analysis Services. I have created a cube on a remote server. I am trying to access this cube through a web page but getting an error. The error message says "The pivit table list ”” could not connect to the data source "CUST_PRFT". For information about the data source consult the creator of the file.(0x80004005)" The code behind the webpage is as follows. <html> <script LANGUAGE="VBScript"> <!– Sub Window_OnLoad() LoadControl End Sub Sub LoadControl() On Error Resume Next PivotControl.MemCheck On Error Goto 0 PivotControl.ConnectionString = "PROVIDER=MSOLAP;" & _ "DATA SOURCE=KLKYP1C; INITIAL CATALOG=[Customer Profitability]" PivotControl.DataMember = "CUST_PRFT" Set view = PivotControl.ActiveView view.ColumnAxis.InsertFieldSet view.FieldSets("YR_MON") view.RowAxis.InsertFieldSet view.FieldSets("RXDA") view.ColumnAxis.DisplayEmptyMembers = 0 view.RowAxis.DisplayEmptyMembers = 0 view.DataAxis.InsertTotal view.Totals("Tot Sls Amt") for each ttl in view.dataaxis.totals ttl.numberformat = "Standard" next On Error Resume Next PivotControl.MemCheck On Error Goto 0 End Sub //–> </script> <head> <title></title> </head> <body> <h2 align="center">Customer Profitability     </h2> &lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />> <object classid="clsid:0002E520-0000-0000-C000-000000000046" id="PivotControl" codebase="file://carw1001/wwwroot/owc/msowc.cab" style="HEIGHT: 384px; LEFT: 10px; TOP: 60px; WIDTH: 551px" width="518" height="384"> </object> </body> </html> Please advice. Irfan Najmi

Possible issues: -I think security could be an issue here. You need to have read privileges on the cube that you are trying to access. -Check your MDAC version (as far As I know, you need a compatible version of the Pivot Table Services)
Nathan H.O.
Moderator
SQL-Server-Performance.com

I installed MDAC 2.8 from Microsoft web site. It didn#%92t solve the issue. Please help. Irfan Najmi

Also when I try to register the remote server from Analysis Manager, I get this error "Cannot open connection to Analysis server ‘Server Name’ Error in data [Possible data corruption]." I know there is no data corruption on the server because the cube runs fine on the server. Irfan Najmi

I found an article on www.sqlmag.com that solved the problem. Now I can access the cube from the web. The name of the article is "Analysis Services Security and HTTP". The article id is 40909. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Irfan Najmi

]]>