Preview

SAP BW Infosource

Good Essays
Open Document
Open Document
645 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
SAP BW Infosource
InfoSource
An InfoSource combines quantity of information that logically belongs together, summarized into a single unit. It prepares consolidated data for updating to the data targets. InfoSources contain either transaction data or master data (attributes, texts and hierarchies).
When you want to load the related data from different datasources to the data targets, Infosource comes into picture.
Role of InfoSource in SAP BW- There is a difference in use of InfoSource between BW and BI.

In BW, a DataSource is assigned to an InfoSource. If fields that logically belong together exist in various source systems, they can be grouped together into a single InfoSource in BW, in which multiple DataSources can be assigned to an InfoSource.
In the BW Processing Transfer Rules, individual DataSource fields are assigned to the corresponding InfoObject of the InfoSource. Here you can also determine how the data for a DataSource can actually be transferred to the InfoSource. The uploaded data is transformed using transfer rules. An extensive library of transformation functions that contain business logic can be used here to perform data cleansing and to make the data analyzable.
The transfer structure is used to transfer data to the BW system. The data is transferred 1:1 from the transfer structure of the source system into the BW transfer structure.

If you are dealing with an InfoSource with flexible updating, then the data is updated from the communication structure into the InfoCube into other data targets with the aid of the Update Rules. InfoSources with direct updating permit master data to be written directly (without update rules) into the master data tables.

Role of infosource in SAP BI-
In contrast to 3.x InfoSources, as of Release SAP NetWeaver BI 7.0, an InfoSource behaves like an InfoSource with flexible update
The data in an InfoSource is updated to an InfoProvider using a transformation.
You can define the InfoObjects of the

You May Also Find These Documents Helpful

  • Powerful Essays

    M150a Review Questions

    • 2913 Words
    • 11 Pages

    Information : An item of knowledge that is generated by linking together items of data to answer question of interest.…

    • 2913 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    Bsat 303 Final Study Guide 1

    • 4353 Words
    • 23 Pages

    o Data management component – stores and maintains the information that you want your DSS to…

    • 4353 Words
    • 23 Pages
    Powerful Essays
  • Better Essays

    Created in many different forms and formats, data is collected, processed, stored, and retrieved by business to support the many informational needs of organizations.�� INCLUDEPICTURE "https://api.turnitin.com/images/spacer.gif" * MERGEFORMATINET �� HYPERLINK "javascript:void(0);" Business data enters an organization 's information system through software applications. The software applications process and code the data with proprietary formats that are difficult to extract or report without the help of sophisticated report writer or data extraction tools.�� INCLUDEPICTURE "https://api.turnitin.com/images/spacer.gif" * MERGEFORMATINET �� HYPERLINK "javascript:void(0);" Data is the heart of any business. Without good data turned into information, management can not make the proper decisions.�� INCLUDEPICTURE "https://api.turnitin.com/images/spacer.gif" * MERGEFORMATINET �� HYPERLINK "javascript:void(0);" The advances in computer processing power, storage capabilities, and the development of more ways to add information to data have paved the way for a radically new approach to collecting, storing, retrieving, and reporting business information: to build an entire information…

    • 1645 Words
    • 7 Pages
    Better Essays
  • Powerful Essays

    Sap America Case Study

    • 1429 Words
    • 6 Pages

    The case is about a company named SAP America, which is the abbreviation for Systems, Applications and Programs in Data Processing, which in three short years had gone from a smaller company to the heavy hitter within the corporate computing world. Within this case there were many details brought to light on the ambition of the founding members, and the eventual additions to the SAP team. The case details how this firm took their R/3 product, which was a real-time, integrated applications software, and changed the game of product market infiltration.…

    • 1429 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Homework

    • 1219 Words
    • 5 Pages

    …… Detailed information about a system’s design specifications, its internal workings, and its functionality. …… Running the old information system and the new one at…

    • 1219 Words
    • 5 Pages
    Satisfactory Essays
  • Powerful Essays

    Research

    • 12175 Words
    • 49 Pages

    There are certain terms of the English language that we take for granted and use interchangeably without knowing the correct usage of these words. Two such terms are data and information, used in everyday life and substituted for one another as we please. However there is a significant difference between the two words which requires clarity for even those whose first language is English…

    • 12175 Words
    • 49 Pages
    Powerful Essays
  • Powerful Essays

    Canadian Tires

    • 1557 Words
    • 7 Pages

    Data quality and integration proved to be the biggest challenge at CTC. As the company’s IW grew dramatically after 1994, it was evolving on old infrastructure and a poorly defined data model. The data model did not reflect the data requirements of the business and because of the lack of standard data definitions, several versions of the truth could be extracted from IW.…

    • 1557 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    data integration

    • 3605 Words
    • 15 Pages

    Issues with combining heterogeneous data sources under a single query interface have existed for some time. The rapid adoption of databases after the 1960s naturally led to the need to share or to merge existing repositories. This merging can take place at several levels in the database architecture.…

    • 3605 Words
    • 15 Pages
    Powerful Essays
  • Good Essays

    Business Intelligence

    • 812 Words
    • 4 Pages

    b. Data are often buried within numerous small databases, which sometimes contain data from several…

    • 812 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Database Concepts

    • 1636 Words
    • 7 Pages

    8) By separating data into tables containing data on only one theme each, making changes to the data is simplified.…

    • 1636 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Database Final Exam

    • 1376 Words
    • 6 Pages

    Data are stored in a collection of tables and the data relationships are represented by common values not links.…

    • 1376 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Information could be looked at as data as well. Let’s say we need a chart showing the cost of a business expenses in relation to employee salaries. The data for showing the information is the amount of money each employee is being paid on a monthly basis for example. Each person’s salary is a piece of data represented by numbers. That data is then compiled to show on overall amount of money the business is spending on paying employees. Obviously much more is calculated, but let’s keep it simple. So now the boss sees this information and wants to know…

    • 880 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    The heart of the integration of information needed in MIS is a data base. A data base is…

    • 1327 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    An information system refers to a collection of multiple pieces of equipment involved in the dissemination of information. Hardware, software, computer system connections and information, information system users, and the system’s housing are all part of an IS.…

    • 512 Words
    • 2 Pages
    Good Essays
  • Good Essays

    - Digital firm is one in which nearly all of the organization’s significant business relationships with customers, suppliers, and employers are digitally enabled and mediated.…

    • 2234 Words
    • 9 Pages
    Good Essays

Related Topics