RETURNVIEWHANDLE using a MDX view
-
- 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
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!
- 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
Which client are you testing in? Perspectives, PAfE, PAW?
-
- 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
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
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
-
- 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
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
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.
-
- 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
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
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
-
- 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
Thank you, I just voted. However there are only 13 votes .