Commit exploration in VBA

Post Reply
TimeTq
Posts: 6
Joined: Mon Jan 20, 2020 9:06 am
OLAP Product: TM1
Version: 2.0.9.58
Excel Version: 2019

Commit exploration in VBA

Post by TimeTq » Thu Feb 06, 2020 2:13 pm

Hi, does someone know, how to commit any changes in exploration with a VBA macros?

ascheevel
Community Contributor
Posts: 175
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Minneapolis, USA

Re: Commit exploration in VBA

Post by ascheevel » Thu Feb 06, 2020 2:37 pm

Have you looked through this: https://ibm.github.io/paxapi/#introduction


Edit:
The documented commit function for the PAX api is only available for Quick Reports. Looks like someone submitted an idea a year ago to add api support for exploration commit. You could use SendKeys to activate the PAX ribbon and "click" the Commit button, but this is clunky and I would bet prone to random failure.

Post Reply