|
Transaction: RSRT |
For SAB BW up to 7.02, reporting on NLS data is only determined at the query level. To include archived data in your reporting, you must adjust the reporting query.
Proceed as follows to adjust the reporting query:
-
Start the Query Monitor via transaction RSRT.
Query Monitor – transaction RSRT
-
In the Query field, enter the query name.
-
Click Properties.
Selecting or deselectingNLSfor reporting
-
Select the option Read Nearline Storage As Well if you want to include data from NLS in reporting. If there is no data, this option is not displayed.
-
Click OK.
The reporting query has been adjusted.
Because it would be too much effort to adjust all queries manually, it is possible to adjust queries automatically in order to add or remove the NLS flag.
Proceed as follows to adjust the queries automatically:
1. Execute the report /DVD/NLS_INC_NLS_CHCK_TO_QUERY.
2. Maintain the Add NLS option. If you select this option, the NLS data is read.
3. In the InfoProvider fields, enter the InfoProvider(s) for which you want to adjust all the queries.
4. In the Name (ID) of a reporting comp. field enter the queries that you want to adjust.
5. Click Execute.
The queries have been adjusted.
Adding or removing the NLS flag from a query
After you execute this report in transaction SE38, all the specified queries will be adjusted.
In SAP BW up to version 7.02, the data of MultiProviders can only be included in reporting via created virtual InfoProviders. The SNP Outboard™ solution includes a report to do this automatically for InfoCubes. Details about using the report are available at the end of this chapter.
As of SAP BW 7.30, the logic changed, so NLS data can now be included in reporting at three levels:
1. Query level:
In Query Designer 7.30 and higher, you can define the NLS usage in the Extended tab of a query. You have three options here:
-
Read Nearline Storage: Include NLS data.
-
Do Not Read Nearline Storage: Exclude NLS data.
-
Use Nearline Storage According to Provider Settings: Include certain NLS data.
If you select the option Use InfoProvider default, the query setting is always taken from the InfoProvider settings. To make this property editable in the Query Designer, the InfoObject 0NEARLINE must be active in the BW system.
NLS usage in the Query Designer
If you select the option Use InfoProvider default, the InfoProvider settings will be adopted each time.
2. MultiProvider level:
At this level, you can set the NLS usage to read or not read NLS data automatically as well as read NLS data based on PartProvider settings.
Proceed as follows:
-
Start transaction RSA1.
-
Double-click InfoProvider and go to Extras.
-
Open the InfoProvider properties and select Change.
If you select the option Nearline access set the same as for PartProvider, the archived data is read from the underlying PartProvider based on its NLS usage settings.
Read NLS in queries for a MultiProvider
3. InfoProvider level:
At this level, the settings are configured in the same way as at the MultiProvider level.
Read NLS in queries for an InfoProvider
Note that when defining NLS usage at the query level, i.e. whether NLS usage is allowed or forbidden at the query level, the InfoProvider options are not taken into account. But if the query setting is set to default, the InfoProvider setting is taken into account.
We recommend using the setting Use InfoProvider default every time it is possible. To set the NLS usage automatically for multiple queries, you can execute the report /DVD/NLS_73X_INC_NLS_QUERY:
Adjusting the NLS query settings
If you adjust the queries using the report /DVD/NLS_73X_INC_NLS_QUERY, you must regenerate the query report before executing it in transaction RSRT. The regeneration is required in order to make the system aware of the new adjustments to the queries.
To set the NLS usage automatically for multiple MultiProviders as well as InfoProviders, you can execute the report /DVD/NLS_USAGE_MASS_EDIT. Note that this is relevant for SAP BW release 7.30 and higher.
Setting NLS usage for InfoProviders
