Child pages
  • BW external HANA View and NLS
Skip to end of metadata
Go to start of metadata

In order to read the data from Nearline Storage too, the following consulting note should be considered

2032797 - External SAP HANA view: Include NLS data with HANA Smart Data Access and SAP IQ

According to that note:

BW 7.4

Pre-Condition 
  • SAP HANA Smart Access and SAP IQ is used for archving
  • Table: RS2HANA_VIEW_SET with value OBJECT = RS2HANA_SUPPORT_NLS, VALUE = X.
    No report is available (SAP note 2252122), execute transaction /$TAB RS2HANA_VIEW_SET  in order to reset the buffer
  • In the properties of the infoprovider parameter "Near-Line Access switched' = ON
Restriction
  • No parameter available, therefore the system will read the data always in case the pre-conditions are met
  • Pruning not available
Supported Inforprovider and remarks
  
infocube 
DSOwith SID generation
Composite ProviderNLS archive of its PartProvider is NOT used
 QueryQuery setting will be ignored; depends on the underlying infoprovider

 

Analysis 

If the pre-conditions are met can be analysed by checking the XML in transaction RS2HANA_ADMIN

Double click on the appropriate object name:

repository: actual XML

new XML: XML with the current setting, will not be saved

In genneral there should be a datasource available:  <IPROV>$N$U.

example for infoprovider: JK_HMOD1

 

BW 7.50 or higher

Pre-condition

SAP HANA Smart Data Access and SAP IQ

Feature
  • parameter is available "read_nls" which can be set "ON" or "OFF". Default is the setting in the properties of the appropriate infoprovider
  • The pruning mechanism as described in SAP Note 2190204 is active

 

Supported Provider and remarks
  
Advanced DSOwith SID generation
Standard DSOwith SID generation
Composite ProviderNLS reading for PartProvider ADSO
 Query infoprovider provides NLS data
 Infocube 

 

ANALYSIS

If the BW external view should be able to read archived data can be checked in RS2HANA_ADMIN

Double click on the appropriate object name:

repository: actual XML

new XML: XML with the current setting, will not be saved

In general the parameter "_read_nls" should be available 

Defaut Value depends on the properties setting of the infoprovider.

This parameter can be changed: e.g. if you preview the data for the appropriate BW external HANA view you can check the data with or without archived data:

 







  • No labels