- How to load Master data Tables from Flat files:--------------------------------------------------- Pre -Requisites:------------------- Source System Connection - Fltafile

- Steps:--------1. Create Application Component

2. Create Info Source - Communication Structure

- Direct Update- Flexible Update

3. Assign Data Source to Info Source

Data Source - Transfer Structure

- ATTR,TEXT,HIER,TD

4. Activate the Transfer Rules

5. Create Infopackage and schedule the loading

- Creating Info Cube:----------------------

- Understanding the Underlying Database Tables of the Info Cube: ---------------------------------------------------------------------

Fact Table - /BIC,0/FXXXXXXXBIG_001 - /BIC/FBIG_001

Dimension Tables - /BIC,0/DXXXXXXXX1,2,3,4,5,6,7,8,9,A,B,C,D,P,T,U

dim: customer - 1 == /BIC/DBIG_0011

- Listschema--------------

- Graphical Schema of the Info Cube------------------------------------

- Loading data from flat file into Info Cube:--------------------------------------------- Steps:---------1. Create Info Source - Flexible Update

1.1) Define the communication Structure

2. Assign the Data Source to Info Source

3. Activate the Transfer rules

4. Create the Update rules

5. Create the Info package & schedule the load

Reporting:------------ BEx (Business Explorer)=================- Query Designer - To Design Bex Query- Analyzer - To Design BEx Workbooks- WAD (Web Application Designer) - To design Web reports

- Query Designer - To Design Bex Query-------------------------------------------- Demo How to Design Simple Queries

- Transfer rules----------------- Data Flow

- Why TR...?

- How...?----------- 4 types of Transfer rules---------------------------1. Direct Mapping2. Constant3. Formula4. Routine (Tranfer routine)

- Demo Transfer Rules

CASE TRAN_STRUCTURE-/BIC/BIGSOFF.

WHEN 'HYD'. CONCATENATE 'H' TRAN_STRUCTURE-/BIC/BIGSREP.

How to Debug the Transfer ri\outine:--------------------------------------- COMPUTE_/BIC/BIGSREP

- Start Routine:-----------------

- How to Debug Start routine of Transfer Rules------------------------------------------------- STARTROUTINE

- More Functions in ABAP/4-----------------------------

- Update Rules:----------------- Mapping Between Info Source & data Target(Info Cube)- Transformations

- Types of Update Rules:-------------------------- Key Figure:--------------- Source Key Figure- Formula- Routine

- Characterictic:------------------ Source Char- Constant- Initial Value- Formula- Routine- Master Data Attribute of (***)

- Time Characteristic:------------------------ Source Char- Constant- Initial Value- Formula- Routine- Master Data Attribute of (***)- Time Distribution

- Time Distribution:-------------------

- Master Data Attribute of:---------------------------- BIGCNO ---> BIGCLOC

- BIGMNO --> BIGMGRP

- How to Debug the Update rules:------------------------------------ ROUTINE_9998

LT_CUSTOMER

- Unit calculation in the routine:---------------------------------

- Return Table---------------

- Difference Between Update Rules / Transfer Rules:------------------------------------------------------- TR are specific to Source or Data Source and UR are specific to Data Target- TR will only transfer the data but UR will also update the data by gen DIM ID's

- Deleting data in Info Cube:

------------------------------- Selective Deletion- Deletion by request- Delete data

- Transfer Methods:---------------------- PSA [Persistent Staging Area]---------------------------------Data is Transfered to PSA table directly through TRFC portInformation is Transfered through Info IDOC's

- PSA Table [/BIC/B000*]- Similar to Transfer Structure Fields + 4 fileds(Request Number + Data Packet No + Record No + Partion No) (Primary Key)

- we can edit the records in PSA- PSA holds replica of data coming from source- Enables Error handling

- RSKC - Allow special characterRSALLOWEDCHAR

- How to delete data in PSA?

- IDOC [Intermediate Document]-----------------------------------Data is Transfered through Data IDOC'sInformation is Transfered through Info IDOC's

- Processing Types:

- Data Selections:------------------

- Dynamic Selections:------------------------

0 1 2 3 4 5 6 7Y Y Y Y M M D D================================================2 0 0 7 0 3 3 0

SY-DATUM+0(4)

SY-DATUM+4(2)