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 |
Modeling |
Namespaces for BI Objects |
Data Flow Display |
DataSource |
Functions for DataSources |
DataSource Maintenance in BI |
Editing a DataSource from an SAP Source System in BI |
Creating DataSources for File Source Systems |
Creating a DataSource for UD Connect |
Creating a DataSource for DB Connect |
Creating DataSources for Web Services |
Emulation, Migration and Restoring DataSources |
Using an Emulated DataSource 3.x |
Migrating DataSource 3.x |
Restoring DataSource 3.x |
Persistent Staging Area |
DB Storage 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 Storage 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 |
Use of Master Data and Master Data-Bearing Characteristics |
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 Loading of Master Data |
Master Data Lock |
Reorganizing Master Data |
InfoProviders |
InfoCubes |
Star Schema |
Dimension |
Line Item and High Cardinality |
Creating InfoCubes |
Real-Time InfoCubes |
Additional Functions in InfoCube Maintenance |
Checking the Data Loaded in the InfoCube |
Non-Cumulative Value Parameter Maintenance |
DB Storage 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 Objects |
Scenario for DataStore Objects |
Standard DataStore Object |
DataStore Objects for Direct Update |
Write-Optimized DataStore Objects |
Creating DataStore Objects |
DataStore Object Settings |
Additional Functions in DataStore Object Maintenance |
DB Storage Parameters |
Multidimensional Clustering |
Definition of Clustering |
DataStore Data and External Applications |
Questions and Answers |
InfoObjects As InfoProvider |
VirtualProviders |
VirtualProvider Based on the Data Transfer Process |
Creating VirtualProviders Based on the Data Transfer Process |
VirtualProvider with BAPI |
VirtualProviders with Function Modules |
InfoSet |
Creating InfoSets |
Editing InfoSets |
Special Features of InfoCubes in InfoSets |
Additional Functions in the InfoSet Builder |
Screen Layout: Changing InfoSets |
Matching InfoSets |
Join Control |
Defining Join Conditions |
Left Outer Join |
Examples of Condition Conversion |
Editing InfoProviders in the Join Control |
Temporal Join |
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 |
Dividing a MultiProvider Query into Sub-Queries |
Parallelization of Subqueries Versus Sequential Processing |
Example: List of Slow-Moving Items |
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 |
Remodel InfoProvider |
Customer Exit in Remodeling |
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 |
Transferring BI Content DataSources into Active Version |
Editing the DataSource in the Source System |
Replicating DataSources |
Editing a DataSource from an SAP Source System in BI |
Using an Emulated DataSource 3.x |
Data Reconciliation |
Delta Process |
Functions in the SAP Source System |
Maintaining Control Parameters for Data Transfer |
Restricting Authorizations for the Extraction |
Checking the Delta Queue |
Transferring the Application Component Hierarchy |
Installing Business Content DataSources |
Maintaining Generic DataSources |
Delta Transfer into BW |
Function Module: Interface Description and Procedure |
Testing Extraction |
Extraction Using the SAP Query |
Notes for Extraction Using the SAP Query |
SAP Query: Assignment to a User Group |
Editing DataSources & 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 |
SOAP-Based Transfer of Data |
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 a DataSource for UD Connect |
Creating DataSource 3.x |
Using InfoObjects with UD Connect |
Data Types and Their Conversion |
Using SAP Namespace for Generated Objects |
Using an Emulated DataSource 3.x |
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 |
BI JDBC Connector |
BI ODBO Connector |
BI SAP Query Connector |
BI XMLA Connector |
Data Transfer with DB Connect |
DB Connect Architecture |
Installing the Database Shared Library (DBSL) |
Supported Databases |
Requests to Database Tables and Database Views |
Database Users and Database Schemas |
Creating Database Management Systems as Source Systems |
Creating a DataSource for DB Connect |
Generating DataSource 3.x |
Using an Emulated DataSource 3.x |
Localizing Errors |
Updating Metadata |
Transferring Data from Flat Files |
Creating DataSources for File Source Systems |
Using an Emulated DataSource 3.x |
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 |
Transformation |
Rule Type |
The Transformation Library and Formula Builder |
Example for Using the Formula Editor |
BAdI: Customer-Defined Functions in the Formula Builder |
Transformation Type |
Creating Transformations |
Routines In the Transformation |
Creating Routines |
Routine Parameters (As Rule Type) |
Regular Expressions in Routines |
InfoSource |
Old Transformation Concept |
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 |
The Transformation Library and Formula Builder |
Example for Using the Formula Editor |
BAdI: Customer-Defined Functions in the Formula Builder |
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 |
Update of DataStore Object Data |
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 |
Creating a Data Transfer Process for Real-Time Data Acquisition |
Creating Data Transfer Processes for Direct Access |
Handling Data Records with Errors |
Error Stack |
Temporary Storage |
Monitor |
Data Mart Interface |
Data Mart Interface Between Several Systems |
Using the Data Mart Interface |
Generation of the Export DataSource for an InfoProvider |
Generating the Master Data Export DataSource |
Transferring Transaction Data for the Data Mart Interface |
Transferring Texts and Hierarchies for 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 |
Process Chain |
Process |
Start Process |
Application Process |
Operating System Command |
Including Operating System Commands as Processes in Process Chai |
ABAP Programs |
Process Chain Remote |
Local Process Chains |
Decisions |
Including Decision as a Process in the Process Chain |
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/Maintain Process Chain Attributes |
BW Monitor in CCMS |
Send Alerts for Process Chains |
Process Chain Logs Display |
Repairing/Repeating Terminated Processes |
Maintenance of Process Types |
Authorizations for Process Chains |
Scheduler |
Creating InfoPackages |
Additional Scheduler Functions |
Maintaining Data Transfer Control Parameters for DataSources |
Handling Duplicated 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 Scheduler Functions |
Maintaining Data Transfer Control Parameters for DataSources |
Handling Duplicated Data Records |
Handling Data Records with Errors |
Subsequent Processing |
Monitor for Extraction Processes and Data Transfer Processes |
Selection Screen |
Request Overview |
Detail Screen |
Update Simulation in the Monitor |
Traffic Lights |
Wizard |
Administration of InfoProviders |
Managing InfoCubes |
InfoCube Content |
Transferring InfoCube Contents |
Selective Deletion |
InfoCube Performance |
Compressing InfoCubes |
Requests in the InfoCube |
Automatic Subsequent Processing |
Reconstructing InfoCubes |
Functional Constraints of Processes |
Status Overview of DataStore Objects |
Administration of DataStore Objects |
DataStore Object Content |
Requests in a DataStore Object |
Reconstruction of DataStore Objects |
Performance Optimization for DataStore Objects |
Functional Constraints of Processes |
Managing InfoObjects |
Information Lifecycle Management |
Data Archiving |
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 |
Defining Analysis Authorizations |
Settings for Hierarchy Authorizations |
Authorizations with Variables |
Authorizations for Display Attributes |
Generation of Analysis Authorizations |
Assigning Authorization to a User |
Error Log |
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: Indexing Metadata |
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 |
Documents |
Document Classes |
Working with Documents in Knowledge Management |
Document Structure for Metadata |
Document Structure for Master Data |
Document Structure for InfoProvider Data |
Repository Manager for BI Documents |
BI Security Manager for Documents |
Migration of Documents into the CM Repository |
Migration iView |
Migrating Documents |
Repository Manager for BI Metadata |
Working with Documents in Web Applications |
Using Documents in Web Applications |
Creating New Documents |
Displaying Documents for InfoProvider Data |
Displaying Documents for a Cell |
Special Features of Calculated Key Figures and Formulas |
Documents as Online Documentation |
Hyperlinks to Documents |
Working with Documents in the Data Warehousing Workbench |
Processing Documents in the DW Workbench Documents View |
Processing Documents in the Documents Screen |
Creating Documents |
Exporting Documents |
Documents as Online Documentation |
Working with Documents in the BEx Analyzer |
Documents as Online Documentation |
Searches in Documents |
BAdIs for Use in Documents |
Translating Text for BI Objects |
Transport System |
Object Changeability |
Transport-Relevant Metadata Object Types |
Versions within the Transport |
Standard and BI Transport Connection (A Comparison) |
Switching the Standard Transport System On and Off |
BI Transport Connection: Transporting Objects |
Subsequently Changing Package Assignment |
Transporting Roles |
Transporting Hierarchy InfoPackages |
Transporting BEx Objects |
Business Content (Versions) |
Installing Business Content |
Collection Object Grouping |
View of Objects and Object-Specific Recommendations |
Installing BI Statistics |
Customer and Partner Content |
Customer Content |
System Landscape |
System Settings in the BW System |
Delivery of Business Content by SAP |
Using Namespaces for Developing BI Objects |
Object Changeability in a Customer Content System |
Content Delivery by Customers |
Transport and Delivery of Source System-Dependant Objects |
Transfer Rule and DataSource |
Transfer Structure |
InfoPackage |
Process Chain and Process Variant |
Error when Activating Partner Content |
Features when Transporting Roles |
InfoArea, Application Component and InfoPackageGroup |
Comparing ABAP Code |
Customer Content in the OLTP System |
System Settings in the OLTP System |
Business Content Delivery in OLTP Systems by SAP |
Creating Partner Content in the OLTP System |
Delivery and Use of Partner Content in the OLTP System |
Functions in the SAP Source System |
Maintaining Control Parameters for Data Transfer |
Restricting Authorizations for the Extraction |
Checking the Delta Queue |
Transferring the Application Component Hierarchy |
Installing Business Content DataSources |
Maintaining Generic DataSources |
Delta Transfer into BW |
Function Module: Interface Description and Procedure |
Testing Extraction |
Extraction Using the SAP Query |
Notes for Extraction Using the SAP Query |
SAP Query: Assignment to a User Group |
Editing DataSources & Application Component Hierarchies |
Enhancing DataSources |
Partner Content |
InfoAreas, Application Components, and InfoPackage Groups |
Documents for Content Objects |
Technical Content |
BW Statistics |
Activating Data Transfers for BW Statistics |
InfoCubes |
BW Statistics MultiProvider |
BW Statistics – OLAP |
BW Statistics - OLAP, Detail Navigation |
BW Statistics - Aggregates |
BW Statistics - WHM |
BW Statistics: Condensation of InfoCubes |
BW Statistics: Deleting Data from InfoCubes |
BW Statistics – Metadata |
Characteristics |
ABAP Routines |
Aggregate |
Aggregate Cube |
Aggregation Level |
User |
Application Component |
Workbook |
Type of data read |
Automatic/Manual Posting |
BW Metadata Repository: Association Type |
BW System |
Report/Report Interface InfoCube |
Report/Report Interface Query |
InfoCube from which Aggregate Was Supplied with Data |
DataSource |
Data Request (SID) |
Update Rules |
Frontend session |
Aggregate Fill Mode |
Hierarchy |
Hierarchy Level |
InfoArea |
InfoCube |
InfoObject |
InfoObject Catalog |
InfoPackage ID |
InfoPackage Group ID |
InfoSet |
InfoSet Query |
InfoSource |
Calendar Year |
Calendar year / month |
Calendar year / Quarter |
Calendar Year / Week |
Calendar day |
Communication Structure |
Runtime Category |
Characteristic Value |
Delete Data from InfoCube Mode |
Navigation Step |
Navigation Step |
ODS |
OLAP reading on/off |
BW Metadata Repository Object |
BW Metadata Repository Object Type |
Object Version |
Source System |
Source System ID |
Query |
Reporting Agent Settings |
Reporting Agent Package |
Role |
Statistics data UID |
Search Term |
Transfer Structure |
UTC Timestamp |
Time |
OLAP Processor Method |
Process Type (WHM) |
Currency Translation Type |
WHM Transfer Type |
Transfer Rules |
Key Figures |
Number of Database-Selects |
Number of Frontend Sessions |
Number of Navigations |
Number of Texts Read |
Number, All Data Records |
Number of Texts Read |
Number, Deleted Data Records |
Formatting Transferred to Frontend |
Total (OLAP) |
Total Number of Records (WHM) |
Total time (OLAP) |
Total Load Time(WHM) |
Frequency |
Condenser: Number of Updated Records |
Condenser: Number of Added Records |
Condenser: Number of Deleted Records |
Condenser: Number of Marker Updates |
Condenser: Number of Added Markers |
Condenser: Number of Selected Records |
Condenser: Summarization Ratio |
Condenser Runtime |
Read-Cycles (Fetch) OLAP Processor |
Last Used (Day) |
Last Used (Time) |
ODBO: External Calls for Function Module |
ODBO: Size of the Internal Buffer |
Start date |
Start time |
Records (WHM Process) |
Records, Read for Aggregate Structure |
Records, Written To Aggregate |
Records Selected from the Database |
Records Transferred from the Database |
Time (WHM Method) |
Time, Analysis |
Time, Creating Indices |
Time, Authorization Check |
Time, Data Manager Authorizations for Non-Cumulatives |
Time, Data Manager Determining SIDs for RemoteCube |
Time, Data Manager Reading from BasicCube |
Time, Data Manager Reading from ODS |
Time, Data Manager Reading from RemoteCube |
Time, Data Manager InfoCube Access |
Time, Analyzing Dimension Tables |
Time, Inputting Variables |
Time ,Frontend |
Time, OLAP Processor Initialization |
Time, Reading to the Database |
Time, Reading Texts/Master Data |
Time, Records Deletion |
Time, General ODBO |
Time, ODBO: Data Requests |
Time, ODBO: Initialization |
Time, ODBO: Conversion into Flat Table Form |
Time, ODBO: Axes Preparation |
Time, ODBO: Data Records Preparation |
Time, OLAP Processor |
Time, Deleting Partitions |
Time, Counting Records |
Time That the System Was Unable to Assign |
Time of Total Deletion Procedure |
Time, Construction of Temporary Tables |
Time Between Navigation Steps |
Time: Adding when Rolling Up in Aggregate |
Time: Reading when Rolling Up in Aggregate |
Cells Transferred to the Frontend |
BW Statistics Queries |
BW Statistics MultiProvider Structures |
Data Records (OLAP) |
Data Records (OLAP) |
Total Time and Records (OLAP) |
Last Use (Individual Record) |
Last Use (Navigations) |
Average Times and Records (Navigation) |
Using Aggregates |
Times (OLAP) |
Times (OLAP) for Diagrams |
Times and Data Records (OLAP) |
Times and Records (WHM) |
BW Statistics MultiProvider Queries |
Chart: OLAP Records per InfoCube |
Chart: OLAP Times per InfoCube |
Fill Variable: Navigation Steps for Time Period |
Rolling up Aggregates |
Compressing Data into InfoCubes |
Query Runtime |
Deleting Data in InfoCubes |
Deleting Data in InfoCubes – Detail, Times |
Deleting Data in InfoCubes – Details, Records |
Deleting Data in InfoCubes - Overview |
Mean Time per Query |
Mean Time per Query |
OLAP Usage |
OLAP Usage per User |
OLAP Usage for Each User (Total Number of Records) |
OLAP Usage for Each User (Overall Time) |
OLAP Usage for Each User (Time) |
OLAP Usage per InfoCube |
OLAP Usage by InfoCube (Records) |
OLAP Usage for Each InfoCube (Time) |
OLAP Usage per Query |
OLAP Usage per Query (Time) |
OLAP Use by Date |
OLAP Usage According to Time |
WHM Use per InfoCube |
WHM Use per InfoSource |
WHM Use per Day |
WHM Use for Each Time |
OLAP Performance with/without Read on Demand / Aggregates |
Transfer Method: Loading Data |
Using InfoCubes: OLAP / WHM |
Using InfoCubes: OLAP / WHM - Records |
Using InfoCubes: OLAP / WHM - Time |
Using InfoCubes: Reporting / Loading |
Using Hierarchies |
Using InfoCubes |
InfoCube BW Statistics Queries - OLAP, Detail |
Using Hierarchies |
Using InfoCubes / Aggregates to Navigate |
Using InfoObjects |
Using InfoObjects to Navigate |
BW Data Slice |
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 |
Archiving Request Administration Data |
Archiving Request Administration Data |
Reloading Request Administration Data |
Editing Requests with Archived Administration Data |
Archive Administration for Request Administration Data |
Clients in BW |
Clients: OLTP Systems and the Business Information Warehouse |
Administrating Crystal Reports |
Managing Crystal Reports (RSCR_ADMIN_REPORTS) |
Checking Installation Settings (RSCR_CHECK_INSTALLATION_PARAMS) |
Clean Role Tree (RSCR_ROLES_REORG) |
Update Role Structure (RSCR_SYNCHRONIZE_ROLES) |
Real-Time Data Acquisition |
Daemon for Real-Time Data Acquisition |
Monitor: Real-Time Data Acquisition |
Creating an InfoPackage for Real-Time Data Acquisition |
Creating a Data Transfer Process for Real-Time Data Acquisition |