cancel
Showing results for 
Search instead for 
Did you mean: 

Analysis Office workbook scheduling error

Former Member
0 Kudos

Hi Experts,

Need your help.

We tried to schedule a Analysis workbook created on BEx query and got below errors.

1. "An error occurred: could not precalculate instance {0}"

2. "unexpected exception caught. Reason: [Java.lang.IndexOutOfBoundsExceptionIndex:0,Size:0]

We are on

SAP BI 4.1

Analysis Office 1.4

Please help me on this.

Thanks,

Rajendra

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi Rajendra,

Check SAP note 2134836 - Checklist for Scheduling of Analysis for Office Workbooks.
It will help you on this case.

Remember that we have some precalculation restrictions for the following workbook settings and elements:

  • The setting Refresh Workbook on Opening is ignored.
  • The setting Force Prompt for Initial Refresh is ignored.
  • If the setting Remove Data Before Saving is selected, the workbook is not precalculated.
  • If the workbook is in protected mode, it is not precalculated.
  • SAP formulas concatenating other SAP formulas are not precalculated.
  • Excel formulas are not precalculated.
  • VBA macros are not executed during precalculation.
  • Icons are ignored, for example arrows in conditional formats.
  • Comments are ignored.

And also the following prerequisistes must be met for the installation:

  • Administrative rights
  • Microsoft .NET Framework 3.5 SP1 or higher
  • BI platform 4.1
  • Workbooks saved on BI platform with file fomat .xlsx or .xlsm.
  • 64-bit operating system
  • Adaptive Job Server is installed

Thanks,
Diego Ferrary

Former Member
0 Kudos

Hi Diego,

According to PreCalculations-Restricitons, The A-Office workbook should "Comply" with Precalculation Restrication else scheduling will fail..Correct?

Cause i am seeing  the same situation, i have macros,  formulas created in another sheet(Say Sheet 2) referencing the Bex query data in another sheet (say Sheet 1).

when i scheduled the A-office  it is getting successful, but when i open the successful instance it still it showing the saved data only, not the refreshed data-set and all the calculations are showing the same old values.

Is there any workaround to fix this?

Former Member
0 Kudos

Hi Siva,

did you find a solution for this? Is there any function in Excel which you can use to force the re-calculation of the formulas?

Thanks,

Andreas

Former Member
0 Kudos

Andreas,

There is a work around i came up to fix this issue.

You have to write a macro, like on the work book initialisation, make sure all the formulas get updated like replace '='with '='  .

Done there goes the solution.  Gudluck

Former Member
0 Kudos

Hi rajendra,

we are facing the same problem too.

but in our case, if you add the user to Administrator group, scheduling is working fine.

I posted the question in SCN.pls check it.If SAP suggested the solution pls post.

http://scn.sap.com/message/15857514#15857514

Former Member
0 Kudos

Hi Experts,

Your help is highly appreciated.

Please help me.

Thanks,

Rajendra

TammyPowlas
Active Contributor
0 Kudos

Hi - I am not an expert in scheduling; if you need fast support, please create an incident with SAP Support