BI 7.3 New BI Functionality: -
1. Overview
This document explains detailed process of using the new functionalities available with BI 7.3 SP4 upgrade and also provide insight design consideration for reporting and BI back end objects
2. Major New Features in BI 7.3
2A: Extraction Transformation and Loading in BI 7.3
New Graphical developer interface & new dataflow wizards for faster development. External delta extraction can be done with DB connect, UD connect, flat files & web services. An Init & delta package for SAP extraction is merged.
New data source called "web service pull" is added. Can schedule data loads & extractions using BOBJ data services. The RSPCM has many new added features for better process chain monitoring. "Dummy" source systems can be created for development purposes. DTP requests can be archived (faster loads). New MDX test editor for debugging of errors is available.
PSA in BI 7.3 will have increased load performance by ability to re-package small data packages within a request to bigger packages. Can use DTPs to load from Multiproviders. Automatic mapping of Data Source to Info Objects. Ability to change data type & length from source. New abilities for deleting PSA/change Log
2B: Data Store Object and Info-cube
Activation is changed from single lookups to package fetch of active table (20-40% faster activation). Support for database partitioning by time characteristics & ability to remodeling for Data Store objects without reloads. Consistency checks for write optimized DSOs can be turned off (faster loads).
Semantic partitioning Objects (SPO) wizards allow for automated partitioning of large objects & thereby increased performance. No need for hints on multi providers.
New Hybrid provider allows link between historical data in Info Cubes & latest updates in DSOs (faster data access). Improved NLS capabilities
BW 7.3, the technical coding has been optimized to improve the loading performance. Load times into DSO objects has been reduced by up to 40% when compared to BI7, plus the loading of Master Data has been accelerated. Improvements in load performance translate into benefits for the business. Data can be made available earlier in the day, reloads are quicker (so cost less) and larger volumes of data can be loaded each and every day.
2C: Automatic semantic partitioning
Semantic Partitioning is used for similar data across several Info Cubes or DSOs, split according to region or year. This allows increased performance and stability, though comes with at a cost of increased development and maintenance.
With BW 7.3, the BW system can automatically “Semantically Partition” Info Providers. Using a wizard interface, multiple partitions that store your data, handles the mappings between partitions and schedules the loading processes. The need for the manual creation of multiple transformations, DTPs has been removed.
A typical scenario would be to Semantically Partition an Info Cube that is used for Global Sales reporting. By keeping to data for each region or year separate, performance is improved, and maintenance and daily loading is easier.
2D: Graphical Data Flow modeler
A graphical way of building a data model has been introduced in BW 7.3. The Graphical Dataflow Modeler is a new function within the Administrator Workbench (transaction RSA1).
This provides:
• Top-down modeling of a new dataflow
• Organization for existing data flows
• Creation of template data flows using best practice
• SAP delivered pre-defined data flows
Using a drag-and-drop interface, a developer can build a dataflow by selecting either existing objects, or by directly creating new objects from within the modeler. The entire dataflow can be modeled in this way, from the Data Source to the MultiProvider, and even as an OpenHub destination.
2E: Analytical indexes
An Analytical Index (AI) is a transient dataset that is stored within the BWA. BEx or Business Objects can be used to report on them directly. They are defined and loaded from within the Analysis Process Designer (APD), and can contain the results of a JOIN between a CSV file and query.
2F: Hybrid providers
A Hybrid Provider takes a DSO, removing substantial development and maintenance effort. Just load your data into a DSO, create a Hybrid Provider and start reporting. You can even build your Hybrid Provider on a Real time Data Acquisition Data Source (RDA), which could potentially provide near real-time reporting from a BWA. To make data held within a DSO available for reporting, in BI7 there are a number of steps you need to do: Create the DSO, Info Cube, Transformation/DTP, MultiProvider, store in a BWA and connect them all up, and then schedule and monitor load jobs.
A typical usage scenario could be to extract your Sales Orders from ECC and make available for reporting. Using a Hybrid Provider, as soon as the data is loaded into a DSO, they then become available for reporting with all the benefits of an Info Cube and BWA
2G: Hierarchies in Open Hub Service Interface
One new feature in SAP BW 7.3 is the improvement of the Open Hub Service interface to allow extraction of hierarchies. The Open Hub Destination mechanism works the same way as with Info Object attributes or texts
A hierarchy was created manually with SAP BW 7.3. It should reflect a kind of org chart where different managers as hierarchy nodes and finally some employees on the leaf level.
When creating an Open Hub Destination BW 7.3 offers the new Sub object Type "Info Object Hierarchies". This is new feature in BI 7.3. So far you could only choose between Attributes or Texts.
The creation of the corresponding "Transformation" and "Data Transfer Process" works the same way as with the other object types.
To create a process chain this triggers the DTP to copy the data to the Open Hub Destination
2H: Security
Ability to do mass changes for authorizations for users, hierarchies & nodes (faster development & maintenance)
2I: Admin Cockpit
New Admin cockpit monitor for DB usage & issues. New wizard based configuration for installs. New real-time data acquisitioning (RDA) monitor. Central performance monitoring of multiple BW systems possible in Solution Manager. Queries are displayed with OLAP cache & BWA status & usage. Improved search feature in RSA1. Ability to delete historical data from internal statistical cubes. New available version management for metadata objects.
2J: Query Designer and Web Application Designer
Queries can be used as an Info provider. Report Designer is discontinued. BEx query designer remains the core query tool. BEx tools are unchanged, but improved features are available in BOBJ Analysis and Web Intelligence.
Web Application Designer remains, but BI Services Connectors (BICS) is a better solution for Xcelsius, WebI and Analysis tools.
BWA 7.2 enabled. Can index DSO, supports exception aggregation, new calculation engine for restrictive and calculated key figures (RKF/CKF). Info Cubes can now be kept in BWA only (i.e. keep only DSOs in BW). Analytical Indexes (AI) can be made with summarized or transformed data. New APD support for BWA objects (can be used for stats & data mining purposes). Can join multiple indexed objects.
3. Reference Documents for BI 7.3 Design Consideration and New Functionality
3A. Design Consideration for BW 7.30 Info Providers
3B. Optimized DSO Data Activation
3C. SAP Net Weaver BW 7.3 Road Map and Overview
3D. what’s new with SAP Net Weaver BW 7.3
3E. Semantically Partitioned Object in BW 7.30
3F. Automate Content Creation via XML (XML Content and Actions)
1. Overview
This document explains detailed process of using the new functionalities available with BI 7.3 SP4 upgrade and also provide insight design consideration for reporting and BI back end objects
2. Major New Features in BI 7.3
2A: Extraction Transformation and Loading in BI 7.3
New Graphical developer interface & new dataflow wizards for faster development. External delta extraction can be done with DB connect, UD connect, flat files & web services. An Init & delta package for SAP extraction is merged.
New data source called "web service pull" is added. Can schedule data loads & extractions using BOBJ data services. The RSPCM has many new added features for better process chain monitoring. "Dummy" source systems can be created for development purposes. DTP requests can be archived (faster loads). New MDX test editor for debugging of errors is available.
PSA in BI 7.3 will have increased load performance by ability to re-package small data packages within a request to bigger packages. Can use DTPs to load from Multiproviders. Automatic mapping of Data Source to Info Objects. Ability to change data type & length from source. New abilities for deleting PSA/change Log
2B: Data Store Object and Info-cube
Activation is changed from single lookups to package fetch of active table (20-40% faster activation). Support for database partitioning by time characteristics & ability to remodeling for Data Store objects without reloads. Consistency checks for write optimized DSOs can be turned off (faster loads).
Semantic partitioning Objects (SPO) wizards allow for automated partitioning of large objects & thereby increased performance. No need for hints on multi providers.
New Hybrid provider allows link between historical data in Info Cubes & latest updates in DSOs (faster data access). Improved NLS capabilities
BW 7.3, the technical coding has been optimized to improve the loading performance. Load times into DSO objects has been reduced by up to 40% when compared to BI7, plus the loading of Master Data has been accelerated. Improvements in load performance translate into benefits for the business. Data can be made available earlier in the day, reloads are quicker (so cost less) and larger volumes of data can be loaded each and every day.
2C: Automatic semantic partitioning
Semantic Partitioning is used for similar data across several Info Cubes or DSOs, split according to region or year. This allows increased performance and stability, though comes with at a cost of increased development and maintenance.
With BW 7.3, the BW system can automatically “Semantically Partition” Info Providers. Using a wizard interface, multiple partitions that store your data, handles the mappings between partitions and schedules the loading processes. The need for the manual creation of multiple transformations, DTPs has been removed.
A typical scenario would be to Semantically Partition an Info Cube that is used for Global Sales reporting. By keeping to data for each region or year separate, performance is improved, and maintenance and daily loading is easier.
2D: Graphical Data Flow modeler
A graphical way of building a data model has been introduced in BW 7.3. The Graphical Dataflow Modeler is a new function within the Administrator Workbench (transaction RSA1).
This provides:
• Top-down modeling of a new dataflow
• Organization for existing data flows
• Creation of template data flows using best practice
• SAP delivered pre-defined data flows
Using a drag-and-drop interface, a developer can build a dataflow by selecting either existing objects, or by directly creating new objects from within the modeler. The entire dataflow can be modeled in this way, from the Data Source to the MultiProvider, and even as an OpenHub destination.
2E: Analytical indexes
An Analytical Index (AI) is a transient dataset that is stored within the BWA. BEx or Business Objects can be used to report on them directly. They are defined and loaded from within the Analysis Process Designer (APD), and can contain the results of a JOIN between a CSV file and query.
2F: Hybrid providers
A Hybrid Provider takes a DSO, removing substantial development and maintenance effort. Just load your data into a DSO, create a Hybrid Provider and start reporting. You can even build your Hybrid Provider on a Real time Data Acquisition Data Source (RDA), which could potentially provide near real-time reporting from a BWA. To make data held within a DSO available for reporting, in BI7 there are a number of steps you need to do: Create the DSO, Info Cube, Transformation/DTP, MultiProvider, store in a BWA and connect them all up, and then schedule and monitor load jobs.
A typical usage scenario could be to extract your Sales Orders from ECC and make available for reporting. Using a Hybrid Provider, as soon as the data is loaded into a DSO, they then become available for reporting with all the benefits of an Info Cube and BWA
2G: Hierarchies in Open Hub Service Interface
One new feature in SAP BW 7.3 is the improvement of the Open Hub Service interface to allow extraction of hierarchies. The Open Hub Destination mechanism works the same way as with Info Object attributes or texts
A hierarchy was created manually with SAP BW 7.3. It should reflect a kind of org chart where different managers as hierarchy nodes and finally some employees on the leaf level.
When creating an Open Hub Destination BW 7.3 offers the new Sub object Type "Info Object Hierarchies". This is new feature in BI 7.3. So far you could only choose between Attributes or Texts.
The creation of the corresponding "Transformation" and "Data Transfer Process" works the same way as with the other object types.
To create a process chain this triggers the DTP to copy the data to the Open Hub Destination
2H: Security
Ability to do mass changes for authorizations for users, hierarchies & nodes (faster development & maintenance)
2I: Admin Cockpit
New Admin cockpit monitor for DB usage & issues. New wizard based configuration for installs. New real-time data acquisitioning (RDA) monitor. Central performance monitoring of multiple BW systems possible in Solution Manager. Queries are displayed with OLAP cache & BWA status & usage. Improved search feature in RSA1. Ability to delete historical data from internal statistical cubes. New available version management for metadata objects.
2J: Query Designer and Web Application Designer
Queries can be used as an Info provider. Report Designer is discontinued. BEx query designer remains the core query tool. BEx tools are unchanged, but improved features are available in BOBJ Analysis and Web Intelligence.
Web Application Designer remains, but BI Services Connectors (BICS) is a better solution for Xcelsius, WebI and Analysis tools.
BWA 7.2 enabled. Can index DSO, supports exception aggregation, new calculation engine for restrictive and calculated key figures (RKF/CKF). Info Cubes can now be kept in BWA only (i.e. keep only DSOs in BW). Analytical Indexes (AI) can be made with summarized or transformed data. New APD support for BWA objects (can be used for stats & data mining purposes). Can join multiple indexed objects.
3. Reference Documents for BI 7.3 Design Consideration and New Functionality
3A. Design Consideration for BW 7.30 Info Providers
3B. Optimized DSO Data Activation
3C. SAP Net Weaver BW 7.3 Road Map and Overview
3D. what’s new with SAP Net Weaver BW 7.3
3E. Semantically Partitioned Object in BW 7.30
3F. Automate Content Creation via XML (XML Content and Actions)
No comments:
Post a Comment