RETURNVIEWHANDLE using a MDX view

Post Reply
tm1dev
Posts: 4
Joined: Fri Aug 30, 2019 3:14 pm
OLAP Product: Planning Analytics
Version: Planning Analytics 2.x
Excel Version: 2016

RETURNVIEWHANDLE using a MDX view

Post 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!
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: RETURNVIEWHANDLE using a MDX view

Post by gtonkin »

Which client are you testing in? Perspectives, PAfE, PAW?
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: RETURNVIEWHANDLE using a MDX view

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
lotsaram
MVP
Posts: 3652
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: RETURNVIEWHANDLE using a MDX view

Post 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
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: RETURNVIEWHANDLE using a MDX view

Post by Wim Gielis »

Thank you Lotsaram, saves us time looking for functionality that is not there.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
tm1dev
Posts: 4
Joined: Fri Aug 30, 2019 3:14 pm
OLAP Product: Planning Analytics
Version: Planning Analytics 2.x
Excel Version: 2016

Re: RETURNVIEWHANDLE using a MDX view

Post by tm1dev »

Thank you, I just voted. However there are only 13 votes :(.
Post Reply