SAP Knowledge Base Article - Public

2603528 - Merge Variables is not working for HANA data sources

Symptom

Two or more different HANA data sources are inserted in same report.

The "Merge Variables" option is used.

When opening the variable screen, the variables with the same name are not merged.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office
SAP BusinessObjects Design Studio
SAP BusinessObjects Lumira Designer

Cause

Merging of HANA variables/input parameters is not supported across different HANA views. Even if the variables have exactly the same name or technical ID they will not be merged.

Resolution

Variable merging with HANA views only works if the same view is inserted multiple times.

Keywords

hana, view, calculation, query, input, parameter, var, unable , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AD-HAN , HANA Integration , BI-LUM-DER , Lumira Designer , Problem

Product

SAP Analysis for Microsoft Office all versions