asked on August 8, 2017
Hi, I am currently testing the product by connecting to SSAS,
but it tells me that it can not find the cube by name.
The error message is:
"The '<cube name>' object was not found.
Nombre del parámetro: index"
My embedded configuration is:
<body>
<div id="pivotContainer"></div> <script type="text/javascript" src="https://code.jquery.com/jquery-2.2.4.min.js"></script>
<script type="text/javascript" src="libs/flexmonster/flexmonster.js"></script> <script type="text/javascript">
$("#pivotContainer").flexmonster({
componentFolder: "https://cdn.flexmonster.com/2.3/",
toolbar: true,
report: {
dataSource: {
dataSourceType: "microsoft analysis services",
proxyUrl: "http://localhost:50006",
catalog: "<catalog name>",
cube: "cube name",
binary: true
}
},
licenseKey: "<key>"
});
</script>
</body>
Log:
2017-08-08 13:00:52.9919 | TRACE | Handshaking...2,316
2017-08-08 13:00:53.3900 | TRACE | Loading dimensions...
2017-08-08 13:00:53.4130 | TRACE | Connection string: Data Source=<datasource name>;Catalog=<catalog name>;
2017-08-08 13:00:53.4560 | ERROR | The '<cube name>' object was not found.
Nombre del parámetro: index
en Microsoft.AnalysisServices.AdomdClient.CubeCollectionInternal.get_Item(String index)
en Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.GetSessionId(String catalog, String credentials, String cubeUniqueName, String customData, String localeIdentifier, String effectiveUserName) en c:\FMprojects\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster Proxy SSAS\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:línea 919
en Flexmonster.Accelerator.Controllers.FlexmonsterProxyController.DiscoverDimensions(DiscoverArgs args) en c:\FMprojects\PIVOT\projects\Datasource Proxies\Microsoft SSAS\Flexmonster Proxy SSAS\Flexmonster.Accelerator.Core\Controllers\FlexmonsterProxyController.cs:línea 66
I tried the product by connecting it to a local cube and it did not cause problems.
Please help with this topic.
Sincerely
FPR
⋅ August 9, 2017
Hello Fabricio,
Thanks for the detailed description of your problem. Could you please check that the cube with such name exists and available?
Regards,
Tanya
⋅ August 9, 2017
Hi Tanya, thanks for you quick response.
The name of the cube is:
01 - Licitaciones
I attach the configuration from SSAS
Regards,
FPR
⋅ August 9, 2017
Hi,
It was no possible to attach the file.
As I said before the name of the cube is that. Also the id is
Oportunidades de Negocio
Should I pass the index corresponding to its position of the collection of cubes?
Regards
FPR
⋅ August 9, 2017
Hi,
In the end the problem was that my domain user had taken the permissions off.
After the user was impersonated in the web.config
<identity impersonate="true" userName="<domain\user>" password="<password>"/>
and the accelerator was opened with the following command to impersonate it
runas /netonly /user:<domain\user> C:\Flexmonster\server\flexmonster-proxy-ssas.exe
I could connect to the cube.
Another question, is it possible to impersonate from the same file flexmonster.config?
Thanks for your time
Regards
FPR
⋅ August 10, 2017
Hi Fabricio,
I'm glad to know that everything works fine for you.
Regarding a possibility to impersonate from configuration file I hope can find some useful information here:
http://www.flexmonster.com/question/restricting-users-access-when-using-the-accelerator/
Thanks,
Tanya
⋅ August 10, 2017
Thanks Tanya, i will check it
Regards
FPR
