2126723 - "Unsubmitted variables" is displayed instead of result when “Merge Variables” is selected for HANA Data Sources

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

When execute a AO workbook which has more than one HANA Data Sources, and “Merge Variables” is selected. "Unsubmitted variables" is displayed instead of result. Or below warning message is displayed:

Variable <package name1>/<view name1>/<variable name1> is not compatible with variable <package name2>/<view name2>/<variable name2> (com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.selection.CartesianProduct-IncompatibleVariables)

SAP Analysis for Microsoft Office

Unsubmitted variables, Merge Variables, HANA, AO, Analysis for Excel , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , Problem