🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

How to connect to SSAS Cube on localhost

Athul asked on March 7, 2019

I have an SSAS cube which is under development and it is running on localhost(localhost:56991). When I try to connect it through flexmonster accelerator I’m getting an error(Please refer the attached file). The configuration is as mentioned below. Could you please help me out to fix this. Please let us know the difference between catalog and cube(in the config) and how to find them.

container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
height: 600,
toolbar: true,
report: {
dataSource: {
dataSourceType: "microsoft analysis services",
proxyUrl: "/api/accelerator/",
catalog: "CareStackBICube_athul_4f51b40c-d0e6-4b23-96d7-12f2067d5f77",
cube: "CareStackBICube_athul_4f51b40c-d0e6-4b23-96d7-12f2067d5f77",
binary: true,
// role: "Practice"
slice: {
rows: [
{ uniqueName: "[FactProduction].[sPracticeKey]" }

public class FlexmonsterConfig
public static void Register()
// Replace with actual data source.
// Example: Data Source=localhost
Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.ConnectionString = "Data Source=http://localhost:56991";
Flexmonster.Accelerator.Utils.CacheManager.MemoryLimit = 10 * 1024 * 1024; // Mb to bytes
Flexmonster.Accelerator.Utils.CacheManager.Enabled = true;
//Flexmonster.Accelerator.Utils.LoggerLocator.SetLogger(new Flexmonster.Accelerator.Utils.ILogger());

Flexmonster Error.JPG

1 answer

Ian Sadovy Ian Sadovy Flexmonster March 7, 2019

Hello Athul,
Thank you for the question.
As for the error, it looks like there is no connection to the controller.
Please do the following to diagnose the issue:

  1. Check if there are errors in Chrome dev tools
  2. Check if there are requests like /api/accelerator/Handshaking, etc.
  3. Check if routing to the controller configured properly

Also, there is a working sample that you can use as a reference: https://github.com/flexmonster/pivot-accelerator-dll
As for the catalog and cube properties, you can find them in the SQL Management Studio.
Synonym for catalog is database, for cube – model.
Please let us know if it helps.

Please login or Register to Submit Answer