Configure SSAs remote connection over HTTP in Vista.

Analysis Services Different from the Data Engine's own SA Verification Method , However, we cannot deploy the application in the actual production environment.ProgramBoth the server and the Analysis Server are on the same physical machine. , In this case, you need to configure remote access to the Analysis Service. . Currently HTTP Method , This document describes Sqlserver 2005 Analysis Services In Vista Configuration method under the platform .

This article is a reference:

Http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx

Written,Images are from this blog. AspnetxWriting this article does not belong to the nature of translation.,More descriptions are provided in some places than in the original document..

 

Generally, the configuration process is similar to that of IIS6 under winserver2003, but it is a little different because it is iis7.,First find the correspondingDLLFile,These files are usually stored in this directory.: % Installation folder % "OLAP" bin "ISAPI.

SetOLAPFolderIISVirtual directory under.

InIISCreate an application pool:

Set Related Properties:

Right-click the Directory,Select to convert to Application:

Follow the relevant settings:

AddHandlerIng:

Add a script ing:

Set as needed:

Click OK,Will prompt you if you wantEnableThis ing,Select Yes:

Add virtual directoryAuthentication:

Select as needed,Enable Anonymous Authentication.,But it may be insecure.. AspnetxEarlier in2003The practice in the Platform is to useAsp.netTo simulate related identities.,These identities areAnalysis ServicesCorresponding.In short, this step needs to be set according to the actual situation.Of course, if you are debugging on the local machine, you can try to addAdministratorsAccount of the Group.But do not do this in the production environment..

Last,Address similar to this: Http: // localhost/OLAP/msmdpump. dllYou can check whether the connection is available..This method is also supported.(I did not know this before.):

Iis7 is the same. The configuration method for Windows Server 2008 is basically the same. For details, refer to here:

Http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx

Indexing ing HTTP access to SQL Server 2008 analysis services on Microsoft Windows Server 2008

 

 

AspnetxA Problem:

you can customize roles and users in a multi-dimensional dataset . You can configure the data that can be viewed separately and which members are included in the dimension . if we use HTTP in this case, it is inevitable to be simulated as a user by IIS , if you use this interface to access the Analysis Service, it must be simulated as this user. and cannot correspond to users in the Analysis Service : for example, dimensions Dima and a, B, c, d, e ....... Member, at this time, A leaders can only view ABC, B leaders can only view def.

If there are few users, you can follow the methods described in this article to create several virtual directories andAsp.netSimulate different identities,But what if there are more users??Dozens of tasks,Creating a virtual directory one by one is not realistic,I wonder if you have any good ideas.,Please kindly advise.

 

Another: Silverlight for cube.Already doneM3Version,Currently, only one dimension can be defined on one axis.,For dimensions with layers, you canDrill Down,AsTo detial?,You can write detailed data from anywhere., CubeOrDB..Below are several.Because currently onlyM3Version,CodeAnd ugly,It will not be pasted.,And so onAlphaRelease again.

 

Select dimension (level)

 

Dimension without layers

 

Hierarchical dimension

 

Hierarchical dimension

 

Date drill-down