Get Free Trial

How to use local cube files without IIS endpoint ?

Argillier asked on November 15, 2017

I was using FlexMonster 2.1 flash version and I’m trying to update to last (2.407) js version.
Currently I got some microsoft analysis services cube files in a repository and I’m checking how I can load them by FM.
Do I have no choice to mount an IIS endpoint to serve them ?
I can not just call something like open(‘/cubes/toto.cub) ?

3 answers

Tanya Gryshko Tanya Gryshko Flexmonster November 15, 2017

Hello, Argillier,
Thank you for writing to our support forum.
There is a way to connect to cube without mounting an IIS endpoint. You need to deploy your cube via SSAS and connect to it via Flexmonster Accelerator. It is a special server-side utility developed by Flexmonster. For more details refer to our tutorial Getting started with Accelerator.
Please let me know about the progress.

Argillier November 15, 2017

Hello Tanya,
Thanks for your quick reply.
Well, I read our existing code and apparently we directly did something like that using nuget package “Microsoft.AnalysisServices.AdomdClient” :
var cnx = $”Data Source={local path to file.cub}; Timeout=30000; Connect Timeout=60000; Provider=msolap;”;
this.currentCubeConnection = new AdomdConnection(cnx);
With this connection, data can be requested. I guess Excel do something equivalent when opening the .cub file locally.
So my question is more like “can I give this output, parsed somehow or not, to FM” ?
For example I can create a new controller serving the content of the cub file rendered in xml or something else maybe (not sure of that).

Ian Sadovy Ian Sadovy Flexmonster November 16, 2017

Hello Argillier,
Thank you for the details.
Actually, Flexmonster supports XMLA protocol and theoretically, you can implement your own controller that will return data in the desired format. But honestly saying, it looks like a hard task. Usually, it is done using IIS and msmdpump.dll
Another option, as we said in the previous message, is to use FM Accelerator. But it also requires SQL Server and cub file cannot be used directly.
Please let me know if you have any further questions.

This question is now closed