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());
}
}
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:
/api/accelerator/Handshaking
, etc.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