Page 1 of 1
RETURNVIEWHANDLE using a MDX view
Posted: Wed Apr 27, 2022 4:22 am
by tm1dev
Hello. It appears that views created via ViewCreateByMDX do not play nice with drill through-processes. The view passed in to the RETURNVIEWHANDLE function is not recognized. Is this expected behavior? Thank you in advance!
Re: RETURNVIEWHANDLE using a MDX view
Posted: Wed Apr 27, 2022 5:09 am
by gtonkin
Which client are you testing in? Perspectives, PAfE, PAW?
Re: RETURNVIEWHANDLE using a MDX view
Posted: Wed Apr 27, 2022 6:34 am
by Wim Gielis
tm1dev wrote: ↑Wed Apr 27, 2022 4:22 am
Hello. It appears that views created via ViewCreateByMDX do not play nice with drill through-processes. The view passed in to the RETURNVIEWHANDLE function is not recognized. Is this expected behavior? Thank you in advance!
Hello tm1dev,
Would it be possible to recreate the situation in for instance the sdata TM1 model ?
In addition, could you then share your processes/code/rules/views/... such that we can reproduce ?
I would be interested in looking at this one since it can be interesting. Notably, being able to create asymmetric views as the result of a drillthrough would be nice. It would then be consumed in PAW.
Re: RETURNVIEWHANDLE using a MDX view
Posted: Wed Apr 27, 2022 9:32 am
by lotsaram
MDX views are not currently supported for drill-through.
If enough people vote for this RFE then maybe it might get delivered.
https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-393
Re: RETURNVIEWHANDLE using a MDX view
Posted: Wed Apr 27, 2022 11:55 am
by Wim Gielis
Thank you Lotsaram, saves us time looking for functionality that is not there.
Re: RETURNVIEWHANDLE using a MDX view
Posted: Wed Apr 27, 2022 4:23 pm
by tm1dev
Thank you, I just voted. However there are only 13 votes
.