Register Login

Looking External SAP HANA view for a BW Query

Updated May 18, 2018

Activation of external SAP HANA view for a BW Query fails. Error message: "Return code/argument: 40117. Message: Internal deployment of object failed; Repository: Encountered an error in repository runtime extension. "0DATE" = '2000008999' "

  • Use transaction RS2HANA_ADMIN to repair the HANA view.

External SAP HANA view for a BW Query with non cumulative key figures: if the maxtim/mintim input parameter value is more restrictive than the default value, the result data set can have rows where the non cumulative key figure is .

  • Use transaction RS2HANA_ADMIN to repair the HANA view.

External SAP HANA view for a BW Query with non cumulative key figures, based on CompositeProvider: SQL exception "column not found" when accessing external HANA view

  • Use transaction RS2HANA_ADMIN to repair the HANA view.

Transaction RS2HANA_ADMIN, repair function: if started as background job, the selected Query As InfoProvider objects are not processed

  • Query As InfoProvider are processed in the next repair background job

Transaction RS2HANA_ADMIN: not possible to display SAP HANA view XML

  • Double click on any row in the list to display either the HANA view XML from the HANA repository or render a new XML of the object

Activation of external SAP HANA view for a BW Query fails: supported variables are identified as not supported

  • Retry

External SAP HANA view for BW Query: if a filter is defined for the initial value of a characteristic, which possibly can have NULL values during native HANA access, the filter is not applied correctly

  • Use transaction RS2HANA_ADMIN to repair the HANA view.

Program RS2HANA_VIEW_QUERY: "Set external SAP HANA view flag" is obsolete

  • Use the "Create external SAP HANA view" and "Delete external SAP HANA view" function to create and delete the external SAP HANA view of the BW Query.

Transaction RS2HANA_ADMIN: background repair job can only be scheduled if more than 10 rows are selected

  • Indipendent of the number of selected rows, the user can decide if the repair function shall be executed online or in a background job

Transaction RS2HANA_ADMIN: After the execution of the online repair function no messages are displayed

  • If the repair function is executed online, messages of the processing are displayed. Additionally the messages can be found using the "Logs for RS2HANA_REPAIR job" function

Transaction RSRV: The functions related to the external SAP HANA view are obsolete

  • Use transactoin RS2HANA_ADMIN instead

Activation of CompositeProvider with external SAP HANA view fails. The CompositeProvider has at least one InfoObject which is authorization relevant and compounded. Error message: "Return code/argument: 40117. Message: [...] Mapped source attribute __AUTH__KEY is missing in node 0BW:BIA: (CalculationNode (_AGGR_BEFORE_JOIN) [...]

  • Re-activate the CompositeProvider

External SAP HANA view for a BW Query with non cumulative key figures: when the description attribute of an InfoObject is request ( ___T ), the result set is not correct

  • Use transaction RS2HANA_ADMIN to repair the HANA view.


×