In this project, MS-Access is used as the database for creating and modifying tables. SAP (Systems, Applications and Products in Data Processing) Business Objects (BO) is used to create universe (views) by joining the tables using SQL. New fields or newly calculated variables can also be created in BO. SAP Query as Web Source is used to connect SAP-BO and an Xcelsius tool (also called SAP dashboard tool) generates a web link and is used in SAP Dashboard for mapping. The SAP dashboard software tool helps in designing the dashboard and a desired layout with selected fields can be produced as output. Thus data is transformed into graphical representations. Graphs are linked to tabs for tab level reporting. So when the user clicks on a particular tab, the related graphs are displayed on the dashboard. The user can take decisions either by using what-if analysis, drill-down graphs or by modifying the database. Hence the name Real-time and Interactive analysis of Database query reports (RID). The views are formed only once but the database can be changed and the corresponding updated reports can be viewed any number of times. Thus the SAP dashboard design helps in creating stunning visualizations and interactive dashboards from the Microsoft Access database. The graphs provide optimal decision making and excellent ERP (Enterprise Resource Planning).The user can take decisions either by using what-if analysis, drill-down graphs or by modifying the database. Hence the name Real-time and Interactive analysis of Database query reports (RID).
|Title||:||Real Time and Interactive Analysis of Database Query Reports|