Planning Analytics

Hello,

One of our on-prem customers moving to PA cloud.
Customer heavily use VBA on Perspectives workbooks.
I'll appreciate your input for easy migration of VBA code to PAfE using new API.

The problem with most VBA files is the tm1recalc command.
My knowledge in the VBA field is limited - I would appreciate your help converting the tm1recalc command in the VBA code.

part of the code:
Thank you,
Gabi

------------------------------
Gabi Cohen
------------------------------

#PlanningAnalyticswithWatson

HI Gabi,

It is not going to be without some effort and a lot of reading and testing.

Start your journey here - https://ibm.github.io/paxapi/#refreshsheet

Each report type has nuances and you may need to utilise different calls to refresh, rebuild or recalculate.


------------------------------
George Tonkin
------------------------------

Original Message:
Sent: Thu May 19, 2022 10:14 AM
From: Gabi Cohen
Subject: PAfE - migrating Perspectives VBA files to PAfE (tm1recalc)

Hello,

One of our on-prem customers moving to PA cloud.
Customer heavily use VBA on Perspectives workbooks.
I'll appreciate your input for easy migration of VBA code to PAfE using new API.

The problem with most VBA files is the tm1recalc command.
My knowledge in the VBA field is limited - I would appreciate your help converting the tm1recalc command in the VBA code.

part of the code:

Selection.AutoFilter Field:=12

Application.Run "TM1RECALC"

Selection.AutoFilter Field:=12, Criteria1:="TRUE"

Thank you,
Gabi

------------------------------
Gabi Cohen
------------------------------

#PlanningAnalyticswithWatson

Hello George,

Thank you for your quick respond and help.

Gabi

------------------------------
Gabi Cohen
------------------------------

Original Message:
Sent: Thu May 19, 2022 10:36 AM
From: George Tonkin
Subject: PAfE - migrating Perspectives VBA files to PAfE (tm1recalc)

HI Gabi,

It is not going to be without some effort and a lot of reading and testing.

Start your journey here - https://ibm.github.io/paxapi/#refreshsheet

Each report type has nuances and you may need to utilise different calls to refresh, rebuild or recalculate.


------------------------------
George Tonkin

Original Message:
Sent: Thu May 19, 2022 10:14 AM
From: Gabi Cohen
Subject: PAfE - migrating Perspectives VBA files to PAfE (tm1recalc)

Hello,

One of our on-prem customers moving to PA cloud.
Customer heavily use VBA on Perspectives workbooks.
I'll appreciate your input for easy migration of VBA code to PAfE using new API.

The problem with most VBA files is the tm1recalc command.
My knowledge in the VBA field is limited - I would appreciate your help converting the tm1recalc command in the VBA code.

part of the code:

Selection.AutoFilter Field:=12

Application.Run "TM1RECALC"

Selection.AutoFilter Field:=12, Criteria1:="TRUE"

Thank you,
Gabi

------------------------------
Gabi Cohen
------------------------------

#PlanningAnalyticswithWatson