Planning Analytics

It sounds like your workload has other pending-volatile book content. By default PA for Excel will calculate to a stable-at-rest set of values (as a super set of whatever calculation scope you requested).  Please take a look at the documentation associated with the 'constrained calculations' feature, which when turned on - will limit extra activity.

https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_pax_constrainedcalculations.html

We have some additional abilities here that aren't in general doc that We could discuss with you, and we're also considering some additional refinements around constraint enforcement for vba workloads (don't yet have a sense of when that would be available, but at the existing level it's generally limited already when turned on).

Regards,

------------------------------
Ted Phillips

Original Message:
Sent: Thu March 18, 2021 07:43 AM
From: Constantin Budin
Subject: PAfE: Refreshing Behaviour Issue

Hello,

I am curious if anyone is experiencing the same strange refreshing behavior as I am and if  anyone has found a solution to it:

I am currently working on a rather large custom report with some VBA-Code. To make this report work, I have to refresh some cells multiple times while the code is running. For this I am using RefreshSelection as described in the PAfE API documentation.

The strange thing is PAfE is sometimes taking forever to refresh a selection, even if it is small. The time is often comparable to refreshing the whole sheet or book. Also, sometimes just calling RefreshSelection on an empty cell takes forever, which is surprising, since there is no Formula, which could be refreshed.

This behavior, as it stands, is unusable, since just running the affected once takes way too long.

I am looking forward to your responses

------------------------------
Constantin Budin
------------------------------

It sounds like your workload has other pending-volatile book content. By default PA for Excel will calculate to a stable-at-rest set of values (as a super set of whatever calculation scope you requested).  Please take a look at the documentation associated with the 'constrained calculations' feature, which when turned on - will limit extra activity.

https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_pax_constrainedcalculations.html

We have some additional abilities here that aren't in general doc that We could discuss with you, and we're also considering some additional refinements around constraint enforcement for vba workloads (don't yet have a sense of when that would be available, but at the existing level it's generally limited already when turned on).

Regards,

------------------------------
Ted Phillips

Original Message:
Sent: Thu March 18, 2021 07:43 AM
From: Constantin Budin
Subject: PAfE: Refreshing Behaviour Issue

Hello,

I am curious if anyone is experiencing the same strange refreshing behavior as I am and if  anyone has found a solution to it:

I am currently working on a rather large custom report with some VBA-Code. To make this report work, I have to refresh some cells multiple times while the code is running. For this I am using RefreshSelection as described in the PAfE API documentation.

The strange thing is PAfE is sometimes taking forever to refresh a selection, even if it is small. The time is often comparable to refreshing the whole sheet or book. Also, sometimes just calling RefreshSelection on an empty cell takes forever, which is surprising, since there is no Formula, which could be refreshed.

This behavior, as it stands, is unusable, since just running the affected once takes way too long.

I am looking forward to your responses

------------------------------
Constantin Budin
------------------------------

It sounds like your workload has other pending-volatile book content. By default PA for Excel will calculate to a stable-at-rest set of values (as a super set of whatever calculation scope you requested).  Please take a look at the documentation associated with the 'constrained calculations' feature, which when turned on - will limit extra activity.

https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/c_pax_constrainedcalculations.html

We have some additional abilities here that aren't in general doc that We could discuss with you, and we're also considering some additional refinements around constraint enforcement for vba workloads (don't yet have a sense of when that would be available, but at the existing level it's generally limited already when turned on).

Regards,

------------------------------
Ted Phillips

Original Message:
Sent: Thu March 18, 2021 07:43 AM
From: Constantin Budin
Subject: PAfE: Refreshing Behaviour Issue

Hello,

I am curious if anyone is experiencing the same strange refreshing behavior as I am and if  anyone has found a solution to it:

I am currently working on a rather large custom report with some VBA-Code. To make this report work, I have to refresh some cells multiple times while the code is running. For this I am using RefreshSelection as described in the PAfE API documentation.

The strange thing is PAfE is sometimes taking forever to refresh a selection, even if it is small. The time is often comparable to refreshing the whole sheet or book. Also, sometimes just calling RefreshSelection on an empty cell takes forever, which is surprising, since there is no Formula, which could be refreshed.

This behavior, as it stands, is unusable, since just running the affected once takes way too long.

I am looking forward to your responses

------------------------------
Constantin Budin
------------------------------