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 , Obsolete: BusinessObjects 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