SAP Knowledge Base Article - Public

3440187 - No button or function works as expected after the usage of the parameter "TimerSetPlanQueriesToDisplayMode" in Analysis

Symptom

In Analysis for Office, no button or function works as expected after the usage of the parameter "TimerSetPlanQueriesToDisplayMode".

In the AO trace file, the following error message can be found: 

------------------------------------------------------
|FATAL  | General .NET Exception [859d-4deb-6a]:
TimeSpan period must be greater than or equal to zero.
Parameter name: value
------------------------------------------------------

Environment

SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

  1. Open Analysis for Office;
  2. Go to Analysis > Customize Analysis > Technical Configuration > TimerSetPlanQueriesToDisplayMode;
  3. Change the setting to a negative value and different from "-1";
  4. Close all AO instances and reopen again;
  5. Notice that any button or function works as expected in AO.

Resolution

This setting is used to specify the time in minutes Analysis is waiting to set planning queries from change mode to display mode.
The default value is -1. This means that Analysis won't set planning queries to display mode.

However, if any other negative number is used (except for "-1"), Analysis for Office will not work as expected and the mentioned error above will be recorded in AO trace file.

A value greater than or equal to zero must be entered for this setting to define the time for the switch in minutes and for Analysis to work as designed.

See Also

More about this setting can be found in PlanningConfiguration - TimerSetPlanQueriesToDisplayMode

2083067 - How to maintain settings for Analysis Office 2.x

Keywords

planning queries, TimerSetPlanQueriesToDisplayMode, change mode, display mode, TimeSpan , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8