Commit exploration in VBA
-
TimeTq
- Posts: 9
- Joined: Mon Jan 20, 2020 9:06 am
- OLAP Product: TM1
- Version: 2.0.9.58
- Excel Version: 2019
Commit exploration in VBA
Hi, does someone know, how to commit any changes in exploration with a VBA macros?
-
ascheevel
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Commit exploration in VBA
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.
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.