Preview

Business Intelligence: Generic Extraction

Good Essays
Open Document
Open Document
3167 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Business Intelligence: Generic Extraction
RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

CHAPTER – 4
EXTRACTIONS
It is mainly used for extracting the data form other Source Systems like R/3 etc.
DataSource: Defines as extract structure and transfer structure from source system (like SAP R/3) and transfer structure from BW side.
ES -> What data to be extracted from source system
TS -> What data to be extracted from source system to BW. TS is a group of fields which indicated how the data is coming from the source system BW

R/3
L

ES
E

TS

SAP – BW

T

TS

FLAT FILE

SAP R/3

SAP BW

1

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

TYPES OF EXTRACTIONS

APPLICATION SPECIFIC

BW CONTENT
EXTRACTOR

FI
HR, CO
SAP CRM
LO COCKPIT

CUSTOMER
GENERATED
EXTRACTOR

LIS
FI-SL
CO-PA

APPLIACTION
SPECIFIC
DB TABLES

APPLICATION
SPECIFIC
DB TABLES

BASICS

DELTA METHOD

2

CROSS APPLICATION

GENERIC
EXTRACTOR

DB VIEW
INFOSET
FUNCTION
MODULE

VARIOUS SAP
DB TABLES

ENHANCEMENTS

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

GENERIC EXTRACTION
1. Why do you go for Generic extraction?
- When the data source is not readily available in the Business content
- Even if the Business content data source is available and it is already being used up. And if we want to simulate the same kind of extractor, we can go for generic extraction.
2. The T-code for creating Generic Extraction is RSO2.
3. We can create 3 types of data sources using generic extraction
- Transaction data
- Master data attribute
- Text
4. We can generate generic datasource using the following
- Table
- View
- Function module
- Infoset Query
STEPS TO CREATE GENERIC EXTRATION: (MASTER DATA)
1. Go to T-Code SBIW otherwise go to T-Code RSO2.

3

RAJESH

BUSINESS INTELLIGENCE
GENERIC EXTRACTION

-> Select the radio button Master data Attribute, give name and click on CREATE

-> Select the Application Component by pressing F4
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    NT1210- Unit 1 Assignment 1
    • 856 Words
    • 4 Pages

    NT1210- Unit 1 Assignment 1

    b. Provides a convenient way to name a set of data for easier operations like…

    • 856 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    tut3
    • 370 Words
    • 2 Pages

    tut3

    The following questions are based on the data in file jtrain2.dta (variables are described in file jtrain2.des).…

    • 370 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Project Management and Points
    • 688 Words
    • 3 Pages

    Project Management and Points

    7. Transferring transaction data from a legacy system to the new system would be defined by which category of system design specifications? (Points : 1)…

    • 688 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    M1 ANALYSE DIFFERENT TYPES OF BUSINESS INFORMATION AND THEIR SOURCES
    • 912 Words
    • 3 Pages

    M1 ANALYSE DIFFERENT TYPES OF BUSINESS INFORMATION AND THEIR SOURCES

    Business organisation use business information to communicate within the company and outside the company. This information comes from all different variety of sources. From information written in P1 I will analyse the different type of business information and their sources used by BBC.…

    • 912 Words
    • 3 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    MS Access - Part 1
    • 468 Words
    • 2 Pages

    MS Access - Part 1

    4. The Access view that displays the table data in columns and rows is called…

    • 468 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    M1 Analyse Diffrent Types of Business Information and Their Sources Their
    • 2077 Words
    • 9 Pages

    M1 Analyse Diffrent Types of Business Information and Their Sources Their

    In Project LYD they use different forms of business information to communicate as a business, in this section of my work I am going to investigate the different types of business information that exists in the organisation that I am looking at. They are many different forms of business that will be used for project LYD for communication such as verbal communication, like meetings and conferences, written like emails, onscreen like presentations, multimedia like TV ads and films. And finally web based like facebook, MSN, and Twitter. All of these types of information are important to a project LYD as each one is used when different types of information.…

    • 2077 Words
    • 9 Pages
    Powerful Essays
    Read More
  • Good Essays

    Analyse Different Types of Business Information and Their Sources.
    • 1890 Words
    • 8 Pages

    Analyse Different Types of Business Information and Their Sources.

    Merseytravel uses a lot of different communications to communicate with people, which includes; verbal, written, on-screen, multimedia and web-based communication. Using these five different types of communications, Merseytravel can communicate with other people using different ways to communicate which includes technology and face-to-face.…

    • 1890 Words
    • 8 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    It/210 Course Design
    • 2571 Words
    • 11 Pages

    It/210 Course Design

    Course Design Guide IT/210 Version 5 2 Week One: Introduction to Software Development Details Due Points Objectives 1.1 Describe the importance of using a structured, modular approach when creating program requirements, design, and code. 1.2 Identify how a computer processes and stores data. Course Preparation Read the course description and objectives.…

    • 2571 Words
    • 11 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Business Intelligence Software
    • 1173 Words
    • 5 Pages

    Business Intelligence Software

    As we discuss the possibility of emerging into business intelligence software we must keep in mind the overall purpose of using any type of software is to reach strategic goals in order to increase market shares. I will discuss how business intelligence software will allow us to meet those strategic goals. We will establish what type of information and analysis capabilities will be available once this business intelligence software is implemented. We will discuss hardware and system software that will be required to run specific business intelligence software. Lastly, I will give a brief synopsis on three vendors (IBM, Microsoft Microsoft and Oracle) that are dominating the business information software industry today.…

    • 1173 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Data Processing Contract
    • 2565 Words
    • 11 Pages

    Data Processing Contract

    This DATA PROCESSING AGREEMENT is made and entered into as of the 1st day of August 2008 by and between Big Bank and Systems, Inc. In consideration of the mutual promises and covenants contained herein, the parties hereto agree as follows: 1. DATA PROCESSING SERVICES. Systems Inc. agrees to render to Big Bank the data processing services described on Exhibit "A" (the "Services") for the term of this Agreement, and Big Bank agrees to purchase the Services. This Agreement describes the general nature of the Services and the terms under which the Systems Inc. is to provide or make the Services available to the Big Bank. In the event of any conflict between the language of this Agreement and any brochures, verbal representations, or other materials describing the Services, the language of this Agreement shall control. CONVERSION OF BIG BANK 'S INFORMATION. ---------------------------------------------a. Within a reasonable time following execution of this Agreement, Systems Inc. will undertake the programming required to convert Big Bank 's information files into a format compatible with Systems Inc.’s systems.. Big Bank agrees to cooperate with Systems Inc. in this endeavor and to provide all information and assistance required for Systems Inc. to successfully convert Big Bank 's information files to a form compatible with Systems Inc. 's systems and equipment so that Systems Inc. can provide the Services. Among other things, Big Bank shall deliver conversion input information, in its entirety, in a mutually acceptable medium, within one week of request of the information. Systems Inc. shall determine, in accordance with its normal acceptance procedures, when Big Bank 's information files have been successfully converted and when the Services to be provided by Systems Inc. to Big Bank are operational and available for Big Bank 's use. Big Bank agrees to review and check the information converted by Systems Inc. within…

    • 2565 Words
    • 11 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Nnnk
    • 902 Words
    • 4 Pages

    Nnnk

    and how many loads per day - 3 schedule per day ( G1, G2, G3 ), G1 is…

    • 902 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Contour Business Intelligence
    • 1540 Words
    • 7 Pages

    Contour Business Intelligence

    Ready to use MDI front-end for data warehouse applications powered by ContourCube. Forms full report distribution solution with Contour CubeMaker. Provides highly dynamic interface for interactive data analysis, sophisticated analytical,…

    • 1540 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Good Essays

    Computer Application Java Notes Class 10
    • 7765 Words
    • 32 Pages

    Computer Application Java Notes Class 10

    | CHECKS THE CONDITION FIRST AND THEN THE EXECUTION BEGINS. IT IS KNOWN AS ENTRY CONTROL LOOP…

    • 7765 Words
    • 32 Pages
    Good Essays
    Read More
  • Powerful Essays

    sap data archiving
    • 2029 Words
    • 11 Pages

    sap data archiving

    SAP DATA ARCHIVING INDEX 1. Introduction................................................................................................... 2. Archiving Objects......................................................................................... 2.1 Definition..................................................................................................................................... 2.2 Archiving objects and related tables.......................................................................................... 2.3 Transaction Code SARA and its use for Administration of archiving objects............................…

    • 2029 Words
    • 11 Pages
    Powerful Essays
    Read More
  • Good Essays

    Flow Of Data B/W Different Systems Case Study
    • 907 Words
    • 4 Pages

    Flow Of Data B/W Different Systems Case Study

    Customer data are pushed to Model N through an interface program which role is to maintain consistency between the master and the slave system and make sure that customers are available in Model N for the business transactions. While most of customer management will occur in CRM (BP application), users have the possibility to create new accounts from Model N for the purpose of entering opportunities or quotes without waiting for someone else’s action. These new accounts are then transferred to SAP CRM where they enter the Final Customer Identification (FCI) process for codification if the new customer is to be created for it. Aliasing or Linking of accounts is mater in Model…

    • 907 Words
    • 4 Pages
    Good Essays
    Read More

Related Topics