I want to know about DTP in bi 7.
Answers were Sorted based on User's Feedback
Answer / srinivasa reddy
DTP: data Transfer processing
simply says.. we r transfering data from PSA to data
tragets...or data targets to data targets.
| Is This Answer Correct ? | 44 Yes | 4 No |
Answer / guest
In BW 3.5 we had Infopackage to pull the data at all the
lavels, but now in BI 7.0 Infopackage pull the data only
till datasource/PSA from source thereafter we need to
create the transformation and DTP to pull the data.
So we can say that DTP is used to push the data from one
target to another data target.
Thanks
Mayank
| Is This Answer Correct ? | 32 Yes | 4 No |
Answer / k m r
Hi
DTP is nothging but but a data transfer process in BI 7.0
As most us aware that in BI 7.0 PSA is a mandatory optinon
this DTP process will take care about the data loadings
between PSA and Data target and also updates the data from
ODS to CUBE or CUBE to CUBE
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / wahiduzzaman mia
In BI 7.0 InfoPackage used to transfer data from source
system to data source/PSA and data transfer process(DTP) is
used to transfer data from data source/PSA to any data
target/Info provider.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / emmanuel
As most of the above answers point to the fact that
Infopackage-->PSA and PSA --> Data targets.
The key difference between 3.x and 7.x is that in 3.x an
infopackage would load from a single DS to multiple data
targets (infocubes, ODS etc) so if the source was sending
delta, then the load to targets has to be done as a single
data load to all.,meaning a delta has to get get loaded to
all targets at the same time...you could not load them at
different timings.
Whereas in 7.x, DTP helps in maintaining delta queues from
PSA to different targets...enabling you to load the delta
to each target, independent of the other because each
target will have its own delta Queue maintained. This is a
big change in 7.x and helps in load distribution mechanisms.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sadiq
DTP is new in BI 7,
In BW infopackage brings the data from Source Sytem to PSA
& InfoCube(Data Targer).
But from BI7 Infopackage brings data upto PSA. first u need
to create transformation either from
PSA(Data Source)--InfoCube or
InfoCube to PSA(Data Source) when u create transformation
then u can see the field mapping between souce fields to
target fields. Also u have conversion rules etc...
Now u can create DTP two ways...
PSA(Data Source)--InfoCube or
InfoCube to PSA(Data Source)
In Dtp u have 3 sub tabs,
1. Extract Full, Delta (only Change or new data)
2. Update
3. Execute--- Execute button.
After Executing u can go to monitor...
Hope u understand...
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / anar samadzade
Prior to BI 7.0, infopackages were used to transfer data from source systems all the way up to data
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / pratyoosh gawade
basically DTP is used to trigger the loading process from
datasource/psa to data target.u can apply individual
mechanism through DTP to different data target like
weekly,monthly,yearly loading which is not possible through
update rule/BW 3.5
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / madhavapal
in bw infopackage directly transfers the data but in BI 7
infopackage will only bring data to PSA, Data
Transformation Processing will transfer the data from PSA to
the target. PSA is only staging area this will not be a
target(we cant do anything here)
| Is This Answer Correct ? | 11 Yes | 8 No |
Answer / vijay komatiganti
DTP Data Transfer Process, DTP is process to load data from
PSA to Data Target.
4 Types in SAP BI
a) Standard DTP
b) Direct DTP
c) Error Stack DTP
d) RDA DTP
| Is This Answer Correct ? | 5 Yes | 3 No |
How are dimensions optimized?
Can you create a data storage area in the sap bw?
What is Open Hub (OH)?
What are the follow-up actions available for reporting agent?
Extraction in mm and SD and FI? What is the requirement and name them?
What are nodes?
wt is difference between user group and reference user group?
Give some examples of queries delivered with BW statistics?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
What is the use of navigational attributes?
What is the propose from statistics for aggregates?
Please tell what are the tables we can use in FISL and COPA in real time.. Explain clearly?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)