DevExtreme React - XmlaStore API
The XmlaStore is a store that provides an interface for accessing an OLAP cube according to the XMLA standard.
The XmlaStore is used in the PivotGridDataSource which, in turn, is used in the PivotGrid UI component.
jQuery
var store = new DevExpress.data.XmlaStore({ url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }); // ===== or inside the PivotGridDataSource ===== var pivotGridDataSource = new DevExpress.data.PivotGridDataSource({ store: { type: "xmla", url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }, // Other PivotGridDataSource properties go here });
Angular
import XmlaStore from "devextreme/ui/pivot_grid/xmla_store"; import PivotGridDataSource from "devextreme/ui/pivot_grid/data_source"; // ... export class AppComponent { store: XmlaStore; pivotGridDataSource: PivotGridDataSource; constructor () { this.store = new XmlaStore({ url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }); // ===== or inside the PivotGridDataSource ===== this.pivotGridDataSource = new PivotGridDataSource({ store: { type: "xmla", url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }, // Other PivotGridDataSource properties go here }); } }
AngularJS
angular.module('DemoApp', ['dx']) .controller('DemoController', function DemoController($scope) { $scope.store = new DevExpress.data.XmlaStore({ url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }); // ===== or inside the PivotGridDataSource ===== $scope.pivotGridDataSource = new DevExpress.data.PivotGridDataSource({ store: { type: "xmla", url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }, // Other PivotGridDataSource properties go here }); });
Knockout
var viewModel = { store: new DevExpress.data.XmlaStore({ url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }) // ===== or inside the PivotGridDataSource ===== pivotGridDataSource: new DevExpress.data.PivotGridDataSource({ store: { type: "xmla", url: "http://my-web-srv01/OLAP/msmdpump.dll", catalog: "AdventureWorksDW2012", cube: "Adventure Works" }, // Other PivotGridDataSource properties go here }) }; ko.applyBindings(viewModel);
Vue
<script> import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store'; import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source'; const store = new XmlaStore({ url: 'http://my-web-srv01/OLAP/msmdpump.dll', catalog: 'AdventureWorksDW2012', cube: 'Adventure Works' }); // ===== or inside the PivotGridDataSource ===== const pivotGridDataSource = new PivotGridDataSource({ store: { type: 'xmla', url: 'http://my-web-srv01/OLAP/msmdpump.dll', catalog: 'AdventureWorksDW2012', cube: 'Adventure Works' }, // Other PivotGridDataSource properties go here }); export default { // ... data() { return { pivotGridDataSource } } } </script>
React
// ... import XmlaStore from 'devextreme/ui/pivot_grid/xmla_store'; import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source'; const store = new XmlaStore({ url: 'http://my-web-srv01/OLAP/msmdpump.dll', catalog: 'AdventureWorksDW2012', cube: 'Adventure Works' }); // ===== or inside the PivotGridDataSource ===== const pivotGridDataSource = new PivotGridDataSource({ store: { type: 'xmla', url: 'http://my-web-srv01/OLAP/msmdpump.dll', catalog: 'AdventureWorksDW2012', cube: 'Adventure Works' }, // Other PivotGridDataSource properties go here }); class App extends React.Component { // ... } export default App;
ASP.NET MVC Controls
@(Html.DevExtreme().PivotGrid() .DataSource(ds => ds .Store(s => s.Xmla() .Url("http://my-web-srv01/OLAP/msmdpump.dll") .Catalog("AdventureWorksDW2012") .Cube("Adventure Works") ) ) )
@(Html.DevExtreme().PivotGrid() _ .DataSource(Function(ds) Return ds.Store(Function(s) Return s.Xmla() _ .Url("http://my-web-srv01/OLAP/msmdpump.dll") _ .Catalog("AdventureWorksDW2012") _ .Cube("Adventure Works") End Function) End Function) )
The XmlaStore currently supports only the Microsoft Analysis Services OLAP tool. Refer to the Multidimensional Modeling tutorial for more information on it. To learn how to configure HTTP access to Analysis Services on IIS, see this article.
See Also
Configuration
Name | Description |
---|---|
beforeSend |
Specifies a function that customizes the request before it is sent to the server. |
catalog |
Specifies the database (or initial catalog) that contains the OLAP cube to use. |
cube |
Specifies the name of the OLAP cube to use from the catalog. |
url |
Specifies the OLAP server's URL. |
If you have technical questions, please create a support ticket in the DevExpress Support Center.