Error when loading a 25000 rows dimension

Answered
Everton de Rezende Matos asked on July 28, 2016

Hi.
We are connecting to a OLAP CUBE in Analysis Services 2014, but some large dimensions fail to load. When it happens, we get an empty error message (as shown in the print). 
When we drag and drop a Field to row or column box and click on OK button, it loads until 4734k and then it fails. (I'm not sure if it is 4737k members or kilobytes)
Is there configuration or parameter that we could set up?
Thank you.
 
 
 

2 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster July 29, 2016

Hi Everton,

I think it's a problem of the size. 25000 rows is not a large dimension and our component can smoothly load dimensions with millions of rows.

Could you tell if you connect to the cube via XMLA protocol or use our accelerator for Analysis Services? Did you check this tutorial http://www.flexmonster.com/doc/connecting-to-microsoft-analysis-services/?

Regards

Public
Everton de Rezende Matos August 1, 2016

Hi Dmytro,
Thanks for your reply.
I've checked this with our development team, they told me that we do use XMLA. They are now consulting the link you sent us. As soon as we get any progress, we let you know.
Regards.

Please login or Register to Submit Answer