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

Symptom

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.

Environment

• Analysis Edition for Microsoft Office 1.4
• Analysis Edition for Microsoft Office 2.0

Reproducing the Issue

Execute a AO workbook which has more than one HANA Data Sources.
Select “Merge Variables” in "Components" tab.
Input variables in prompt, click OK button.

Cause

The variables in HANA are local to each view, it is not global as in BW, so we don’t offer a merge across each view. It means the “Merge Variables” is not supported when HANA Data Sources are used in AO.

Resolution

Please do not use “Merge Variables”  for HANA Data Sources.

Keywords

Unsubmitted variables, Merge Variables, HANA, AO, Analysis for Excel