Easily Handle OLAP Cube Data using Vue Pivot Table
Tags: vue, development, olapserver, web
Published: 2024-06-14 03:49:27

---
title: Easily Handle OLAP Cube Data using Vue Pivot Table
published: true
date: 2024-06-06 13:13:26 UTC
tags: vue, development, olapserver, web
canonical_url: https://www.syncfusion.com/blogs/post/olap-cube-data-using-vue-pivot-table
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n046tewvqh8kzylp5p5c.png
---
**TL;DR:** Learn to bind and process OLAP cube data using Syncfusion Vue Pivot Table. This blog guides you through ensuring IIS and Analysis Services are installed and configured, creating an HTTP endpoint using IIS, setting up an application pool and virtual directory, configuring authentication, and adding a script map for msmdpump.dll. Finally, it shows you how to connect the OLAP cube to the Syncfusion Vue Pivot Table in your Vue app for intuitive data analysis and presentation.

An [OLAP](https://en.wikipedia.org/wiki/Online_analytical_processing "Wikipedia Link: Online analytical processing") cube includes dimensions, hierarchies, levels, measures, and named sets. It serves as a powerful tool for analyzing multidimensional data.

Leveraging OLAP data with the [Syncfusion Vue Pivot Table](https://www.syncfusion.com/vue-components/vue-pivot-table/olap "Vue Pivot Table") facilitates an intuitive presentation and exploration in tabular and graphical (also known as chart) formats. Additionally, reports can be dynamically customized using features such as the grouping bar and field list, and there is also the option to save reports for future use.

To connect multidimensional OLAP data with the Syncfusion Vue Pivot Table, an HTTP endpoint to access an Analysis Services instance is essential. This article will walk you through creating this HTTP endpoint using [Internet Information Services](https://en.wikipedia.org/wiki/Internet_Information_Services "Wikipedia Link: Internet Information Services") (IIS) on a Windows operating system.

Let’s get started!

## Prerequisites

Before you enable HTTP access to the OLAP server, ensure that a web server is running to host the web app that will access the OLAP server and that IIS is configured properly.

1.Click on **Start** in your system and select **Turn Windows features on or off**.[![Search for “Turn Windows features on or off”](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Search-for-Turn-Windows-features-on-or-off.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Search-for-Turn-Windows-features-on-or-off.png)
2.Go to **Internet Information Services**, expand it, and then further expand **World Wide Web Services** and **Application Development Features**. Verify that both **CGI** and **ISAPI Extensions** are selected.[![IIS settings expanded to verify CGI and ISAPI Extensions are selected](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/IIS-settings-expanded-to-verify-CGI-and-ISAPI-Extensions-are-selected.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/IIS-settings-expanded-to-verify-CGI-and-ISAPI-Extensions-are-selected.png)
3.Under **Security**, ensure that **Basic** **Authentication** and **Windows** **Authentication** are selected.[![Select Basic and Windows Authentication under Security](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Select-Basic-and-Windows-Authentication-under-Security.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Select-Basic-and-Windows-Authentication-under-Security.png)
4.Click **OK**  to install the selected features. With these steps, all necessary prerequisites are now configured.

## Preparing the IIS server

Before proceeding, confirm that IIS is already configured and that Analysis Services have been installed. If not, follow these steps:

### Install IIS

1.Click **Start**, then select **Turn** **Windows** **features** **on** **or** **off** option.
2.Select **Internet Information Services** and any other necessary features, then click **OK** to begin the installation.[![Install IIS](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Install-IIS.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Install-IIS.png)
3.Once installed, verify by searching for **IIS** in the **Start** menu and selecting **Internet Information Services (IIS)** from the search results.[![Verify IIS via Start menu search](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Verify-IIS-via-Start-menu-search.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Verify-IIS-via-Start-menu-search.png)

### Install SQL Server Analysis Services

To install **SQL Server Analysis Services** on your machine, follow the instructions provided in the [blog](https://learn.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=asallproducts-allversions "Blog: Configure HTTP Access to Analysis Services on IIS 8.0").

Once your machine has IIS and Analysis services installed:

1.Navigate to the IIS root directory, typically located at **C:\inetpub\wwwroot**.
2.Create a new folder named **OLAP** under **wwwroot**.[![Create New OLAP folder in wwwroot](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Create-New-OLAP-folder-in-wwwroot.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Create-New-OLAP-folder-in-wwwroot.png)
3.Copy the files **msmdpump.** **dll**, **mdmdpump.ini**, and the **Resources** folder from **C:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\bin\isapi** (adjust the path according to your installation).[![Copy files from SQL Server path.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Copy-files-from-SQL-Server-path..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Copy-files-from-SQL-Server-path..png)
4.Paste these files into the newly created **OLAP** folder.[![Paste files into OLAP folder](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Paste-files-into-OLAP-folder.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Paste-files-into-OLAP-folder.png)

Check that the **C:\inetpub\wwwroot\OLAP** folder on your machine contains  **msmdpump.dll, mdmdpump.ini**, and the **Resources** folders. Your folder structure should look like the above image. The IIS directory has now been set up.

## Creating an app pool and virtual directory in IIS

To set up an app pool and an endpoint for the pump, follow these steps:

### Create an app pool

1.Launch the IIS Manager by entering **inetmgr** in the **Run** command window.[![Open IIS Manager via inetmgr.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Open-IIS-Manager-via-inetmgr.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Open-IIS-Manager-via-inetmgr.png)
2.Right-click on **Application** **Pools**, and then select **Add** **Application** **Pool**.[![Right-click and add App Pool.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Right-click-and-add-App-Pool.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Right-click-and-add-App-Pool.png)
3.Using the .NET Framework, create an application pool named **OLAP** and set the Managed pipeline mode to **Classic**. Click **OK** to complete the process.[![Create OLAP app pool, Classic mode](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Create-OLAP-app-pool-Classic-mode.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Create-OLAP-app-pool-Classic-mode.png)
4.By selecting the **Application Pools** on the left panel, you will see the newly created pool named **OLAP**.[![View new OLAP pool in App Pools](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/View-new-OLAP-pool-in-App-Pools.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/View-new-OLAP-pool-in-App-Pools.png)
5.By default, IIS creates application pools with **ApplicationPoolIdentity** as the security identity, which is appropriate for HTTP access to Analysis Services. You can change this identity by right-clicking OLAP and selecting Advanced Settings and the **ApplicationPoolIdentity** if necessary. Click the **Change** button next to this property to replace the built-in account with the custom account.[![Change ApplicationPoolIdentity in IIS](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Change-ApplicationPoolIdentity-in-IIS.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Change-ApplicationPoolIdentity-in-IIS.png)
6.For the 64-bit operating system, IIS automatically sets the **Enable 32-bit Applications** property to **false**. If you copied the **msmdpump.****dll** from a 64-bit Analysis Services installation, this is the correct **MSMDPUMP** extension configuration for a 64-bit IIS server. If you copied MSMDPUMP binaries from a 32-bit installation, set **the** **Enable 32-bit Applications** property to **true**. Ensure this property is in **Advanced** **Settings** to ensure it is set correctly.

Now, the application pool has been created, but no apps exist. So, we need to create the application now.

### Create an application

1.In IIS Manager, go to **the** **Sites** section and locate **the** **Default** **Web** **Site**. You will see a directory named **OLAP**. This refers to the OLAP folder you previously created under **C:\inetpub\wwwroot**.[![Locate OLAP folder in IIS Sites](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Locate-OLAP-folder-in-IIS-Sites.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Locate-OLAP-folder-in-IIS-Sites.png)
2.Right-click on the **OLAP** directory and select **Convert** **to Application**.[![Right-click OLAP, select Convert](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Right-click-OLAP-select-Convert.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Right-click-OLAP-select-Convert.png)
3.In the **Add Application**  dialog, enter OLAP as the Alias. Click **Select** to choose the OLAP application pool and set the Physical Path to **C:\inetpub\wwwroot\OLAP**. Finally, click **OK**.[![Set OLAP Alias, choose pool, path, click OK.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Set-OLAP-Alias-choose-pool-path-click-OK.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Set-OLAP-Alias-choose-pool-path-click-OK.png)
4.When you refresh the website, you will see that the **OLAP** folder is now shown as an application under the default website. The virtual path to the **msmdpump** file has now been established.[![OLAP folder now an app; msmdpump path set.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-folder-now-an-app-msmdpump-path-set..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-folder-now-an-app-msmdpump-path-set..png)

## Configure authentication in IIS

1.Select the **OLAP** application in the left panel, then double-click **Authentication**.[![OLAP app selected, Auth double-clicked](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-app-selected-Auth-double-clicked-1.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-app-selected-Auth-double-clicked-1.png)
2.Enable **Windows Authentication** if you are using Windows-integrated security. If your client and server apps are in different domains, enable **Basic Authentication**. This mode will ask the user to enter a username and password, which are transmitted to IIS via the HTTP connection. When connecting to **msmdpump**, IIS will attempt to impersonate the user using the credentials provided, but Analysis Services will not be granted access to the credentials.  In such cases, you must provide a valid username and password when connecting.[![Windows Authentication Integrated & Basic](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Windows-Authentication-Integrated-Basic.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Windows-Authentication-Integrated-Basic.png)
3.If you use Windows or Basic authentication, disable **Anonymous Authentication**. IIS prioritizes Anonymous authentication when enabled, even if other authentication methods are also enabled.

## Adding a script map to the msmdpump.dll

1.Click on the **OLAP** virtual directory to open the main page, then double-click on **Handler Mappings**.[![Open OLAP dir, double-click Handler Mappings](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Open-OLAP-dir-double-click-Handler-Mappings.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Open-OLAP-dir-double-click-Handler-Mappings.png)

2.Right-click anywhere on the page, then choose **Add Script Map**. In the **Add Script Map** dialog, enter **\*.dll** as the request path, **C:\inetpub\wwwroot\OLAP\msmdpump.dll** as the executable, and **OLAP** as the name. Keep all the default restrictions on this script map. Then, click **OK**.[![Add script map .dll, msmdpump.dll, OLAP](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Add-script-map-.dll-msmdpump.dll-OLAP.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Add-script-map-.dll-msmdpump.dll-OLAP.png)
3.When prompted to allow the **ISAPI** extension, select **Yes**.[![Allow ISAPI extension Select Yes.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Allow-ISAPI-extension-Select-Yes..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Allow-ISAPI-extension-Select-Yes..png)

The script map named OLAP will now appear in the **Handler Mappings** list.[![OLAP map added to Handler Mappings](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-map-added-to-Handler-Mappings.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-map-added-to-Handler-Mappings.png)

## Testing your configuration

The **msmdpump** connection string syntax is the URL to the **msmdpump.dll** file. If the web app listens on a specific port, you should include the port number in the server’s name or IP address (e.g., **http://localhost:80/OLAP/msmdpump.dll** ).  
Use **Internet Explorer**, **Microsoft Excel**, or **SQL Server Management Studio** to test the connection quickly.

### Testing connections with SQL Server Management Studio

1.Open the SQL Server **Management Studio**. In the **Connect** **to** **Server** dialog box, choose **Analysis** **Services** as the server type. Enter the following HTTP address for the msmdpump extension: [http://localhost:80/OLAP/msmdpump.dll](http://localhost:80/OLAP/msmdpump.dll "Localhost").
2.Authentication should be set to Windows authentication, and the user of Management Studio must be an **Analysis** **Services** **administrator**. An administrator can grant additional permissions to other users.
3.Click **Connect** to establish the HTTP connection.[![Click Connect to establish the HTTP connection.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Click-Connect-to-establish-the-HTTP-connection..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Click-Connect-to-establish-the-HTTP-connection..png)

Now, you can connect to the instance and browse all the databases and cubes.[![Explore databases and cubes!](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Explore-databases-and-cubes.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Explore-databases-and-cubes.png)

### Testing connections using Excel

1.Open the Excel application and go to the **Data** tab.
2.To launch the Data Connection wizard, click on **Get** **Data**, then **From** **Database**, and select **From**  **Analysis** **Services**.[![Launch Data Connection Get, Database, Analysis.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Launch-Data-Connection-Get-Database-Analysis..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Launch-Data-Connection-Get-Database-Analysis..png)
3.In the Server name field, enter the HTTP address for the msmdpump extension: [http://localhost:80/OLAP/msmdpump.dll](http://localhost:80/OLAP/msmdpump.dll "Localhost").
4.If you use Windows integrated security, NTLM, or Anonymous as your login credentials, select **Use** **Windows** **Authentication**. For basic authentication, choose the **Use the following User Name and Password** check box and then specify the credentials used to sign in. These credentials will be included in the connection string to Analysis Services.
5.You can connect to the instance by clicking **Next** and browse the databases and cubes.[![Connect instance, browse DB & cubes.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Connect-instance-browse-DB-cubes..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Connect-instance-browse-DB-cubes..png)

## Enabling cross-origin resource sharing (CORS)

Web browsers, by default, prevent JavaScript from making requests across domains, a security measure known as the **Same-Origin Policy**. **CORS** (Cross-Origin Resource Sharing) enables web apps to make requests across domains securely. To enable CORS, we must follow these steps.

### Configuring HTTP response headers

To configure HTTP response headers, first, you must add the required headers in the **OLAP** app.

1.In the IIS manager, select the OLAP application in the left panel and then double-click on **HTTP Response Headers**.[![Manage OLAP app, tweak HTTP headers.](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Manage-OLAP-app-tweak-HTTP-headers..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Manage-OLAP-app-tweak-HTTP-headers..png)
2.Right-click anywhere on the page and select **Add**. In the Edit Custom HTTP Response Header dialog, set the **Name** to **Access-Control-Allow-Headers** and the **Value** to **Origin**, **Content-Type**, and **Accept**. Finally, click **OK** to add the header.[![Set Access-Control-Allow-Headers Origin, Content-Type, Accept](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Set-Access-Control-Allow-Headers-Origin-Content-Type-Accept.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Set-Access-Control-Allow-Headers-Origin-Content-Type-Accept.png)
3.Follow the same process to define the remaining two headers: **Access-Control-Allow-Origin** and **Access-Control-Request-Method**. The headers should be defined as shown below.
```
Access-Control-Allow-Headers: Origin, Content-Type, Accept
Access-Control-Allow-Origin: *
Access-Control-Request-Method: POST

```

Refer to the following image.[![](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Define-headers-Access-Control-Allow-Origin-Access-Control-Request-Method..png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Define-headers-Access-Control-Allow-Origin-Access-Control-Request-Method..png)

### Configuring the OPTIONSVerbHandler

1.In the IIS manager, select the **OLAP** application in the left panel and double-click **Handler Mappings.[![OLAP app Double-click Handler Mappings](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-app-Double-click-Handler-Mappings.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OLAP-app-Double-click-Handler-Mappings.png)**
2.Next, double-click on **OPTIONSVerbHandler** to open the **Edit** **Module** **Mapping** dialog.[![Edit Module Mapping OPTIONSVerbHandler](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Edit-Module-Mapping-OPTIONSVerbHandler.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Edit-Module-Mapping-OPTIONSVerbHandler.png)
3.Now, choose the **Request Restrictions** button.[![Select Request Restrictions now](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Select-Request-Restrictions-now.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Select-Request-Restrictions-now.png)
4.In the **Access** tab, select **Read** and then click **OK**.[![Select Read, click OK in Access](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Select-Read-click-OK-in-Access.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Select-Read-click-OK-in-Access.png)
5.On the right panel, click **View** **Ordered** **List** and ensure that **OPTIONSVerbHandler** is at the top of the **Handler**  **Mappings** list.[![OPTIONSVerbHandler on top View Ordered List](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OPTIONSVerbHandler-on-top-View-Ordered-List.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/OPTIONSVerbHandler-on-top-View-Ordered-List.png)
6.If not, select the **OPTIONSVerbHandler** and use the **Move Up** command in the **Actions** menu to bring it to the top of the list.[![Move OPTIONSVerbHandler to top](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Move-OPTIONSVerbHandler-to-top.png)](https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Move-OPTIONSVerbHandler-to-top.png)

## Connecting the OLAP cube to the Pivot Table

To connect the OLAP cube, ensure the Syncfusion Vue Pivot Table is integrated into your Vue app. If this integration is not yet in place, follow the installation and setup instructions provided by Syncfusion in the [documentation](https://ej2.syncfusion.com/vue/documentation/pivotview/olap "Get Started with Olap in Vue Pivot Table component").

Once created, configure the report below, replacing the [url](https://helpej2.syncfusion.com/vue/documentation/api/pivotview/dataSourceSettingsModel/#url "URL property for Vue Pivot Table"), [catalog](https://helpej2.syncfusion.com/vue/documentation/api/pivotview/dataSourceSettingsModel/#catalog "Catalog property for Vue Pivot Table"), [cube](https://helpej2.syncfusion.com/vue/documentation/api/pivotview/dataSourceSettingsModel/#cube "Cube property for Vue Pivot Table"), and [providerType](https://ej2.syncfusion.com/vue/documentation/api/pivotview/dataSourceSettings/#providertype "providerType property for Vue Pivot Table") properties with your values.

**[app.vue]**

```js
<template>
  <div id="app">
    <ejs-pivotview :dataSourceSettings="dataSourceSettings" :height= "height"> </ejs-pivotview>
  </div>
</template>

<script>
import Vue from "vue";
import { PivotViewPlugin } from '@syncfusion/ej2-vue-pivotview';

Vue.use(PivotViewPlugin);

export default {
  name: 'app',
  data () {
    return {
      dataSourceSettings: {
            catalog: 'AdventureWorksDW2014Multidimensional-SE',
            cube: 'Adventure Works',
            providerType: 'SSAS',
            url: 'http://localhost:80/OLAP/msmdpump.dll',
            enableSorting: true,
            localeIdentifier: 1033,
            rows: [
                { name: '[Customer].[Customer Geography]', caption: 'Customer Geography' },
            ],
            columns: [
                { name: '[Product].[Product Categories]', caption: 'Product Categories' },
                { name: '[Measures]', caption: 'Measures' },
            ],
            values: [
                { name: '[Measures].[Customer Count]', caption: 'Customer Count' },
                { name: '[Measures].[Internet Sales Amount]', caption: 'Internet Sales Amount' }
            ],
      },
      height: 350
    }
  }
}
</script>

<style>
@import '../node_modules/@syncfusion/ej2-base/styles/material.css';
@import '../node_modules/@syncfusion/ej2-buttons/styles/material.css';
@import '../node_modules/@syncfusion/ej2-dropdowns/styles/material.css';
@import '../node_modules/@syncfusion/ej2-grids/styles/material.css';
@import '../node_modules/@syncfusion/ej2-inputs/styles/material.css';
@import '../node_modules/@syncfusion/ej2-lists/styles/material.css';
@import '../node_modules/@syncfusion/ej2-navigations/styles/material.css';
@import '../node_modules/@syncfusion/ej2-popups/styles/material.css';
@import '../node_modules/@syncfusion/ej2-calendars/styles/material.css';
@import "../node_modules/@syncfusion/ej2-pivotview/styles/material.css";
</style>
```

After configuring the reports, execute the project using the command **_npm run dev_**. The Pivot Table will now be presented, as illustrated below.
<figure>

  <img src="https://www.syncfusion.com/blogs/wp-content/uploads/2024/06/Syncfusion-Vue-Pivot-Table-displaying-OLAP-cube-data.png" alt="Syncfusion Vue Pivot Table displaying  OLAP cube data" style="width:100%">

  <figcaption>Syncfusion Vue Pivot Table displaying  OLAP cube data</figcaption>

</figure>

## GitHub reference

For more details, see the demo in this [GitHub demo](https://github.com/SyncfusionExamples/How-to-configure-HTTP-Access-to-Analysis-Services-on-IIS-and-connect-it-to-the-Vue-Pivot-Table "GitHub demo: Pivot Table displaying OLAP cube data").

## Conclusion

Thanks for reading! In this blog, we have learned how to set up HTTP access to analysis services on IIS for optimal OLAP cube analysis and connect it to the Syncfusion Vue Pivot Table. So, try the steps explained in this blog, and share your thoughts in the comments section!

Our Pivot Table is a versatile component available across our [Blazor](https://www.syncfusion.com/blazor-components/blazor-pivot-table "Blazor Pivot Table"), ASP.NET ([Core](https://www.syncfusion.com/aspnet-core-ui-controls/pivot-table "ASP.NET Core Pivot Table"), [MVC](https://www.syncfusion.com/aspnet-mvc-ui-controls/pivot-table "ASP.NET MVC Pivot Table")), [JavaScript](https://www.syncfusion.com/javascript-ui-controls/js-pivot-table "JavaScript Pivot Table"), [Angular](https://www.syncfusion.com/angular-ui-components/angular-pivot-table "Angular Pivot Table"), [React](https://www.syncfusion.com/react-ui-components/react-pivot-table "React Pivot Table"), and [Vue](https://www.syncfusion.com/vue-ui-components/vue-pivot-table "Vue Pivot Table") suites. Use it to organize and summarize business data elegantly in any app!

For our existing customers, the latest version of Essential Studio can be downloaded from the [License and Downloads](https://www.syncfusion.com/account/downloads "Essential Studio License and Downloads page") page. If you are new to Syncfusion, try our 30-day [free trial](https://www.syncfusion.com/downloads "Get free evaluation of the Essential Studio products") to explore the available features.

For questions, you can contact us through our [support forum](https://www.syncfusion.com/forums "Syncfusion Support Forum"), [support portal](https://support.syncfusion.com/ "Syncfusion Support Portal"), or [feedback portal](https://www.syncfusion.com/feedback/ "Syncfusion Feedback Portal"). We are always happy to assist you!

## References

- [Syncfusion Vue Pivot Table Documentation](https://ej2.syncfusion.com/vue/documentation/pivotview/olap "Get Started with Olap in Vue Pivot Table component")
- [Creating Pivot Table with OLAP Data in JavaScript](https://www.syncfusion.com/blogs/post/create-pivot-table-with-olap-data-javascript.aspx "Blog: How to Create Pivot Table with OLAP Data in JavaScript")
- [Microsoft Learn: Configure HTTP Access to Analysis Services on IIS 8.0](https://learn.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=asallproducts-allversions "Article: Configure HTTP Access to Analysis Services on IIS 8.0")