Show TOC

Analytic ManagerLocate this document in the navigation structure

Calculation

Function

Type of Change

Description

Currency Translation

Enhanced (with 7.0, SPS 11)

In the definition of the Currency Translation Type, under Start of the navigation path Time Reference Next navigation step Variable Time Reference End of the navigation path, you can also specify a time shift. In the Time Shift field, you can specify whole numbers with the +/- sign. In the Time Shift from Variable field, you can specify formula variables (1FORMULA). Regardless of whether it is fixed or variable, the time shift is always based on the InfoObject specified under Variable Time Reference.

Using Precalculated Value Sets (Buckets)

New

A bucket is a precalculated value set that is stored either in a database table or in an index in SAP NetWeaver BW Accelerator and can be used as a filter in a BEx query. For more information, see Using Precalculated Value Sets (Buckets).

Time-Dependent Hierarchies

Enhanced

With SAP NetWeaver 7.0 EhP 1, peformance when using a temporaral hierarchy join has been improved. To profit from the improved performance, you have to reactivate the hierarchy in question.

Hierarchies

Enhanced

In queries, you can use hierarchies with direct access. This is recommended for small hierarchies that do not change frequently. The source system must be on Release SAP NetWeaver BI 7.02 or higher.

More information: Modeling Data Flows for Hierarchies with Direct Access

Aggregation

Function

Type of Change

Description

SAP NetWeaver BW Accelerator: Creating and Managing BWA Indexes for BW Objects

New

To get faster access to data in the BW system with reporting, you can store this data in indexes in SAP NetWeaver BW Accelerator. With BWA Index Maintenance (transaction RSDDB) you can now display edit and create BWA indexes for the following BW objects type: InfoCubes (including semantically partitioned objects), VirtualProviders, hierarchies and master data (for input help). For more information, see Indexing BW Data in SAP NetWeaver BW Accelerator.

This transaction replaces the BIA Index Maintenance Wizard.

SAP NetWeaver BW Accelerator: Releasing BWA Indexes for BW Objects for SAP BusinessObjects Explorer

New

SAP BusinessObjects Explorer , accelerated version: Using SAP BusinessObjects Explorer, you can achieve high performance representation for the data of a SAP NetWeaver BW Accelerator Index (abbreviation: BWA index). If you want to use this to analyze data from BW InfoProviders, you first need to create a version of a BWA index supplemented with special data and metadata in the BWA system. You can create a BWA index suitable for display in SAP BusinessObjects Explorer for the following types of BW InfoProviders: InfoCube, HybridProvider, semantically partitioned object (maded up of InfoCubes with the same structure), VirtualProvider, MultiProvider, query. For more information about the architecture and features, see Indexing BW Data for SAP BusinessObjects Explorer. For more information about the procedure, see Releasing BW Objects for SAP BusinessObjects Explorer.

SAP NetWeaver BW Accelerator: SAP NetWeaver BW Accelerator Monitor

New

The quick overview for SAP NetWeaverBW Accelerator Monitor has been replaced by direct entry to the detailed BW Accelerator Monitor.

You can also send the results of the BW Accelerator consistency checks by e-mail (see SAP NetWeaver BW AcceleratorMonitoring).

The default value for global indexing parameter SUBPKGSIZE has been set to 20,000 (see Tab: Index Performance).

From the SAP NetWeaver BW Accelerator Monitor, choose Start of the navigation path Goto Next navigation step Consistency Checks End of the navigation path on the BW Accelerator Data Consistency Check Center screen. On this screen, you can check the data on the BW Accelerator server, schedule these checks, and view logs for checks that have already run. You can combine certain checks into check sets (see Checking the Consistency of BWA Indexes (Check Center)).

The information and check results from BW Accelerator Monitor are also integrated in the CCMS monitoring architecture. You can find out more by reading SAP Note 970771.

Query Monitor

Enhanced

In the Query Properties dialog box, you can specify the following data for an analytic query: the read mode, the cache mode, the selection of structure elements and the optimization mode.

A new cache mode has been introduced: BLOB/Cluster enhanced No lock concept (enqueue) is used with this cache mode. There is no central cache directory for the cache elements either.

You can deactivate the default Parallel Processing for queries on MultiProviders.

If you choose Calculate with High Precision, the system performs calculations with 34 decimal places for all key figures of a query. This is useful if you require high accuracy, for queries in the accounting and cost accounting areas for example.

If the selected query is already able to access BWA indexes, you can use the Operations in BWA setting to decide whether and for what operations the system uses the BWA indexes.

For queries with virtual characteristics or key figures, you can activate cache use, which is deactivated in the default setting. You can also deactivate the SAP NetWeaver Business Warehouse Accelerator, which is deactivated in the default setting.

The system indicates whether the selected query can be used as an InfoProvider. The advantage in doing this is that you can calculate certain query functions in the Analytic Manager before reading the data.

If you select the Generation Log indicator, when you choose the Generation Log pushbutton in the query monitor, you can display a log in which reasons why the query was regenerated are listed.

Note

More information: Query Properties

Programm RSR_CACHE_RSRV_CHECK_ENTRIES identifies and deletes entries in the cache. We recommend scheduling it regularly in background procesing (to run once a week during the night for example). See Cache Data Removal and Swapping (under Further Recommendations).

BW-Integrated Planning

Function

Type of Change

Description

BW-Integrated Planning (Documentation)

changed

The documentation is divided into an overview of the Concepts of BW Integrated Planning (see Planning Business Data with BW Integrated Planning) and a description of the procedure in the Planning Modeler (see Planning Modeler).

Planning Modeler

New

The new Planning Modeler is available in the BW system. No JavaStack is required. You use the Planning Modeler to create and edit planning-specific metadata objects for BW Ingegrated Planning (see Planning Modeler).

The Planning Modeler functionality is also integrated into the Data Warehousing Workbench (see Planning-Specific Objects in the Data Warehousing Workbench).

Saving Changed Values

New

If you save your data in a BW Integrated Planning application, the system persists the data changed since the last save on the database. The changes to the data are always posted (and not the absolute values).

Using BAdI BADI_RSPLS_LOGGING_ON_SAVE from enhancement spot RSPLS_LOGGING_ON_SAVE, you can log the data that is saved for a BW integrated planning application. This logging can be implemented for real-time InfoCubes.

To prevent users in a planning application from saving invalid changed data, you as an administrator can run report RSPLS_PLSEQ_MAINTAIN. This ensures that a specific planning sequence runs after every "Save" event for a specific real time-enabled InfoProvider, thus checking the data in this InfoProvider.

More information: Saving Changed Values.

Input-Ready and Inverse Formulas

New

To make it possible to enter values for calculated formulas in manual planning ( Average Price as a quotient of Amount and Quantity for example) you can make the formulas input-ready. The input-ready formula becomes the carrier of a formula group. In our example, the quotient Average Price and the two operands Amount and Quantity belong to the formula group. A rule (in the form of an inverse formula) needs to be defined for every input-ready operand in the formula. This rule specifies how the system calculates back to this operand if the value for the Average Price is changed. For more information about design time, see Input-Ready Query and Defining Inverse Formulas. For more information about runtime, see Planning Business Data Manually (in BEx Analyzer), Planning Business Data Manually (in Web Applications) and Inverse Formula.

When working with input-ready calculated key figures and calculating inverse formulas, or when using disaggregation settings, it can be a good idea to fix cells. This function is only available in Web applications created with BEx Web Application Designer (WAD) however. More information: Inverse Formulas and Cell Fixing.

Planning Functions

New

Processing Changed Data The selected planning function type determines whether the planning function processes the data in blocks or processes all the data at once. A planning function, that processes data blocks, can be parameterized so that blocks are only processed, if they contain data that has been changed by the user in the same session. These planning functions only process small quantities of data. This significantly reduces the runtime. For more information,see Planning Functions in the BEx Analyzer documentation under Commands Wizard and the BEx Web Application Designer documentation under Execute Planning Function (Simple) , Planning Function , Execute Planning Function (Simple) .

Planning Function Forecast

Documentation enhanced

Forecast: The aggregation levels where you create a forecast planning function have to contain at least one time characteristic (Fiscal Year/Periods for example). The documentation for this has been enhanced (see "Prerequisites" in Forecast).

Planning Sequeneces in Process Chains

New

By integrating planning sequences into process chains, you can execute planning sequences in the background. More information: Scheduling Planning Sequences in Process Chains. An example is provided under Planning Sequence for Bottom-Up Planning.

Disaggregation

New

Disaggregation (also called top-down distribution) helps you to manually enter data within manual planning. It enables you to make manual entries within input-ready queries, also for aggregated values . More information: Disaggregation (Top-Down Distribution).

Form-Based Planning

New

If no data is posted, you can peform form-based planning (see Displaying All Valid Characteristic Combinations).

SAP liveCache as BW Lock Server

Deleted

As setting up and operating the SAP liveCache as a BW lock server means extra effort for customers, this option will not be offered any more as of SAP NetWeaver 7.3.

SAP Note 1531412 contains correction instructions for deactivating the option of using the SAP liveCache as a BW lock server in transaction RSPLSE. The correction instructions also contain report RSPLS_ENQUEUE_SWITCH_2_DEFAULT. This can be used to restore the default settings in transaction RSPLSE following an upgrade to SAP NetWeaver 7.3. To run this report, you need the same authorizations as for change mode in transaction RSPLSE. You can also change the settings in transaction RSPLSE manually.

Analysis Process Designer, BBS, Authorizations

Function

Type of Change

Description

Analysis Process Designer

changed

The following functions are available in Analysis Process Designer :

  • Creating Folders: You can now create folders yourself and store analysis processes in them.

  • Data Target Analytic Index: This allows you to save calculation results from an analysis process in an analytic index.

    More information: Analytic Index

  • Data Source Analysis Authorizations : This allows you to extract analysis authorizations from an InfoProvider.

    More information: Analysis Authorizations

  • You can activate InfoProviders for the data source for the purpose of reading the data in near-line storage.

    More information: Read Stored Data

Analytic Index

New

An analytic index is a data container whose data is stored in BW Accelerator and is used to generate a TransientProvider.

More information: Creaeting Analytic Indexes

CompositeProvider

New

The CompositeProvider is an InfoProvider which combines data from several analytic indexes (by Join or Union), and makes this data available for reporting and analysis.

More information: Creating CompositeProviders

Analysis Process Designer

Changed (with 7.0, SPS 11)

The following functions are available in Analysis Process Designer with 7.0, SPS 11:

  • In the Limit Data Volume transformation, you can now also specify variables.

  • The Join Data from Multiple Sources transformation now also provides you with a full outer join.

  • There is also the new transformation Formula. In addition to the basic mathematical functions already available in the Formula Editor, a range of standard transformations such as date functions, functions for character strings, or logical comparison operators are also provided. This is the formula editor that is also used in the transformation in the Data Warehousing Workbench.

  • A new transformation call Unifying Data from Two Data Sources (Union) has been introduced . The result structure automatically includes all fields of the data sources.

  • There is also the new data target File. The settings are practicallythe same as for data source File .

More information: Analysis Process Designer

BAdI for Report-Report Interface

New (with Enhancement Package 2 for 7.0)

For the Report-Report Interface, you can now use the BAdI RS_BBS_BADI_DYNAMIC to dynamically add data from an executed BEx query for the jump destinations in the context menu. This means that the context menu is not extended until runtime and is defined by the the column, row, cell content (and key figure value), query, or InfoProvider.

Report-Report Interface

Changed (with Enhancement Package 2 for 7.0)

In the maintenance transaction for the sender/receiver assignment to the BBS, the new jump destination Xcelsius Dashboard is available.

More information: Changing and Creating Sender/Receiver Assignments

Analysis Authorizations

changed

The following changes have been made for the analysis authorizations:

  • With SAP NetWeaver BW 7.3, the reporting authorizations concept is not supported any more. You now have to use the analysis authorizations introduced with SAP NetWeaver 7.0..

    More information: Migration of Reporting Authorizations to the New Concept

  • An authorization is now a TLOGO object (analytics security object) and can be transported to other systems.

    More information: Migration of Analysis Authorizations

  • The new BAdI RSEC_VIRTUAL_AUTH_BADI allows you to create virtual analysis authorizations. These are not created and checked until runtime. This means that authorizations can be created flexibly. They can also be read from other systems at runtime. For more information, see the BAdI documentation in the BW system.

  • For editing analysis authorizations, a new mass maintenance has been introduced.

    More information: Mass Maintenance

Effects on Existing Data:

If you are still using the reporting authorizations concept, you now have to migrate these authorizations to the new analysis authorization concept or redefine your authorizations from scratch. If you have upgraded from SAP NetWeaver 7.0 to SAP NetWeaver 7.3 and already implemented the new analysis authorizations concept, you have to migrate these analysis authorizations from 7.0 to the transportable analysis authorizations. This does not involve a great deal of effort however.

More information: Migration of Analysis Authorizations

Effects on Customizing>

IMG activity Analysis Authorizations: Select Concept has been deleted.