InterviewSolution
| 1. |
What Is Ad Hoc Analysis? |
|
Answer» In traditional data warehouses, such as SAP BW, a lot of pre-aggregation is DONE for quick RESULTS. That is the administrator (IT department) decides which information might be needed for ANALYSIS and prepares the result for the END users. This results in fast performance but the end user does not have flexibility. The performance REDUCES dramatically if the user wants to do analysis on some data that is not already pre-aggregated. With SAP HANA and its speedy engine, no pre-aggregation is required. The user can perform any kind of operations in their reports and does not have to wait hours to get the data ready for analysis. In traditional data warehouses, such as SAP BW, a lot of pre-aggregation is done for quick results. That is the administrator (IT department) decides which information might be needed for analysis and prepares the result for the end users. This results in fast performance but the end user does not have flexibility. The performance reduces dramatically if the user wants to do analysis on some data that is not already pre-aggregated. With SAP HANA and its speedy engine, no pre-aggregation is required. The user can perform any kind of operations in their reports and does not have to wait hours to get the data ready for analysis. |
|