Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Navigation attributes can be provided by the external HANA view in case the column view  0BW:BIA:<HCPR>  includes the navigation attribute.

preconditions are provided in SAP Note 2211315

Case 1: The navigation attribute is not part of a PartProvider of the CompositeProvider and the PartProvider is not an advanced Datastore Object. Case 2 and 3 do not apply.

Case 2: The CompositeProvider characteristic of the navigation attibute is mapped to a navigation attribute of a PartProvider.

example:

Case 3: The CompositeProvider characteristic of the navigation attibute is mapped to a characteristic of a PartProvider with a different basic characteristic than the basic characteristic of the CompositeProvider characteristic

example:

The external HANA view does not provide those navigation attribute which are mentioned in the different warning as the 0BW:BIA:<HCPR> Column view also does not provide those information. For queries executed directly on the HCPR e.g. via RSRT the system creates 'ON the FLY' a calulation scenario and provide the needed information.

e.g. with example of scenario 3 and HCPR: JK_HCPR_1

Transaction RSRT: JK_HCPR_1/!!aJK_HCPR_1

Execute in debugging and set flag:

Execute

switch on the technical information, by pressing two times

Drill down navigation attribute JK_PLANT__0COUNTRY

a join calulation view with source '/BIC/PJKPLANT' and calulation scenario "0BW:BIA:JK_HCPR_1 will be created

 

 

other examples
  • field based aDSO is included in HCPR and the fields are mapped to an infoobject and for that infoobject navigation attributes are switched on
  • HANA calculation view is included in HCPR and the fields are mapped to an infoobject and for that infoobject navigation attributes are switched on
Reasons why a join is necessary:

1) column view of the HCPR does not provide the information:

BW schema:

 

As those navigation attributes are not available in 0BW:BIA_JK_HCPR_1 those navigation attributes are not available in the BW external HANA view as a calculation view 'On the Fly' is not possible.

2) only partial support of the navigation attribute

It is possible that some part providers in the HCPR can supply the navigation attribute. Hence there will be partial support for the navigation attributes which may not require on the fly joins. However the BW external  HANA view requires full support of navigation attributes or it cannot add the navigation attribute to the output view. 

 

Possible solution:

Inner join to the infoobject in the HCPR level, 

 

Defining a query

The external HANA view cannot be set for queries which includes navigation attributes which are excluded during the activation of the HCPR.

 

The following error will occur

 Technical limitation of the BW external HANA view.

 

  • No labels