TI Function ViewMDXGet Not Working

Post Reply
User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

TI Function ViewMDXGet Not Working

Post by ptownbro » Wed Apr 18, 2018 7:10 pm

According to the documentation (link at the end), I should be able to use the "ViewMDXGet" TI function to return the MDX associated with a given View.

I've tried to use it as follows, but am getting an error stating the "variable viewmdxget is not recognized":

Code: Select all

MyViewMDX = ViewMDXGet('MyCube', 'MyView');
I've also tried using it on it's on and am getting an error stating there is something missing in the line:

Code: Select all

ViewMDXGet('MyCube', 'MyView');
https://www.ibm.com/support/knowledgece ... dxget.html

Wim Gielis
MVP
Posts: 1747
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: TI Function ViewMDXGet Not Working

Post by Wim Gielis » Wed Apr 18, 2018 7:32 pm

What version of TM1 / Planning Anaytics do you have ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

Re: TI Function ViewMDXGet Not Working

Post by ptownbro » Wed Apr 18, 2018 8:31 pm

I'm using Version 10.2.2

User avatar
tomok
MVP
Posts: 2464
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TI Function ViewMDXGet Not Working

Post by tomok » Wed Apr 18, 2018 8:37 pm

The link you pasted is for the the documentation from PA2.0. I've never used that function so I'm pretty sure it's not available in 10.2.2, unless it's in one of the last fix packs.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Wim Gielis
MVP
Posts: 1747
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: TI Function ViewMDXGet Not Working

Post by Wim Gielis » Thu Apr 19, 2018 8:40 am

ptownbro wrote:
Wed Apr 18, 2018 8:31 pm
I'm using Version 10.2.2
Then this functionality is too new for your environment.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

Re: TI Function ViewMDXGet Not Working

Post by ptownbro » Fri Apr 20, 2018 3:05 pm

Ah. Ok. Thanks guys

Post Reply