How to connect to SSAS Cube on localhost

Athul asked on March 7, 2019

Hi,
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.

//index.cshtml
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]" }
]
}
}
//FlexmonsterConfig.cs

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());
}
}

1 answer

Public
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.
 
Regards,
Ian

Please login or Register to Submit Answer