PAW export and send by mail automatically

Post Reply
nvillamor
Posts: 1
Joined: Fri Jul 10, 2020 8:52 am
OLAP Product: Oracle,sql
Version: PA 2.0
Excel Version: 2016

PAW export and send by mail automatically

Post by nvillamor »

Hello,

Is possible to export a book automatically and send it by mail?

Thank you
Adam
Posts: 94
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.x
Excel Version: Microsoft 365 x64

Re: PAW export and send by mail automatically

Post by Adam »

Hello!

My approach would be to create the views using PAFE API, perhaps CreateFromMDX. It's quite powerful. Then you can use VBA to generate the emails.

Different than your desire to use Planning Analytics Workspace, but Planning Analytics for Excel is more flexible.
Take care.
Adam
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: PAW export and send by mail automatically

Post by macsir »

I remember PAW cloud version has email sharing function but don't do it automatically.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply