3701488 - External tools cannot read or do not read the correct data of a scheduled AO workbook

When consuming the crosstab data from a scheduled workbook as input data in analytical tools like Power BI, Informatica, etc, some or all rows are not read/identified by the tool's query.

SAP Analysis for Microsoft Office (BI Platform Add-on)

Program error in AO BIP Add-on:
The dimension <x:dimension ref=""/> of the respective sheet <x:worksheet> is not updated in the workbook. This dimension address is used by external programs which read in this case a data range which does not reflect the current workbook.

The AO BIP Add-on code was corrected in version 2.8.28 as per SAP Note below:
3656829 - Precalc - Dimension address is not updated after scheduling

Workaround:
Opening the scheduled workbook from e-mail and saving it anywhere in your machine with no change at all before consuming its content with the analytic tool works.

3656829 - Precalc - Dimension address is not updated after scheduling

IICS, BOBJ, xml , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem