1203972 - VLOOKUP works in Excel but not in Dashboard/Xcelsius

SAP Knowledge Base Article - Public

1203972 - VLOOKUP works in Excel but not in Dashboard/Xcelsius

Symptom

VLOOKUP works in Excel but not in Dashboard/Xcelsius.

Environment

  • Xcelsius 2008
  • Dashboards 4.0
  • Dashboards 4.1
  • Dashboards 4.2

Cause

The user might have the indexes for the VLOOKUP changing dynamically. This is not supported. The following is taken from the user guide:
 
Formulas are only partially supported for the index column of the lookup array. If the index column of the lookup array is a formula, the cell will always contain the initial value. Runtime changes to the value of that cell will not be reflected in the lookup array. Functions will work properly in all other columns of the lookup array. All other columns will contain the current value of a formula at runtime.

Resolution

Workaround:
  • Use a combination of INDEX and MATCH functions to return the values from your range.

Keywords

Xcelsius, 7250479, VLOOKUP, index column , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Dashboards 4.2 ; SAP BusinessObjects Xcelsius Enterprise 2008