Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Is it possible to add more than one dimension to subquery?

Bülent SARI asked on October 2, 2017

Dear Team,
We are trying to add a subquery to our report. Is it possible  to add more than one dimension to subquery?
Working example:
“dataSourceType”: “microsoft analysis services”, localeIdentifier: 1055,
“proxyUrl”: “https://xxx.xxx.xxx”,
“subquery”: “select {[TRA ORG].[UID].&[A2C13355-35D0-41E7-97E7-79B67DDC6837]} on columns from [FF]”,
“catalog”: “FF_OLAPP”,
“cube”: “FF”,
“binary”: true
 
We want to change the subquery as below:
“subquery”: “select {[TRA ORG].[UID].&[A2C13355-35D0-41E7-97E7-79B67DDC6837] and [PROD].[UID].&[A2C13355-35D0-41E7-97E7-79B67DDC6837]} on columns from [FF]”, 
 
Is it possible?
 Thanks for your support.

1 answer

Public
Dmytro Zvazhii Flexmonster October 4, 2017

Hello,
Thank you for writing. The query you have suggested is not correct since the members of query belong to different hierarchies. A set of members should contain the same dimensionality which is a fundamental rule of MDX, while the suggested query contains [TRA ORG] and [PROD].
Unfortunately, we are not aware of possible workarounds.
Regards,
Dmytro.

Please login or Register to Submit Answer