This article demonstrates the required steps to set up the OLAP Cube by using Microsoft SQL Server Analysis Services SSAS.
For detailed information on how to create, define, and deploy the OLAP multidimensional cube, refer to the MSDN multidimensional modelling tutorial.
To enable the HTTP access to SQL Server Analysis Services, use an
MSMDPUMP.ddl ISAPI extension.
For detailed information on how to set up the
MSMDPUMP.ddl extension, refer to the MSDN HTTP access tutorial.
For an online accessible OLAP service for test purposes, use
http://demos.telerik.com/olap/msmdpump.dll. Note that the URL does not open directly in the browser.
If the cube is not intended to be requested from different domains, skip this step.
For detailed information on Cross-Origin Resource Sharing (CORS), refer to this link.
To allow cross-domain requests to the OLAP service, enable the CORS behavior of your server. The following sections demonstrate how to enable CORS on an Internet Information Services (IIS) server. Cross-domain access requires you to configure the HTTP Response Headers and the
OPTIONS method server response.
To configure HTTP Response Headers, specify:
- The domains that will perform the data requests.
- An HTTP method through which the data will be transferred.
- The HTTP Headers that can be used in the requests.
- The user credentials that are going to be required if an authenticated access is used.
The following example demonstrates the list of the HTTP Response Headers that show the settings required to enable the IIS CORS behavior.
These are the names of the fields required to be used in the actual request. Values should be comma-separated.
The URI names that may access the resource. When an asterisk (*) is defined, all domains are allowed.
The names of the allowed domains should be separated by comma (,).
The name of the HTTP method to be used in the actual request.
The XMLA protocol specifies an HTTP
|Access-Control-Allow-Credentials (authenticated access only)||
The allowed values are:
To configure the
OPTIONS method server response, specify the server response to the
OPTIONS method requests. In IIS, configure the behavior of the
OPTIONS method through the
OPTIONSVerbHandler mapping settings.
The following example demonstrates the list of settings that you have to apply.
|HTTP Handler Name||Required Access Level||Details|
Specifies that the handler requires
To implement a secured access to the OLAP instance, use either of the following approaches:
- Use a proxy service which communicates with the cube on a secured protocol. This proxy should support the XMLA protocol. In the Microsoft world, the solution is to use ADOMD.NET. For detailed information on this, refer to this forum thread.
- Send the credentials with a request header, even though thus the Username and Password will be visible on the client side (browser). For details on how to pass credentials with request headers, refer to this StackOverflow discussion. You can define the required callbacks and settings directly in the
transport.readobject, as they will be passed to the
Other article on the Kendo UI PivotGrid:
For how-to examples on the Kendo UI PivotGrid widget, browse its How To documentation folder.