Show TOC

Scalability Level Configuration for Analytics InfrastructureLocate this document in the navigation structure

Use

The functionality delivered with Scalability Level Configuration clarifies the method of data access behind a MultiProvider during Query execution, and provides control over the default access type used. This can be achieved on either a MultiProvider or Query level. You can also control which InfoProvider should be included when processing a particular access type. Each InfoProvider of a MultiProvider can be associated with one of the available access types, as follows:

  • Direct

  • Replicated

  • Replicated Balances

By selecting one of the above access types, you define the data analyzed by all Queries for which the settings are made.

Previously, access methods proceeded according to the default logic. This logic defines replicated access for the first InfoProvider of a MultiProvider, and direct access for the first virtual InfoProvider. Replicated balances access is defined for the next virtual InfoProvider.

Now you can use the Customizing activity Scalability Level Configuration (transaction RSBCT_SREP_SLC) to configure the access in more detail.

It is possible to define each InfoProvider under a MultiProvider as using one of the listed access types, and to set the default access type. This definition can be altered when processing a specific Query. The Scalability Level Configuration activity provides additional views to review this configuration as well as validate the Master Data setup of Query Variables used in the queries defined to this MultiProvider.

Prerequisites

You have activated business function Enhancements for Business Suite Analytics (FND_ANALYTICS_TOOLS).

Activities
Note

You must have included one of the following InfoObjects as InfoProvider in your MultiProvider:

  • 0ACCESSTP

  • 0GL_ACCTP

Info Object 0GL_ACCTP provides access to replicated balances, but InfoObject 0ACCESSTP does not.

In order to make any settings, you must specify a MultiProvider. You also have the option to specify a Query. If you do not specify a Query, then the settings you make apply to all Queries of the specified MultiProvider. Query level settings supersede MultiProvider level settings, and so allow for specific Queries within a MultiProvider to be treated independently of one another. You can also make no settings for a Query or MultiProvider. In this case, the standard settings apply.

Note

The Hide Variable indicator is functional only if you are operating BI Content 7.02 or higher. If the indicator is set, the access type variable is hidden during Query execution.

The Overview tab page within Scalability Level Configuration allows you to review all settings made for the selected MultiProvider. The MasterData Query Variables tab page provides you with details for InfoObjects relevant to a specified range of Queries. If you do not specify a range, the system default is to use all Queries to a MultiProvider for the classification. Note that this could be an intensive process, with an effect on system performance. In relation to the mandatory input variables for the selected Queries, the system displays a status, as follows:

  • Red: Master data is not available, but is mandatory during the Query execution.

  • Yellow: Master data is not completely loaded.

  • Green: Master data is available.

You can make the above settings in Customizing for SAP NetWeaver under Business Intelligence —> Settings for BI Content —> Analytics Infrastructure —> Scalability Level Configuration. Once you have made appropriate Scalability Level Configuration settings, you can check their effect on Query execution using the Query Monitor (transaction RSRT).

Example

A Scalability Level Configuration definition for MultiProvider 0FIGL_M20 might be as follows:

  • Query field: empty. An individual Query is not specified. The configuration applies to all Queries of this MultiProvider.

  • Hide Variable: Not set. The access type InfoObject is not hidden.

  • Default Access Type: R. The system shall default to direct access when executing a Query.

  • Replicated Data indicator is set for 0FIGL_C20. Direct Access indicator is set for InfoProvider 0FIGL_R20.