27interviews.blogspot

This blog doesn't contain any copied information or copyright content from other sites. Every topic i presented in this blog is authored myself. Every time i tried to help the sapients to understand the concept in an easier way. Thats it. Have a Grt Day!

Translate

WHAT ARE DRILL, DRILL DOWN, DRILL UP, DRILL BY, DRILL ACROSS, DRILL THROUGH, SLICE AND DICE

WHAT ARE DRILL, DRILL DOWN, DRILL UP, DRILL BY, DRILL ACROSS, DRILL THROUGH, SLICE AND DICE


DRILL UP
SECOND->MINUTES->HOUR->->DAY
Month:-Quarter:-Year i.e. One level up in the Hierarchy
Data analysis to a parent attribute.
i.e. vertical movements between components up the hierarchy.
DRILL DOWN
REGION->COUNTRY->STATE->DISTRICT
YEAR:-QUARTER:-MONTH
i.e. One level vertical movements between components down the in the Hierarchy. Data analysis to a child attribute.
DRILL BY
Direct selection of level in the Hierarchy, means you can select one
DRILL TROUGH
Data analysis that goes from an OLAP cube into the relational database. To drill data from one Hierarchy to another Hierarchy, whatever u want that element, means you can drill through to the database directly from drill mode and get the required data.
i.e. you move horizontally between two items via a related link.
SLICE AND DICE
Changing the position of the data like move the data from rows to columns.
 DRILL ACROSS
Data analysis across dimensions.

SOME IMPORTANT POINTS TO REMEMBER:
Drill through is a term used to describe the act of exploring or browsing items like folders, files or related components. Generally associated with drill down and drill up, which indicate vertical movements between components, drill through is an action in which you move horizontally between two items via a related link.

Drill-down is a user navigation step intended to get further detailed information.
For example, you can drill-down to detail report through free Characteristic

An example to drill through is in the case of two reports that are in a master /detail relation with each other, and by clicking a master item on the master report you reach the details of the clicked item on the details report.

To slice and dice is to break a body of information down into smaller parts or to examine it from different viewpoints so that you can understand it better.

In cooking, you can slice a vegetable or other food or you can dice it (which means to break it down into small cubes). One approach to dicing is to first slice and then cut the slices up into dices. In data analysis, the term generally implies a systematic reduction of a body of data into smaller parts or views that will yield more information. The term is also used to mean the presentation of information in a variety of different and useful ways.

This term can be compared to drilldown , which is the process of dividing an information area up into finer and finer layers in a hierarchy, but with the purpose of narrowing in to one small area or item.

Multidimensional analysis tools organize the data in two
primary ways: in multiple dimensions and in hierarchies.

Slicing and dicing refers to the ability to combine and re-combine the dimensions to see different slices of the information. Picture slicing a three-dimensional cube of information, in order to see what values are contained in the middle layer. Slicing and dicing a cube allows an end-user to do the same thing with multiple dimensions.

slice and dice is to arrange the data in different ways. it can change as rows to columns  and columns to rows.

How many types of ABAP Programs are there?

Nine types of ABAP Programs
There are nine types of ABAP Programs in SAP:
1.                   1 Executable Programs (ABAP Reports)
2.                   I INCLUDE Program
3.                   M Module Pool/Dialogue programs
4.                   S Sub-Routine Pool
5.                   J Interface Pool
6.                   K Class Pool
7.                   T Type Pool
8.                   F Function Group
9.                   X XSLT Program



What are the different Routines available in BW

Routines available in BW:

1. InfoObject Transfer Routine
2. start Routine at TR level
3. Transfer Routine at TR level
4. Inverse Routines
5. Start Routine at UR level
6. Update Routine at UR level
7. Creating routine in the scheduler if the SS is FFSS
8. Routines at the time of creating OHS-InfoSpokes


Do you know about these TYPES in SAP BI BW?

Do you know about these TYPES in SAP BI BW? Very Important:

What are the types of DataSources, TransferRules, InfoSources, InfoObjects, Transfer Methods, types of Updates?

There are :


2 Types of InfoSources ( Direct Update & Flexible Update)
3 Types of Transfer Rules
3 Update Methods for InfoPackage
3 Update Methods in Logistics Extraction
3 Types of Updates( Full, Init, Delta)
3 Types of KF Updates ( source KF, DirectMapping, Formula, Routine)
4 Different types of DataSources : A,T,H,TD
5 Different types of Source Systems?
5 Update modes
5 Types of InfoObjects
6 Control Parameters for Transferring Data
6 Types of connections between the Source Systems and the BW
6 Types of Record Mode
8 Delta Terms

WHAT ARE V3 UPDATES ADVANTAGES AND DISADVANTAGES:

 WHAT ARE V3 UPDATES ADVANTAGES AND DISADVANTAGES:
V3 - batch asynchronous update:
• v3 is defined as un-serialized is collective update / synchronous with background schedule or batch synchronous update, uses delta queue technology and the nature of update is never automatic, which runs in background uses report rsm13005.
• the process can be done at any time after v1, v2 updates. I.e. V3 uses v1 or v2 +v3 update, reads data from documents & uses delta queue collective run call and writes to application tables.
• v3 can be scheduled at any time, with a mandatory step of locking users to prevent simultaneous updates.

Deep Analysis: Unserialized v3 update

Data extracted from application tables is written to update tables using un-serialized v3 update mode. By using collective update the so extracted data is processed. The important point to consider here is that the data is read without a sequence from update tables and are transferred to BW delta queue. Un serialized update, which is run after v1 & v2 doesn’t guarantee serialization of the document data posted to delta queue. This method is not suggestible as the entries in the delta queue are not equal to the updates that made to application. This method v3 results erroneous data, when data from DataSource is updated to DSO in overwrite mode, so the previous data is over written by the last update. But this v3 is suggestible when updating data to o d s or InfoCube. V3 runs and process the data after v2 with which the data is processed.

Advantages
Suitability : suitable for customers with high amount of documents
Serialization by document : no serialization as it’s a statistical update, which is run after v1 & v2 but the un serialized v3 doesn’t guarantee serialization of the document data.
Extraction : collective
Down time : not efficient
Implementation : less

Disadvantages

Suitability : not suggested if documents subjected to large changes with tracking changes

DATASOURCES FOR BW FI MM SD

DATASOURCES FOR BW FI MM SD

FI DATASOURCES Tables

COST CENTER ACCOUNTING 
0CO_OM_CCA_1 COSP, COSS
0CO_OM_CCA_2 COSP, COSS
0CO_OM_CCA_3 COSL, COKL.
0CO_OM_CCA_4 COSR
0CO_OM_CCA_5 COSB
0CO_OM_CCA_6 COOMCO
0CO_OM_CCA_7 BPJA, BPPE.
0CO_OM_CCA_8 COST, TKA07,COOMCO, CSLA, COST, COKL.

PRODUCT COST CONTROLLING DATASOURCE TABLES
0CO_PC_PCP_01 KEKO, TCKH3, TCKH8.
0CO_PC_PCP_02 KEKO, TCKH3.
0CO_PC_PCP_03 CKIS, T001K, TKA02, KEKO, MARA, MBEW.
0CO_PC_PCP_04 CKIS, T001K, TKA02, KEKO, MBEW, MARA
0CO_PC_01 AUFK, AFPO, COSS, COSP, COSB, COSL, COKEY, TKA09, TKV09
0CO_PC_02 AUFK, AFPO, COSS, COSP, COSB, COSL, COKEY, TKA09, TKV09

MM DataSource Tables
Goods Movements: 2LIS_03_BF
Stock Revaluations: 2LIS_03_UM

PURCHASING DATASOURCE TABLES
2LIS_02_SCL EKKO, EKBE, T001, T001W, EKET, EKPA.
2LIS_02_HDR EKKO, EKBE, T001, EKPA.
2LIS_02_ITM EKKO, EKBE, T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T147K, T147
2LIS_02_SCN EKET, EKES, EKPO.
2LIS_02_CGR EKBE, EKES, EKPO.
2LIS_02_SGR EKET, EKBE, KKPO

INVENTORY DATASOURCE TABLES
2LIS_03_BX stock tables, MCHA, MARA, T001, T001W, CALCULATED FROM MBEW, EBEW, QBEW.
2LIS_03_BF MSEG, MBEW, MKPF.
2LIS_03_UM BKPF, MBEW, QBEW, EBEW, BSEG.

MM   PURCHASING   DATASOURCES
ODS  
0PUR_O01  2LIS_02_ITM, 2LIS_02_SGR, 2LIS_02_CGR, 2LIS_02_SCN.
0PUR_O02  2LIS_02_HDR, 0PUR_O01
0PUR_DS03  2LIS_02_SCL and 2LIS_02_SGR.
CUBE  
0PUR_C10  2LIS_02_SCL and 2LIS_02_SGR.
0PUR_C07  
0PUR_C08  
0PUR_C09  0PUR_O02, 80PUR_O01, 2LIS_02_HDR
0SRV_C01  2LIS_02_S174
0PUR_C04  2LIS_02_S011, 2LIS_02_SCL, 2LIS_02_ITM, 2LIS_02_HDR
0PUR_C01  2LIS_02_S012, 2LIS_02_ITM, 2LIS_02_SCL
0PUR_C02  2LIS_02_S013
0PUR_C05  0MM_PUR_VE_01
0PUR_C06  0MM_PUR_VE_02
0PUR_C03  2LIS_02_S015

INVENTORY MANAGEMENT   DATASOURCE TABLES
CUBE  
0IC_C03  2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM
0IC_C02  2LIS_03_S195, 2LIS_03_S197
0IC_C01  2LIS_03_S196, 2LIS_03_S198

SD   DATA SOURCES TABLES
2LIS_11_VAKON VBUK, VBUP, VBAK, VBAP, VBKD, KOMV, T001.
2LIS_11_VAHDR VBAK, VBUK, T001
2LIS_11_VAITM VBAP, VBUP, VBAK, VBKD, VBAJP, T001, VBUK, PRPS.
2LIS_11_VASCL VBAP, VBUP, VBAK, VBEP, VBKD, T001, PRPS
2LIS_11_VASTH VBUK
2LIS_11_VASTI VBUP, VBUK
2LIS_11_V_ITM VBAP, VBAK, VBKD, VBUP, T001, PRPS, VBUK.
2LIS_11_V_SCL VBUP, VBEP, VBKD, VBAP, VBAK, T001, PRPS.
2LIS_11_V_SSL VBAP, VBEP, LIPS, WVBEP, VBUP
2LIS_13_VDKON VBUK, VBRP, KOMV, T001, VBRK.
0CO_OM_CCA_9 COVP (COEP& COBK), COSP, COST, COEJ, COEP, T001.
0CO_OM_CCA_10 COOI, COSP_VTYPE.


SAP TABLES

SAP TABLES:
GENERAL LEDGER (G/L) ACCOUNTS
GENERAL LEDGER (G/L) ACCOUNTS
SKA1 / T
G/L ACCOUNTS (CHART OF ACCOUNTS)
SKAS
CHART OF ACCOUNTS: KEY WORD LIST
SKB1
G/L ACCOUNTS (COMPANY CODE)
SKM1 / T
SAMPLE G/L ACCOUNTS
SKPF
INVENTORY SAMPLING


SAP-FI: ACCOUNTING DOCUMENTS (POSTINGS)
SAP-FI: ACCOUNTING DOCUMENTS (POSTINGS)
BKPF
ACCOUNTING DOCUMENTS
BSEG
DOCUMENT LINE
ACCOUNTING: SECONDARY INDEX CUSTOMERS
BSIK
ACCOUNTING: SECONDARY INDEX VENDORS
BSIP
VENDOR VALIDATION OF DOUBLE DOC.
BSIS
ACCOUNTING: SECONDARY INDEX FOR G/L
BSAD
CUSTOMERS (CLEARED ITEMS)
BSAK
VENDORS (CLEARED ITEMS)
BSAS
G/L ACCOUNTS (CLEARED ITEMS)
BSET
TAX DATA DOCUMENT LINE
BSEC
ONE-TIME ACCOUNT DOC. LINE / CPD
VBKPF
HEADER FOR DOCUMENT PARKING
F111G
SETTINGS PAYMENT REQUESTS
AGKO
CLEARED ACCOUNTS
GLT0
G/L ACCOUNT TRANSACTION FIGURES
REGUH
SETTLEMENT DATA PAYMENT PROGRAM
REGUP
PROCESSED ITEMS PAYMENT PROGRAM
REGUT
TEMSE - ADMINISTRATION DATA



SAP-CO: CONTROLLING / COST CENTER
SAP-CO: CONTROLLING / COST CENTER
CSKA
COST ELEMENTS (CHART OF ACCOUNTS)
CSKB
COST ELEMENTS (CONTROLLING AREA)
CSKU
COST ELEMENT TEXTS
CSLA/T
ACTIVITY MASTER
CSKS/T
COST CENTER: MASTER
CSSK
COST CENTER: COST ELEMENT
CSSL
COST CENTER: ACTIVITY
COSP
CO OBJECT: COST TOTALS FOR EXTERNAL POSTINGS
COEP
CO OBJECT: LINE ITEMS (BY PERIOD)
COBK
CO OBJECT: DOCUMENT HEADER
COST
CO OBJECT: PRICE TOTALS
TKA01/2
CONTROLLING AREAS / ASSIGNMENT
KEKO
PRODUCT COSTING - HEADER DATA
KEPH
COST COMPONENTS FOR COST OF GOODS MFD
KALO
COSTING RUN: COSTING OBJECTS (KVMK)
KANZ
SALES ORDER ITEMS - COSTING OBJECTS
CEPC-T
PROFIT CENTER MASTER DATA TABLE
CKPH-T
MASTER RECORD: COST OBJECT ID NUMBER

ORDERS (COST ACCOUNTING)
ORDERS (COST ACCOUNTING)
AUFK
ORDER MASTER DATA
AFKO
ORDER HEADER DATA PP ORDERS
AFPO
ORDER ITEM


CUSTOMER / CREDITOR
CUSTOMER / CREDITOR
KNA1
CUSTOMER MASTER
KNAS
VAT REGISTRATION NUMBERS
KNB1/5
COMPANY CODE / DUNNING DATA
KNB4
CUSTOMER PAYMENT HISTORY
KNBK
BANK DETAILS
KNC1/3
TRANSACTION POSTING FIGURES / SPECIAL G/L


VENDOR / DEBTOR
VENDOR / DEBTOR
LFA1
VENDOR MASTER
LFAS
VAT REGISTRATION NUMBERS
LFB1/5
COMPANY CODE / DUNNING DATA
LFBK
BANK DETAILS
LFC1/3
TRANSACTION FIGURES / SPECIAL G/L
LFM1
RECORD PURCHASING ORGANIZATION
T078K
TRANSACT.-DEPEND. SCREEN SELECTION
















SAP-CO: CONTROLLING / COST CENTER

SAP-CO: CONTROLLING / COST CENTER
CSKA
COST ELEMENTS (CHART OF ACCOUNTS)
CSKB
COST ELEMENTS (CONTROLLING AREA)
CSKU
COST ELEMENT TEXTS
CSLA/T
ACTIVITY MASTER
CSKS/T
COST CENTER: MASTER
CSSK
COST CENTER: COST ELEMENT
CSSL
COST CENTER: ACTIVITY
COSP
CO OBJECT: COST TOTALS FOR EXTERNAL POSTINGS
COEP
CO OBJECT: LINE ITEMS (BY PERIOD)
COBK
CO OBJECT: DOCUMENT HEADER
COST
CO OBJECT: PRICE TOTALS
TKA01/2
CONTROLLING AREAS / ASSIGNMENT
KEKO
PRODUCT COSTING - HEADER DATA
KEPH
COST COMPONENTS FOR COST OF GOODS MFD
KALO
COSTING RUN: COSTING OBJECTS (KVMK)
KANZ
SALES ORDER ITEMS - COSTING OBJECTS
CEPC-T
PROFIT CENTER MASTER DATA TABLE
CKPH-T
MASTER RECORD: COST OBJECT ID NUMBER


There was an error in this gadget