Business Intelligence |
What's New in BI with SAP NetWeaver 7.0 |
Business Intelligence: Overview |
What Is Business Intelligence? |
Integration, Storage and Management of Data |
Extraction, Transformation and Loading (ETL) |
Data Storage and Data Flow |
Control of Processes |
Information Lifecycle Management |
Extraction to Downstream Systems |
Metadata and Documents |
Data Analysis and Planning |
Online Analytical Processing |
Data Mining |
Business Planning |
Tools for Accessing and Visualizing Data |
Query Design |
Enterprise Report Design |
Web Application Design |
Data Analysis in BEx Web Applications |
Data Analysis with Microsoft Excel |
Embedded BI and Composite Applications |
Publishing BI Content |
Broadcasting BI Content |
Integrating Content from BI into the Portal |
Performance |
Security |
BI Content |
Overview of the Architecture of SAP NetWeaver BI |
Step-by-Step: From the Data Model to the BI Application in the W |
Creating Key Figures |
Creating Characteristics |
Creating InfoCubes |
Creating DataSources for Master Data of Characteristic "Product" |
Creating DataSources for Transaction Data |
Creating Transformations for Master Data of Characteristic "Prod |
Creating Transformations for InfoCubes |
Creating Master Data Directly in the System |
Loading Master Data for Characteristic "Product" |
Loading Transaction Data |
Defining Queries |
Creating Web Applications |
Analyzing Data in the Web Application |
Broadcasting Web Applications by E-Mail |
Data Warehousing |
The Data Warehouse Concept |
Using a Data Warehouse |
Architecture of a Data Warehouse |
Enterprise Data Warehouse (EDW) |
Building and Running a Data Warehouse |
Data Warehousing: Step by Step |
Data Warehousing Workbench |
Data Warehousing Workbench - Modeling |
Data Flow in the Data Warehouse |
Modeling |
Namespaces for BI Objects |
Data Flow Display |
DataSource |
Functions for DataSources |
DataSource Maintenance in BI |
Editing DataSources from SAP Source Systems in BI |
Creating DataSources for File Source Systems |
Creating DataSources for UD Connect |
Creating DataSources for DB Connect |
Creating DataSources for Web Services |
Emulation, Migration, and Restoring DataSources |
Using Emulated 3.x DataSources |
Migrating 3.x DataSources |
Migrating 3.x DataSources (UD Connect, Web Service) |
Restoring 3.x DataSources |
Persistent Staging Area |
DB Memory Parameters |
Deleting Requests from the PSA |
Previous Technology of the PSA |
Persistent Staging Area |
Types of Data Update with PSA |
Checking and Changing Data |
Checking and Changing Data Using PSA-APIs |
Versioning |
DB Memory Parameters |
Reading the PSA and Updating a Data Target |
InfoObject |
InfoObject Catalog |
Creating InfoObject Catalogs |
Additional InfoObject Catalog Functions |
InfoObject Naming Conventions |
Creating InfoObjects: Characteristics |
Tab Page: General |
Tab Page: Business Explorer |
Mapping Geo-Relevant Characteristics |
Static and Dynamic Geo-Characteristics |
Shapefiles |
Delivered Geo-Characteristics |
SAPBWKEY Maintenance for Static Geo-Characteristics |
Creating a Local Copy of the Shape File |
Downloading BI Master Data into a dBase File |
Maintaining the SAPBWKEY Column |
Uploading Edited Shapefiles into BI Systems |
Geocoding |
Downloading BI Master Data into a dBase File |
Geocoding Using ArcView GIS |
Converting dBase Files into CSV Files |
Tab Page: Master Data/Texts |
Tab Page: Hierarchy |
Tab Page: Attributes |
Tab Page: Compounding |
Characteristic Compounding with Source System ID |
Assigning a Source System to a Source System ID |
Navigation Attribute |
Creating Navigation Attributes |
Performance of Navigation Attributes in Queries and Value Help |
Transitive Attributes as Navigation Attributes |
Conversion Routines in the BI System |
ALPHA Conversion Routine |
BUCAT Conversion Routine |
EAN11 Conversion Routine |
GJAHR Conversion Routine |
ISOLA Conversion Routine |
MATN1 Conversion Routine |
NUMCV Conversion Routine |
PERI5 Conversion Routine |
PERI6 Conversion Routine |
PERI7 Conversion Routine |
POSID Conversion Routine |
PROJ Conversion Routine |
REQID Conversion Routine |
IDATE Conversion Routine |
Conversion Routine RSDAT |
SDATE Conversion Routine |
WBSEL Conversion Routine |
Creating InfoObjects: Key Figures |
Tab Page: Type/Unit |
Tab Page: Aggregation |
Tab Page: Additional Properties |
Editing InfoObjects |
Additional Functions in InfoObject Maintenance |
Using Master Data and Characteristics that Bear Master Data |
Master Data Types: Attributes, Texts and Hierarchies |
Master Data Maintenance |
Creating and Changing Master Data |
Maintaining Time-Dependent Master Data |
Time-dependent Master Data from Different Systems |
Deleting Master Data at Single Record Level |
Deleting Master Data and Texts for a Characteristic |
Versioning Master Data |
Activating Master Data and Texts |
Simulate the Loading of Master Data |
Master Data Lock |
Reorganizing Master Data |
Load Master Data to InfoProviders Straight from Source Systems |
InfoProviders |
InfoCubes |
Star Schema |
Dimension |
Line Item and High Cardinality |
Creating InfoCubes |
Real-Time InfoCubes |
Additional Functions in InfoCube Maintenance |
InfoProvider Properties |
Checking the Data Loaded in the InfoCube |
Non-Cumulative Value Parameter Maintenance |
DB Memory Parameters |
Partitioning |
Partitioning InfoCubes Using the Characteristic 0FISCPER |
Repartitioning |
Clustering |
Definition of Clustering |
Selecting MDC Dimensions |
Reclustering |
Overview of Loadable InfoSources for an InfoCube |
DataStore Object |
Defining the DataStore Object Type |
Standard DataStore Object |
Write-Optimized DataStore Objects |
DataStore Objects for Direct Update |
Scenario for Using Standard DataStore Objects |
Scenario for Using Write-Optimized DataStore Objects |
Scenario for Using DataStore Objects for Direct Update |
Creating DataStore Objects |
{0>Einstellungen zum DataStore-Objekt<}100{>DataStore Object Set |
Additional Functions in DataStore Object Maintenance |
InfoProvider Properties |
DB Memory Parameters |
Multidimensional Clustering |
Definition of Clustering |
Integration in the Data Flow |
Questions and Answers |
InfoObjects as InfoProviders |
VirtualProviders |
VirtualProvider Based on the Data Transfer Process |
Creating VirtualProviders Based on Data Transfer Processes |
Creating VirtualProviders Based on 3.x InfoSources |
Processing Selection Conditions |
VirtualProvider with BAPI |
VirtualProviders with Function Modules |
Using InfoObjects As VirtualProviders |
InfoSet |
Creating InfoSets |
Editing InfoSets |
Special Features of InfoCubes in InfoSets |
Additional Functions in the InfoSet Builder |
Screen Layout: Changing InfoSets |
Comparing and Adjusting InfoSets |
Join Control |
Defining Join Conditions |
Left Outer Join |
Examples of Condition Conversion |
Editing InfoProviders in the Join Control |
Temporal Join |
Processing the Time Dependency |
Most Recent Reporting for InfoObjects |
Interpreting Queries Using InfoSets |
Classic InfoSet |
Setting-up a Role for the InfoSet Query |
Processing Classic InfoSets and Assigning Roles |
InfoSet Query |
Creating InfoSet Queries |
MultiProviders |
Creating MultiProviders |
Consistency Check for Compounding |
Dividing a MultiProvider Query into Sub-Queries |
Example: Plan-Actual Data |
Example: Sales Scenario |
Open Hub Destination |
Creating Open Hub Destinations |
Database Tables As Destinations |
Files As Destinations |
Third-Party Tools As Destinations |
Field Definition |
Remodeling InfoProviders |
Remodeling InfoProviders |
Customer Exits in Remodeling |
Monitor and Error Handling |
Data Acquisition |
Source System |
Connection between Source Systems and BW |
Creating SAP Source Systems |
Configurations in BI |
Configurations in the SAP Source System |
Transferring Global Settings |
Creating External Systems |
Creating File Systems |
Creating Database Management Systems as Source Systems |
Creating a UD Connect Source System |
Check Source System |
Data Extraction from SAP Source Systems |
DataSource in the SAP Source System |
Extraction Structure |
Installing the Business Content DataSource in the Active Version |
Editing the DataSource in the Source System |
Replication of DataSources |
Editing DataSources from SAP Source Systems in BI |
Using Emulated 3.x DataSources |
Data Reconciliation |
Delta Process |
Functions in the SAP Source System |
Maintaining Control Parameters for Data Transfer |
Data Transfer with qRFC Outbound Queue |
Restricting Authorizations for Extraction |
Delta Queue Check |
Installing Application Component Hierarchies |
Installing BI Content DataSources |
Maintaining Generic DataSources |
Delta Transfer to BI |
Function Module: Interface Description and Procedure |
Testing Extraction |
Extraction Using SAP Query |
Notes on Extraction Using SAP Query |
SAP Query: Assignment to a User Group |
Editing DataSources and Application Component Hierarchies |
Enhancing DataSources |
Functions for DataSource 3.x in Data Flow 3.x |
Assigning DataSources 3.x to InfoSources 3.x and Fields to InfoO |
Transfer Structure in Data Flow 3.x |
Transferring Data Using Web Services |
Creating Web Service Source Systems |
Creating DataSources for Web Services |
Transferring Data Using Web Services (Standard) |
Closing Requests Using Process Chains |
SOAP-Based Transfer of Data (3.x) |
XML DataSource (BW DataSource with SOAP Connection) |
Creating an XML DataSource |
Activating Data Transfer to the Delta Queue |
Further Processing Data from the Delta Queue |
Transferring Data Using the SOAP Service SAP Web AS |
Sending Data to the SOAP Service |
Structure of a SOAP Message |
Data Transfer Using Web Services |
Creating a Web Service for Loading Data |
Data Transfer Using SAP XI |
Example of Transferring XML Data Using SAP XI |
Transferring Data with UD Connect |
Creating a UD Connect Source System |
Creating DataSources for UD Connect |
Creating DataSource 3.x |
Using InfoObjects with UD Connect |
Data Types and Their Conversion |
Using SAP Namespace for Generated Objects |
Using Emulated 3.x DataSources |
Using Relational UD Connect Sources (JDBC) |
Dataflow 3.x Example: JDBC Source with Transaction Data |
Dataflow 3.x Example: JDBC Source with Master Data |
BI Java Connectors |
Configuring the BI Java Connectors |
BI JDBC Connector |
BI ODBO Connector |
BI SAP Query Connector |
BI XMLA Connector |
Transferring Data Using DB Connect |
DB Connect Architecture |
Installing the Database Shared Library (DBSL) |
Supported Databases |
Requirements for Database Tables and Database Views |
Database Users and Database Schemas |
Creating Database Management Systems as Source Systems |
Creating DataSources for DB Connect |
Localizing Errors |
Updating Metadata |
Using 3.x DataSources |
Transferring Data from Flat Files |
Creating DataSources for File Source Systems |
Using Emulated 3.x DataSources |
Transferring Data from Flat Files (3.x) |
Updating Metadata for Flat Files and External Systems |
Data Transfer from External Systems |
Updating Metadata for Flat Files and External Systems |
Notes on Data Transfer |
Load Master Data to InfoProviders Straight from Source Systems |
Transformation |
Rule Type |
The Transformation Library and Formula Builder |
Example for Using the Formula Editor |
BAdI: Customer-Defined Functions in the Formula Builder |
Structure of Implementation of a Function |
Implementation of a Category |
Aggregation Type |
Rule Group |
Creating Transformations |
Assigning InfoObjects for Reading Master Data |
Assigning InfoObjects for Converting Amounts or Currencies |
Assigning InfoObjects for Time Conversion |
Copying Transformations |
Error Analysis in Transformations |
Testing Rules |
Routines in Transformations |
Creating Routines |
Example: Start Routine |
Example: Characteristic Routine |
Example: End Routine |
Start Routine Parameters |
Routine Parameters for Key Figures or Characteristics |
End Routine Parameters |
Creating Inversion Routines |
Inversion Routine Parameters |
Example for Inversion Routine |
Details for Implementing the Inversion Routine |
Regular Expressions in Routines |
InfoSource |
Recommendations for Using InfoSources |
Migration of Update Rules, 3.x InfoSources, and Transfer Rules |
Differences in Routine Concepts |
Example for Migration of an Inversion Routine |
Old Transformation Concept |
3.x InfoSource |
3.x InfoSource Types |
Scenarios for Flexible Updating |
Creating InfoSources (SAP Source System) |
Communication Structure |
Maintaining Communications Structures with Flexible Updating |
Maintaining Communication Structures with Direct Updating |
Checking for Referential Integrity |
Transfer Structure in Data Flow 3.x |
Maintaining Transfer Structures |
Processing Transfer Rules |
Start Routines in Transfer Rules |
Creating Transfer Routines |
Inversion Routine |
Error Handling in the Transfer Routine |
Maintaining InfoSources (Flat File) |
Updating Data Flexibly from a Flat File |
InfoSource with Flexible Update for Flat Files |
Updating Master Data from a Flat File |
Uploading Hierarchies from Flat Files |
Structure of a Flat Hierarchy File for Loading via IDoc |
Structure of a Flat Hierarchy File for Loading Using a PSA |
Preview and Simulation of Loading Data from Flat Files |
Maintaining InfoSources (External System) |
Update Rules |
Update Options |
Update Process |
Creating Update Rules for InfoProviders |
Update Types |
Update Methods |
Automatic Time Conversion |
Time Distribution |
Splitting Key Figure Values |
Creating Different Rules for Different Key Figures for a Charact |
Currency Translation in the Update |
Update Routines and Start Routines |
Creating Update Routines |
Error Handling in the Update Routine |
Changing Update Rules |
Additional Functions in Update Rule Maintenance |
Further Processing Data |
Further Processing of Data in DataStore Objects |
Activation of Data in DataStore Objects |
Example for Activating and Updating Data |
Including DataStore Objects in Process Chains |
Deleting Data from the DataStore Object |
Delete by Request |
Deleting Data Selectively |
Deleting from the Change Log |
Deleting Already Updated Data |
Further Processing of Data in InfoCubes |
Deleting the InfoCube and InfoCube Content |
Including InfoCubes in Process Chains |
Data Distribution |
Data Transfer Process |
Creating Data Transfer Processes |
Processing Modes of Data Transfer Processes |
Creating Data Transfer Processes for Real-Time Data Acquisition |
Creating Data Transfer Processes for Direct Access |
Handling of Data Records with Errors |
Error Stack |
Examples for Using the Error Stack |
Temporary Storage |
Handling Duplicate Data Records |
Monitor |
Where-Used List for Requests |
Simulating and Debugging DTP Requests |
Performance Tips for Data Transfer Processes |
Data Mart Interface |
Data Mart Interface Between Several Systems |
Using the Data Mart Interface |
Generating Export DataSources for InfoProviders |
Generating Master Data Export DataSources |
Data Transfer Using the Data Mart Interface |
Open Hub Service |
Components of the Open Hub Service |
Database Tables As Destinations |
Files As Destinations |
Extraction Mode for the InfoSpoke |
Creating InfoSpokes |
Including InfoSpokes in Process Chains |
Third-Party Tools As Destinations |
API: RSB_API_OHS_DEST_SETPARAMS |
API: RSB_API_OHS_3RDPARTY_NOTIFY |
API: RSB_API_OHS_REQUEST_SETSTATUS |
API: RSB_API_OHS_DEST_GETLIST |
API: RSB_API_OHS_DEST_GETDETAIL |
API: RSB_API_OHS_DEST_READ_DATA |
API: RSB_API_OHS_SPOKE_GETLIST |
API: RSB_API_OHS_SPOKE_GETDETAIL |
InfoSpoke with Transformation Using a BAdI |
Open Hub Monitor |
Data Warehouse Management |
Performance Optimization in Data Warehouse |
General Performance Tips for the Load Process |
Performance Tips InfoCubes |
Performance Tips for DataStore Objects |
Performance Tips for Processing Master Data |
Performance Tips for Data Transfer Processes |
Performance Tips for Data Transfer from an SAP Source System (Se |
Performance Tips for Loading Flat Files: |
Performance Tips for ABAP Programming |
Load Balancing for Loading and Data Warehouse Processes |
Setting Load Balancing for Loading Processes to the BI System |
Setting Load Balancing for BI Processes in the Background |
Setting Load Balancing for DataStore Object Processes in the Dia |
Optimization of Data Retention |
Tools for Runtime Analzsis of BI Processes |
Process Chain |
Process |
Start Process |
Application Process |
Operating System Command |
Including Operating System Commands as Processes in Process Chai |
ABAP Programs |
Local Process Chains |
Process Chain Remote |
Decisions |
Including Decisions as a Process in Process Chains |
Workflow |
Including a Workflow as a Process in a Process Chain |
Executing a Process Chain Within a Workflow |
Implementing Your Own Process Type |
Collection Process |
Process Chain Maintenance |
Plan and Check View Functions |
Creating Process Chains |
Variant Maintenance Tips |
Display/Maintenance of Process Chain Attributes |
BW Monitor in CCMS |
Send Alerts for Process Chains |
Monitoring Process Chain Runs |
Process Chain Logs Display |
Repairing/Repeating Terminated Processes |
Maintenance of Process Types |
Authorizations for Process Chains |
Scheduler |
Creating InfoPackages |
Additional Functions in InfoPackage Maintenance |
Maintaining Data Transfer Control Parameters for DataSources |
Handling Duplicate Data Records |
Scheduler (3.x) |
Maintaining InfoPackages |
Procedure for SAP Systems |
Procedure for Flat Files |
Procedure for External Systems with BAPI Functions |
Tab Page: Data Selection |
Variable Selection Change in Background Processing |
Tab Page: Hierarchy Selection |
Tab Page: Processing |
Tab Page: Data Targets |
Automatic Deletion of Requests from the InfoCube when Loading |
Tab Page: Updating |
Tab Page: External Data |
Scheduling InfoPackages |
Selection Criteria for Start Date when Scheduling in Background. |
Inserting an InfoPackage into the Process Chain |
Variants |
Additional Functions in InfoPackage Maintenance |
Maintaining Data Transfer Control Parameters for DataSources |
Handling Duplicate Data Records |
Handling of Data Records with Errors |
Subsequent Processing |
Monitor for Extraction Processes and Data Transfer Processes |
Selection Screen |
Request Overview |
Detail Screen |
Update Simulation in the Extraction Monitor |
Traffic Lights |
Wizard |
Administration of InfoProviders |
Manage InfoCubes |
InfoCube Content |
Transferring InfoCube Contents |
Selective Deletion |
InfoCube Performance |
Compressing InfoCubes |
Requests in InfoCubes |
Automatic Further Processing |
Reconstruction of InfoCubes |
Functional Constraints of Processes |
Status Overview of DataStore Objects |
Management of DataStore Objects |
DataStore Object Content |
Requests in DataStore Objects |
Reconstruction of DataStore Objects |
Runtime Parameters of DataStore Objects |
Functional Constraints of Processes |
Manage InfoObjects |
Information Quality Management |
Consolidating Master Data Using MDM |
Information Lifecycle Management |
Data Archiving Process |
Archiving Data |
Creating Data Archiving Processes |
Creating Near-Line Storage Connections |
Scheduling Data Archiving Processes Using Process Chains |
Scheduling Data Archiving Processes Using ADK Archive Administra |
Maintenance of Variants |
Administration of Data Archiving Processes |
Creating and Executing Archiving Requests |
Status of Archiving Request |
Setting Archiving Requests to Invalid |
Loading Archived Data Using a Data Transfer Process |
Displaying Stored Data in Queries |
Old Data Archiving Concept |
Data Archiving Process Flow |
Deletion Strategies |
Typical Errors and Their Removal |
Archiving Object |
Deleting or Changing an Archiving Object |
Time Restrictions |
Archiving Data |
Archiving Data from Non-Cumulative InfoCubes |
Example of Archiving Data from Non-Cumulative InfoCubes |
Checking an Archive File |
Reloading Data from Archive Files |
Authorizations |
Standard Authorizations |
Overview: Authorization Objects |
Authorization Profiles for Working with the Data Warehousing Wor |
Authorization Profiles for Background Users |
Authorizations for Query Definition and Information Broadcasting |
Examples for Authorizations for the Query Definition |
Authorizations for Business Planning and Simulation |
Authorizations for Integration with the Portal |
Authorizations for Documents |
Authorizations for Master Data |
Authorizations for Trace Tool Environment |
Setting Up Standard Authorizations |
Authorization Templates |
Analysis Authorizations |
Authorization Dimension |
Management of Analysis Authorizations |
Prerequisites for the Management of Analysis Authorizations |
Defining Analysis Authorizations |
Settings for Value Authorizations |
Authorization for Aggregated Values |
Settings for Hierarchy Authorizations |
Authorizations with Variables |
Authorizations for Display Attributes |
Authorizations for Navigation Attributes |
Authorizations for BI Integrated Planning |
Generation of Analysis Authorizations |
Template for DataStore Objects with Authorization Data (Values) |
Template for DataStore Objects with Authorization Data (Hierarch |
Examples of Generated Authorizations |
Assigning Authorization to a User |
Error Log |
Optimization of Authorizations |
Filling Empty Dimensions and Combining Authorizations |
Generalization for Any Number of Dimensions |
Combining Authorizations |
Change Documents (Legal Auditing) |
Migration of Reporting Authorizations to the New Concept |
Performing Migration |
Repeated Migration or Deletion of an Old Migration |
Previous Concept for Reporting Authorizations |
Authorizations for Selection Criteria |
Authorizations for Display Attributes |
Authorizations for Navigation Attributes |
Authorizations with Variables |
Maintaining Authorizations for Hierarchies |
Authorization Check when Executing a Query |
Setting Up Reporting Authorizations |
Setting Up Reporting Authorizations |
Manually Maintaining Reporting Authorizations |
Generating Reporting Authorizations |
Transporting Additional Information |
Authorization Scenarios for BW Reporting |
Authorizations for a Few Groups |
Individual and Detailed Authorizations |
Authorization Using Variables |
Using Existing Authorizations |
Administration of BI Metadata Search and BI Documents |
Retrieval: Search Server Relation Monitor |
Tab Page: Metadata Indexing |
Tab Page: Generated Document Properties |
Characteristic Is Document Property |
Tab Page: Document Content Repository |
Tab Page: Online Documentation |
Tab Page: Indexing Documents |
Setting up Indexes for Initial Searches |
Valid File Types |
Editing Valid File Types |
Working with Documents in the Data Warehousing Workbench |
Editing Documents in the Document View of DW Workbench |
Processing Documents in the Documents Screen |
Creating Documents |
Exporting Documents |
Documents as Online Documentation |
Translating Text for BI Objects |
Transporting BI Objects, and Creating, Delivering and Copying BI |
BI Versioning Concept |
Object Dependencies and Consistency |
Collecting Objects |
Defining Grouping Mode |
Checking Settings |
Transporting BI Objects |
Transport Landscape |
Recording Time for Transports |
Defining the Recording Time for Transports |
Defining Object Changeability |
Changing Package Assignments |
Troubleshooting (Transport) |
Creating and Delivering BI Content |
System Landscape |
Making System Settings for Content Creation |
BI Content Delivery by SAP |
BI Content Delivery in OLTP Systems by SAP |
Creating and Delivering Customer Content |
Using Namespaces for Developing BI Objects |
Creating and Delivering Customer Content in the BI System |
Setting Object Changeability in Customer Content Systems |
Creating and Delivering Customer Content in the OLTP System |
Features when Transporting Roles |
Development and Delivery of Hierarchy Nodes |
Comparing Different ABAP Code Versions |
Creating and Delivering Partner Content |
Development and Delivery of Hierarchy Nodes |
Documents for Content Objects |
Copying BI Content to the Active Version |
Troubleshooting (Content Activation) |
Transportable Object Types |
SOBJ: Definition of Transportable Object Types |
Special Features of Individual Object Types |
Transporting BEx Objects |
Transporting Roles |
Transporting Hierarchy InfoPackages |
Importing Client-Dependent Objects |
Special Features of Source System-Dependent Objects |
Enhancements to the BI Versioning Concept |
Classification of Source System-Dependent Objects |
Making the Source System Anonymous |
Defining the Target Source System |
DataSource |
InfoPackage |
Transformation |
Data Transfer Process |
Process Chains and Process Variants |
Source System-Dependent 3.x Objects |
BI Statistics |
Technical Content |
BW Technical Content FC1 |
SAP Exit Variable |
Variable: Current Calendar Month |
Variable: Current Calendar Week |
Variable: Current Calendar Year |
Variable: Current Quarter |
Variable: Current Calendar Day |
Variable: Current Workday |
Variable: Current Fiscal Year |
Variable: Current Fiscal Year / Period |
Variable: Cumulated up to Current Fiscal Year Period |
Variable: Cumulated up to Last Fiscal Year Period |
Variable: Cumulated up to Current Month |
Variable: Cumulated up to Last Month |
Variable: Cumulated up to Current Day |
Variable: Previous Year Cumulated up to Current Day |
Determining the Fiscal Year Variant at Query Runtime |
Analysis and Repair Environment |
Archivation of Request Administration Data |
Archive Administration for Request Administration Data |
Archiving Request Administration Data |
Reloading Request Administration Data |
Editing Requests with Archived Administration Data |
BI Background Management, Logs and Tools |
Setting Parallel Processing of BI Processes |
Process Types Supported by BI Background Management |
Analyzing Background Jobs and Work Processes |
Switching the Dialog Box for Load Distribution for Users On/Off |
Deleting Messages and Parameters from BI Background Management |
Executing Checking and Conversion Programs |
Clients in BW |
Clients: OLTP Systems and the Business Information Warehouse |
Naming Conventions for Background Jobs |
Real-Time Data Acquisition |
Daemon for Real-Time Data Acquisition |
Request Concept |
Closing Requests in the Monitor for Real-Time Data Acquisition |
Transferring Transaction Data from SAP Source Systems (RDA) |
Transferring Transaction Data Using Web Services (RDA) |
Monitor for Real-Time Data Acquisition |
Troubleshooting Real-Time Data Acquisition |
Creating InfoPackages for Real-Time Data Acquisition |
Creating Data Transfer Processes for Real-Time Data Acquisition |
Controlling Real-Time Data Acquisition with Process Chains |
BI Platform |
Metadata Repository |
BI Metadata Search |
Displaying Graphics |
HTML Export |
Exchanging Metadata in XMI Format |
Calling the Metadata Repository as an HTTP Service |
Documents |
Document Classes |
BAdIs for Use in Documents |
Hyperlinks to Documents |
BI Security Manager for Documents |
Repository Manager for BI |
BI Document Repository Manager |
BI Metadata Repository Manager |
OLAP |
Special OLAP Functions and Services |
Aggregation |
Examples in the Data Warehousing Workbench |
Examples of Exception Aggregation: Last Value and Average |
Examples of Exception Aggregation: Average (AV1) |
Examples in the BEx Query Designer |
Example of Exception Aggregation: Counting |
Example of Exception Aggregation: Enhanced Counting |
Hierarchies |
Options for Hierarchical Modeling |
Hierarchy Nodes |
Link Nodes |
Loading Hierarchies |
Loading Hierarchies Using a Process Chain |
Special Features when Loading using the PSA |
Loading Data as Subtrees |
Creating Hierarchies |
Modeling Nodes and Leaves |
Editing Hierarchies |
Functions of Hierarchy Processing |
Level Maintenance |
Hierarchy Attributes |
Activating Virtual Time Hierarchies |
Hierarchy Properties |
Hierarchy Version |
Maintaining Hierarchy Versions |
Time-Dependent Hierarchies |
Time-Dependent Hierarchy Structures in the Query |
Loading Time-Dependent Hierarchies |
Intervals |
Sign Reversal |
Using Sign Reversal |
Elimination of Internal Business Volume |
Currency Translation |
Scenarios for Currency Translation |
Currency Translation Type |
Defining Target Currencies Using InfoObjects |
Creating Variables for Currency Translation Types |
Creating Currency Translation Types |
Transferring Exchange Rates for Currencies from SAP Systems |
Transferring Global Table Entries for Currencies from SAP System |
Exchange Rates for Currencies in Flat Files |
Uploading Exchange Rates from Flat Files |
Currency Translation During Transformation |
Currency Translation in the Business Explorer |
Setting Variable Target Currency in the Query Designer |
Multiple Currency Translation Types in One Query |
Currency and Unit Display in Business Explorer |
Quantity Conversion |
General Information About Quantity Conversion |
Prerequisites for InfoObject-Specific Quantity Conversion |
Quantity Conversion Types |
Defining Target Units of Measure Using InfoObjects |
Creating Variables for Quantity Conversion Types |
Creating Quantity Conversion Types |
Transferring Global Table Entries for Units of Measure from SAP |
Quantity Conversion During the Transformation |
Quantity Conversion in the Business Explorer |
Setting Variable Target Units of Measure in the Query Designer |
Quantity Conversion Scenarios |
Example Data Without Compounding |
Conversion with Fixed Target Quantity |
Conversion Using Factors from InfoObjects |
Conversion with Target Unit of Measure Using Attribute in InfoOb |
Conversion with Fixed Target Unit of Measure and Dynamic Determi |
Example Data With Compounding |
Conversion with Fixed Target Unit of Measure |
Conversion Using Factors from InfoObjects |
Conversion with Target Unit of Measure Using Attribute in InfoOb |
Conversion with Fixed Target Unit of Measure and Dynamic Determi |
Local Calculations |
Constant Selection |
Example: Market Index |
Example: Using Constant Selection with MultiProviders |
Analysis Authorizations |
Report-Report Interface |
Process when Calling the RRI |
Editing Sender-Receiver Assignments to the RRI in the BI System |
Receivers |
BEx Query as Recipient |
Example of a BEx Query as a Receiver |
Creating a Transaction As a Receiver |
Creating a Web Address As a Receiver |
Examples for Web Addresses as Receiver |
iView As Receiver |
 Creating Your Own Report Type as Receiver |
Maintaining Assignment Details |
SAP DemoContent for Features |
Performance Optimization |
Performance Optimization with SAP NetWeaver BI Accelerator |
SAP NetWeaver BI Accelerator Index |
Technical Information About the SAP NetWeaver BI Accelerator Eng |
Using the BIA Index Maintenance Wizard |
Activation and Provision of Data |
Activating and Filling SAP NetWeaver BI Accelerator Indexes |
Rolling Up Data in SAP NetWeaver BI Accelerator Indexes |
System Response Upon Changes to Data |
System Response Upon Changes to Data: SAP NetWeaver BI Accelerat |
Improving Efficiency Using SAP NetWeaver BI Accelerator Delta In |
Status Display and Check Tools |
Using the SAP NetWeaver BI Accelerator Monitor |
Global Parameters for Indexing |
SAP NetWeaver BI Accelerator Index Design |
Checking SAP Net Weaver BI Accelerator Indexes (Transaction RSRV |
Checking SAP NetWeaver BI Accelerator Indexes (Check Center) |
Statistics for Maintenance Processes of SAP NetWeaver BI Acceler |
Traces for SAP NetWeaver BI Accelerator |
Performance Optimization with Aggregates |
Aggregates |
Selection Type "All Characteristic Values" ('*') |
Selection Type "Fixed Value" (F) |
Selection Type "Hierarchy Level" ('H'). |
Create and Change |
Creating the First Aggregate for an InfoCube |
Editing Aggregates Manually |
Design and Components of Aggregates |
Further Editing Functions for Aggregates |
Automatic Selection and Optimization of Aggregates |
Proposals from Queries |
Proposals from BI Statistics |
Optimizing Proposed Aggregates |
Activation and Provision of Data |
Activating and Filling Aggregates |
Rolling Up Data in Aggregates |
System Response to Changes to Master Data and Hierarchies |
Loading Data into Aggregates Efficiently |
Performing Checks for Aggregates |
Check Time |
Check Mode |
Technical Information |
Non-Cumulatives |
Modeling Non-Cumulatives with Non-Cumulative Key Figures |
Non-Cumulative Key Figures |
Time Reference Characteristic |
Aggregation Behavior of Non- Cumulative Key Figures |
Validity Area |
Maintaining the Validity Area |
Transferring Non-Cumulative Data into the BI System |
Process Flow for Evaluating Non-Cumulative Key Figures |
Interpreting Query Results |
Excurs.: Mod. Non-Cumul. Key Figs with Differing Time Ref. Chars |
Performance Tips |
BEx Monitor |
Trace Tool Environment |
Trace Tool |
Log User Actions |
Determine a Logged Trace |
Reexecution of Logged User Actions |
Maintenance of Trace Properties |
CAT Tool |
Administration |
OLAP Trace Tool (Old) |
Setting an OLAP Trace |
Query Monitor |
Query Properties |
Read Mode |
Specifying Data Integrity According to the Request Status |
Cache Mode |
Activating Delta Caching |
Specifying the Grouping for Delta Caching |
Accuracy |
Not Using Parallel Processing |
Processing Queries |
Using the Cache Despite Virtual Characteristics and Key Figures |
Technical Information |
OLAP: Cache Monitor |
Global Cache Parameters |
Cache Data Removal and Swapping |
Cache Structure |
Logical File Names |
BI Query Runtime Statistics |
Analysis of Statistics Data |
Maintenance of Statistics Properties |
Analyzing Statistics Data for a MultiProvider Query |
Overview of Statistics Events (Table RSDDSTATEVENTS) |
Aggregation of Query Runtime Statistics |
Migration Details |
Business Planning |
BI Integrated Planning |
Modeling Planning Scenarios |
Modeling Scenarios |
InfoProvider |
Characteristic Relationships |
Characteristic Relationships for Time Characteristics |
Data Slices |
Aggregation Level |
Simple Aggregation Level |
Complex Aggregation Level |
Filters |
Planning Functions |
Process Flow of Planning Function: Distribution by Key |
Standard Planning Function Types |
Unit Conversion |
Generate Combinations |
Formula |
Operators and Functions |
Data Declaration |
Conditional Statements |
Loop Constructs |
Notification Output |
Function Modules |
Examples for Formula Applications |
Copy |
Delete |
Deleting Invalid Combinations |
Forecasting |
Forecast Strategies |
Automatic Model Selection |
Outlier Correction |
Trend Damping |
Logging Statistical Key Figures |
Ignoring Initial Zero Values |
Repost |
Repost (Characteristic Relationships) |
Revaluation |
Distribution by Key |
Distribution by Reference Data |
Currency Translation |
Standard Key Date in Planning Functions |
Planning Sequences |
Scheduling Planning Sequences in Process Chains |
Planning Sequence for Bottom-Up Planning |
Variables |
Changing Variable Values in the Planning Modeler |
Personalizing Variables |
Saving Variants in Planning Functions and Planning Sequences |
Input-Ready Query |
Form-Based Planning |
Implementing Planning Function Types |
Creation of Planning Applications |
Creating Planning Applications in the BEx Analyzer |
Command Wizard |
Transferring Variable Values |
Creating Planning Applications in the BEx Web Application Design |
Commands for Planning Applications |
Refresh Data |
Save Changed Data |
Reset Changed Data |
Set Data Entry Mode |
Execute a Planning Function (Simple) |
Execute a Planning Function |
Execute a Planning Sequence (Simple) |
Sources for Characteristic Selection and Variables |
Additional Examples of Planning Applications in the BEx WAD |
Copying Planning Functions (with Dropdown Box Web Item) |
Revaluating Planning Functions (with Analysis Web Item) |
Documentation (with Analysis Web Item) |
Performing Manual Planning |
Functions for Manual Planning |
Disaggregation (Top-Down Distribution) |
Business Planning Portal Role |
Transport of Planning Objects |
Lock Concept and Lock Management |
Management of Lock Settings |
Storage of Lock Tables |
Selection of Lock Characteristics |
Display of Active Locks |
Analysis of Locking Conflicts |
Display of Master Locks |
Sizing of Lock Tables |
Performance Tips |
Business Planning and Simulation (BW-BPS) |
Overview of Planning with BW-BPS |
Planning Environment |
Buffer Concept (BW-BPS) |
Planning Area |
Editing a Planning Area |
Data Slices |
Multi-Planning Area |
Multi-Planning Area: Application Examples |
Variables |
Defining Variables |
Using Variables |
Characteristic Relationships |
Defining Characteristic Relationships |
Where-Used List for Characteristic Relationships |
Planning Level |
Planning Package |
Set Up of Planning Architecture |
Planning Profile |
Editing and Managing Planning Profiles |
Manual Planning |
Planning Layout |
Determining Basic Settings |
Hierarchically Structured Planning |
BPS Characteristic Hierarchy |
Characteristic Combinations |
Automatic Execution of Planning Functions |
Dynamic Data and Lead Columns |
Rolling Planning |
Determining Detail Settings |
Configuring Data Columns |
Formatting Generated Layout in the Preview |
MS Excel-Specific Formatting Options |
Editing Styles |
Editing the Layout Template |
Setting Totals Rows |
Documents in the Planning Layout |
Entering Plan Data |
Automatic Sign Assignment |
Local Functions |
Manual Data Entry |
Locking Cells, Unlocking Cells |
Top-Down Distribution |
Revaluate |
Planning Layout: Environment-Specific Attributes |
Locking Transaction Data |
Customizing with Reference to the Locking Concept |
Documents |
Creating a Document |
Editing a Document |
Planning Functions |
Undoing Data Changes |
Editing Plan Data Automatically |
Data Transfer to Planning Functions |
Trace Mode for Planning Functions |
Copy |
Distribute |
Repost |
Reposting (Characteristic Relationships) |
Delete (Invalid Combination) |
Revaluation |
Forecasting |
Forecast Strategies |
Automatic Model Selection |
Optimization of Smoothing Factors for Exponential Smoothing |
Outlier Correction |
Trend Dampening |
Setting Negative Forecast Values to Zero |
Logging Statistical Key Figures |
Ignoring Initial Zeros |
Model Initialization |
Forecast (Old) |
Model Selection |
Manual Model Selection |
Automatic Model Selection |
Model Initialization |
Forecast Models |
Forecast Parameters |
Forecast Formulas |
Forecast Exit |
Exit Function for Forecasting |
Forecast Parameters |
Obligatory Forecast Parameters |
Optional Forecast Parameters |
Exit Function for The Log Display |
Formula |
Formula Operands (in Dependency on Key Figure and Characteristic |
Exit Function |
Currency Translation |
Currency Translation: Notes on Modeling |
Unit Conversion |
Unit Conversion: Notes on Modeling |
Planning Sequences |
Planning Folder |
Editing a Planning Folder |
Editing a Planning Folder: Details |
Planning Folder: Portfolio Graphic |
Automatic Execution of Layout-Dependent Planning Functions |
Automatic Execution of Global Functions |
Documents in Planning Folders |
Executing a Planning Folder |
Web Interface Builder |
Creating and Editing Web Interfaces |
Components for Web Interfaces |
Design Templates for Web Interfaces |
Using Your Own Style Sheet (New Design) |
CSS Classes for Web Interfaces (Old Design) |
Modifying CSS Classes for Web Interfaces (Old Design) |
Enhancements for Web Interfaces |
Status and Tracking System |
Authorization Objects in the STS |
Maintaining Web Services for STS |
Customizing the Status and Tracking System |
Executing Customizing |
Determining a Hierarchy for the Subplan |
Determining Date, Person Responsible, Layouts |
Executing Global Planning Sequence upon Status Switch |
Adjusting Notification Texts |
Maintaining Text with Additional Information |
Planning with the Status and Tracking System |
Organization of Planning Tasks |
Executing Planning |
Checking Planning Results |
Monitoring Planning Processes |
Integrating BI Integrated Planning |
Transport |