2262899 - Transfer Multiple Single Values to HANA Model Input Parameter in a BW Query

Symptom

• You've created a HANA Model in HANA Studio using Input Parameters
• The Input Parameter is defined as Multiple Entries
• A virtual provider based on the HANA Model is created in transaction RSA1 in BW backend.
• A query is built on this virtual provider in Query Designer (or HANA Studio).
• The query has defined a multiple single value variable to pass values to the input parameter of the HANA model
• The query doesn't work.
• You get error of:

InfoObject xxx must be uniquely selected in the query

BRAIN 470

or

Characteristic xxx is not permitted for navigation.

BRAIN 409

Environment

• BW 7.3x above
• BW on HANA

Reproducing the Issue

See the example of virtual provider based on HANA Model with input parameter

Cause

From HANA SP9, it is possible to use Multiple Entries Input Parameter in a HANA Model.
However virtual provider based on HANA Model has limitations to access HANA Model:

• Virtual Provider Based on HANA Model only supports input parameter of single value.
• InfoObjects in the VC that mapped to HANA input parameter should never be allowed as drill-down characteristic in a query.

Resolution

• Virtual provider based on HANA Model has no plan to support multiple entries input parameter as it is an obsolete way to access HANA Models.
• To pass multiple single values to HANA model input parameter, please use HCPR instead from BW 740 SP5, which is much more powerful.
• The characteristic mapped to input parameter of HANA Model can only be used in 'Characteristic Restrictions' Section of Query Designer.

See details in the example of virtual provider based on HANA Model with input parameter

Keywords

BRAIN470, BRAIN409

Header Data

Released On	08.01.2016 09:11:33
Release Status	Released to Customer
Component	BW-BEX-OT-OLAP Analyzing Data
Other Components	BW-BEX-OT-HCPR CompositeProvider Query BW-BEX-OT-VC Virtual Cube (Remote Cube)
Priority	Normal
Category	How To