Flexmonster Pivot Table & Charts provides an impeccable connection to Microsoft Analysis Services cubes.
Play with the demo on a larger screen: save this link for later or watch the video review now.
import * as FlexmonsterReact from "react-flexmonster";
import "flexmonster/flexmonster.css";
function PivotTableDemo() {
const report = {
dataSource: {
type: "microsoft analysis services",
proxyUrl: "https://olap.flexmonster.com:8085/",
catalog: "Adventure Works DW Standard Edition",
cube: "Adventure Works",
binary: true
},
slice: {
rows: [
{
uniqueName: "[Product].[Product Categories]"
}
],
columns: [
{
uniqueName: "[Customer].[Country]"
},
{
uniqueName: "[Date].[Month of Year]",
caption: "Month"
},
{
uniqueName: "[Measures]"
}
],
measures: [
{
uniqueName: "[Measures].[Internet Total Product Cost]",
format: "currency"
},
{
uniqueName: "[Measures].[Internet Average Sales Amount]",
active: false,
format: "currency"
},
{
uniqueName: "[Measures].[Gross Profit]",
active: false,
format: "currency"
}
],
drills: {
rows: [
{
tuple: ["[Product].[Product Categories].[Category].&[4]"]
},
{
tuple: ["[Product].[Product Categories].[Subcategory].&[28]"]
},
{
tuple: ["[Product].[Product Categories].[Subcategory].&[25]"]
}
]
},
memberProperties: [
{
levelName: "[Product].[Product Categories].[Product]",
properties: ["List Price", "Start Date"]
}
]
},
options: {
showMemberProperties: true
},
formats: [
{
name: "",
thousandsSeparator: ",",
decimalSeparator: ".",
decimalPlaces: 2
},
{
name: "currency",
currencySymbol: "$"
}
]
};
return (
<>
<FlexmonsterReact.Pivot
height={600}
toolbar={true}
report={report}
beforetoolbarcreated={(toolbar) => {
toolbar.showShareReportTab = true;
}}
shareReportConnection={{
url: "https://olap.flexmonster.com:9500"
}}
/>
</>
);
}
export default PivotTableDemo;
#fm-pivot-view .fm-grid-view div.fm-level-0.fm-cell,
#fm-pivot-view .fm-grid-view div.fm-level-0.fm-cell.fm-total {
background-color: #a7d6ae;
}
#fm-pivot-view .fm-grid-view div.fm-level-1.fm-cell,
#fm-pivot-view .fm-grid-view div.fm-level-1.fm-cell.fm-header,
#fm-pivot-view .fm-grid-view div.fm-level-1.fm-cell.fm-total {
background-color: #bee8c5;
}
#fm-pivot-view .fm-grid-view div.fm-level-2.fm-cell,
#fm-pivot-view .fm-grid-view div.fm-level-2.fm-cell.fm-header,
#fm-pivot-view .fm-grid-view div.fm-level-2.fm-cell.fm-total {
background-color: #e1f7e4;
}
#fm-pivot-view .fm-grid-layout .fm-grand-total {
background-color: #f5f5f5 !important;
}
#fm-pivot-view .fm-grid-layout span.fm-hierarchy-link {
color: #0d0d0d !important;
}
Our React pivot grid allows you to connect to OLAP cubes using the XMLA protocol or a much faster approach via Flexmonster Accelerator — a server-side proxy. Flexmonster works efficiently with both SSAS tabular and multidimensional models.
For connection via XMLA, check out the Connecting to Microsoft Analysis Services via XMLA guide to start with SSAS and React pivot table.
To learn how to connect to Microsoft Analysis Services or Azure Analysis Services with the highest performance, get straight to the Installing the Accelerator as a Windows Service guide.
Can't find your answer here?
Visit the FAQ page
Flexmonster Pivot Table & Charts is a JavaScript pivot table component for adding interactive reporting and data analysis to web applications. Users can summarize, filter, sort, and explore data in pivot tables and charts, drill into results, and export reports.
Flexmonster works in plain JavaScript and TypeScript projects. It also integrates with React, Next.js, Angular, Vue, Blazor, and other technologies. See all integration options.
Flexmonster supports JSON and CSV files, SQL databases, MongoDB, Elasticsearch, and Microsoft Analysis Services (SSAS). You can also connect other data sources through your own backend. See supported data sources.
Flexmonster offers licenses for internal corporate use, SaaS products, and OEM distribution. Pricing varies by license and plan. SaaS projects can also use the free SaaS Entry license during development. Learn more on the pricing page.
Yes. Flexmonster offers a 30-day free trial that lets you evaluate all its features. No credit card is required. The trial version has a watermark.
To get started with Flexmonster, follow our integration guide.