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.
⋅ 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.
