Business Intelligence |
Neuerungen und Änderungen in BI mit SAP NetWeaver 2004s |
Data Warehousing |
Data Warehousing: Step by Step |
Data Warehousing Workbench |
Data Warehousing Workbench - Modeling |
Modeling |
Namespaces for BI Objects |
Data Flow Display |
DataSource |
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 BW Master Data into a dBase File |
Maintaining the SAPBWKEY Column |
Uploading Edited Shape Files into BW |
Geocoding |
Downloading BW 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 |
Clustering |
Definition of Clustering |
Selecting MDC Dimensions |
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 |
VirtualProviders Based on the Data Transfer Process |
Creating VirtualProviders Based on the Data Transfer Process |
VirtualProviders 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 |
Implementation Scenario: List of Slow-Moving Items |
Staging Scenarios |
Data Storage Properties |
Staging Scenarios with Persistent Data Storage |
Staging Scenarios without Persistent Data Storage |
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 |
Transferring Business Content DataSources into Active Version |
Maintaining DataSources |
Editing the DataSource in BI |
Using an Emulated DataSource 3.x |
Extraction Structure |
Delta Process |
Customizing Extractors |
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 |
Metadata Upload for SAP Systems |
Functions of the Previous Concept |
Assigning DataSources to InfoSources and Fields to InfoObjects |
Transfer Structure |
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 DataSources |
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 DataSources |
Generating DataSource 3.x |
Using an Emulated DataSource 3.x |
Localizing Errors |
Updating Metadata |
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 |
Transformations |
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 During the Transformation |
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 |
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 Data Targets |
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 |
Transferring Update Rules from a Template |
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 |
Extraction to Database Tables |
Extraction to Flat Files |
Extraction Mode for the InfoSpoke |
Creating InfoSpokes |
Including InfoSpokes in Process Chains |
Extraction to Non-SAP Systems |
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 (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 Load 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 |
Remodeling InfoProviders |
Remodel InfoProvider |
Customer Exit in Remodeling |
Error Handling |
Repartitioning |
Reclustering |
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 |
Authorization for Documents |
Authorizations for Master Data |
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 |
Documents |
Document Classes |
Documents as Online Documentation |
Processing Documents in the AWB Documents View |
Processing Documents in the Documents Screen |
Creating Documents |
Exporting Documents |
Hyperlinks to Documents |
Searches in Documents |
Managing Documents in BI |
Retrieval: Search Server Relation Monitor |
Tab Page: Content Repository |
Tab Page: Indexing for a Search |
Setting up Indexes for Initial Searches |
Generating Metadata Documentation Initially |
Tab Page: Generated Properties |
Characteristic Is Document Property |
Tab Page: Online Documentation |
Valid File Types |
Editing Valid File Types |
BAdIs for Use in Documents |
Translating a Text for BW 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 a Namespace for the Development of BW 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 |
Customizing Extractors |
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 |
BI Platform |
OLAP |
Special OLAP Functions and Services |
Aggregation |
Scenarios for the Use of an Exception Aggregation |
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 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 |
Selecting Constants |
Implementation Scenario: List of Slow-Moving Items |
Analysis Authorizations |
Report-Report Interface |
Editing Sender-Receiver Assignments to the RRI in the BI System |
Receivers |
Maintaining Assignment Details |
Creating a Transaction as a Receiver |
Creating a Web Address As a Receiver |
Examples for Jumping to Web Pages |
BEx Query as Recipient |
Example of a BEx Query as a Receiver |
Web Applications As Sender |
Performance Optimization |
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 |
Aggregates and HPA Indexes |
Aggregates |
Selection Type "All Characteristic Values" ('*') |
Selection Type "Fixed Value" (‘F’) |
Selection Type "Hierarchy Level" ('H'). |
HPA Index |
Technical Information About the HPA Engine |
Create and Change |
Creating the First Aggregate for an InfoCube |
Editing Aggregates Manually |
Automatically Selecting and Optimizing Aggregates |
Proposals from Queries |
Proposals from BI Statistics |
Optimizing Proposed Aggregates |
Creating HPA Indexes |
Activation and Provision of Data |
Activating and Filling Aggregates |
Rolling Up Data in Aggregates |
Loading Data into Aggregates Efficiently |
Further Editing Functions for Aggregates |
Activating and Filling HPA Indexes |
Rolling Up Data in HPA Indexes |
Additional Editing Functions for HPA Indexes |
System Response Upon Changes to Data |
System Response Upon Changes to Data: Aggregate |
System Response Upon Changes to Data: HPA Index |
Improving Efficiency Using HPA Delta Indexes |
Status Display and Check Tools |
Design and Components of Aggregates |
Performing Checks for Aggregates |
Check Time |
Check Mode |
Technical Information |
Design and Properties of HPA Indexes |
Checking the Data in a HPA Index |
Statistics for the Maintenance Processes of a HPA Index |
BEx Monitor |
OLAP Trace Tool |
Setting an OLAP Trace |
Query Monitor |
Query Properties |
Read Mode |
Cache Mode |
Accuracy |
Not Using Parallel Processing |
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 |
Metadata Repository |
Searching for Metadata |
Displaying Graphics |
HTML Export |
Exchanging Metadata in XMI Format |
Calling the Metadata Repository as an HTTP Service |
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 a Web Interface |
Components for Web Interfaces |
CSS Classes for Web Interfaces |
Modifying CSS Classes 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 |
Overview: Planning with the Status and Tracking System |
Planning with the Status and Tracking System |
Executing Planning |
Checking Planning Results |
Monitoring Planning Processes |
Transport |
Translation |
Data Modeling: Key Figure Model and Account Model |
Architecture and System Landscape (BW-BPS) |
Application Programming Interface (API) |
Workflow Scenarios for BW-BPS |
Technical Realization |
Preparation and Customizing |
Workflow: Manual Planning and Planning Function |
Workflow: Planning Session with One Layout |
Workflow: Planning Session with Several Layouts |
Analysis Process Designer |
Structure of the Analysis Process Designer |
Data Sources for an Analysis Process |
Attributes of a Characteristic |
InfoProviders |
Query |
File |
Database Table |
Transformations for an Analysis Process |
Limiting Data Volume |
Aggregating data |
Joining Data from Multiple Sources (Join) |
Hiding Columns |
Sorting Data |
Transforming Lists into Data Records |
Transformation of Data Records into Lists |
ABAP routines |
Data Mining Methods |
Data Targets for an Analysis Process |
Attributes of a Characteristic |
DataStore Object |
CRM Attributes |
Data Targets for SAP CRM |
Data Mining Models |
Modeling an Analysis Process |
Creating an Analysis Process |
Checking Data |
Formulas to Calculate the Statistics |
Additional APD Functions |
Data Mining |
Decision Trees |
Scoring |
Regression Analysis |
Special Settings for Regression Analysis |
Weighted Score Tables |
Special Settings for Weighted Score Tables |
Settings for All Function Types |
ABC Classification |
Model Settings |
Classification Rules |
Clustering |
Association Analysis |
Activities in the Data Mining Workbench |
Creating, Changing, and Activating a Model |
Resetting or Deleting a Model |
Executing What If Analysis |
Using the Where Used List |
Exporting Model as PMML |
Maintaining DataSource for Association Rules |
Activities in the Analysis Process Designer (APD) |
Creating Analysis Process for Training |
Analysis Process for Data Mining Transformations |
Analysis Process for Executing the Prediction |
Evaluating a Decision Tree Model |
Transformation for Weighted Score Tables |
Transformation for ABC Classification |
Loading Mining Results into SAP BW |
Loading Mining Results into SAP CRM |
Reporting Agent |
Defining Settings for Exceptions |
Tab Page: Parameter(s) |
Editing a Follow-Up Action: Send Message |
Editing Follow Up Actions: Alert Monitor Entry |
Example for Alert Texts |
Editing the Follow-Up Action: Export |
BAdI: Export of BW Alerts (RSRA_ALERT) |
Interface (IF_EX_RSRA_ALERT) |
Interface Method INITIALIZE |
SUBMIT Interface Method |
Parameter I_T_ALERT_DEFINITION |
Parameter I_TX_ALERT_CONTAINER |
Parameter FLT_VAL |
Defining Print Settings |
Tab Page: Print Settings |
Defining the Print Layout |
Defining Web Template Settings |
Parameter DATA_MODE |
Control Query for Pre-calculating Web Templates |
Defining Value Set Settings |
Defining Crystal Reports Queries Settings |
Parameterizing the Crystal Reports Queries Setting |
Processing the Scheduling Package |
Creating a Scheduling Package |
Assigning Reporting Agent Settings |
Scheduling a Package as a Job |
Including Packages in a Process Chain |
|