2010 Jan 14 9:45 AM
Hi Experts,
Please share me details of
Advantages of ABAP reporting compared to SAP-BI and
Disadvantages of ABAP reports
Regards,
Marasa.
2010 Jan 14 10:25 AM
Topic/Function OLTP Data Warehouse (OLAP)
Data Content Current valued Historical, Summarized data
Data Organization Application by application Subject areas across enterprise
Nature of Data Dynamic, continual updates Static until scheduled refresh
Data Structure Structured for fast efficient read/write activity on a record by record basis Structured for efficient read-only access to large volumes of data
Access Type High volumes of single-record inserts, updates, queries High volumes of records accessed in complex queries
Queries and Indexing Optimized for fast direct access to individual records Optimized for fast access to a large range of records with multi-table joins to associated detail and descriptions
Level of Data Detail Records accessed and updated at most detailed, atomic level Varying query and analysis needs may require both atomic detail and high-level summaries
Usage Highly structured, repetitive processing Highly unstructured, analytical processing
Response Time Sub-second to 2-3 seconds Several seconds to minutes
Data Timeliness Current State of the Business Prior Day to Historic
2010 Jan 14 10:25 AM
Topic/Function OLTP Data Warehouse (OLAP)
Data Content Current valued Historical, Summarized data
Data Organization Application by application Subject areas across enterprise
Nature of Data Dynamic, continual updates Static until scheduled refresh
Data Structure Structured for fast efficient read/write activity on a record by record basis Structured for efficient read-only access to large volumes of data
Access Type High volumes of single-record inserts, updates, queries High volumes of records accessed in complex queries
Queries and Indexing Optimized for fast direct access to individual records Optimized for fast access to a large range of records with multi-table joins to associated detail and descriptions
Level of Data Detail Records accessed and updated at most detailed, atomic level Varying query and analysis needs may require both atomic detail and high-level summaries
Usage Highly structured, repetitive processing Highly unstructured, analytical processing
Response Time Sub-second to 2-3 seconds Several seconds to minutes
Data Timeliness Current State of the Business Prior Day to Historic
2010 Jan 14 11:02 AM
Hi Ravi,
Do you know this person Marasa Naido? Possibly an uncle of yours?
Cheers,
Julius
2010 Jan 14 10:32 AM
I have no doubt if the answer of your question may not differ from every mouth .from Out of three Every second person would have their different opinions. So best approach would be search yourself and fetch information from Google as much as you can. After fetching the information then once you conclude any assessment(ABAP vs BI) , I doubt if you would not be confused yourself .
You are tempting to compare orange with the apples.
Cheers
2010 Jan 14 10:52 AM