Get Free Trial

Subquery don’t work using microsoft analysis services.

Eduardo Verri asked on January 4, 2017

I’m using a subquery like this link but not filtering.The Flexmonster Accelerator Manager Log MDX querys every change, but it’s not using the code:
     “dataSource”: { “dataSourceType”: “microsoft analysis services”,
     /* URL to the Data Speed Accelerator */
     “proxyUrl”: “”,
     /* Catalog name */
     “catalog”: “My Cube”,
     /* Cube name */
     “cube”: “My Cube”,
     “subquery”: “select {[Dimension].[Property].&[Value]} on columns from [MyCube]”,
     /* Flag to use Data Speed Accelerator instead of XMLA protocol */
     “binary”: true

2 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 5, 2017

Hello Eduardo Verri,
Thank you for your question. We’ve prepared for you jsFiddle example with subquery . Is it possible to get access to “”:” or send us log file? It will help us a lot with the investigation of your issue.
Waiting for your feedback.

Roman Petrusha Roman Petrusha Flexmonster January 6, 2017

Hi Eduardo,

Please check if you have the latest version of the accelerator tool because ‘subquery’ feature is available only from version 2.304. If you have the older version please download and upgrade to the latest one.


Please login or Register to Submit Answer