Business Intelligence (BI) - ERP - Dashboards

Front End Development of Reports

In this phase of DW project if the reports are not bringing any value to the end user or executive, then the efforts to build the OLAP cube is wasted. so its very important to think about the end reports and timely delivery of reports to the end user. It is the trend to have reports seen through a standard web browser like Internet explorer or Mozzila firefox. It is not a good idea to install a report viewing software on each and every machine of the end user.

For Rapid prototyping there is an efficient tool for creating a report called Infocaptor (www.infocaptor.com) .It is very simple and easy to create reports with its powerful ability to create Dashboards, reports with Drilling ability. The reports can also be printed after saving to PDF format. The report’s output can also be saved in PDF or HTML and hence finally easily transferred to the end users.

The other front-end options ranges from an internal front-end development using scripting languages such as JSP,ASP, PHP, or Perl, to off-the-shelf products such as Discoverer (from Oracle),Seagate Crystal Reports, to the more higher-level products such as Actuate.The best in this category is once again my favorite Infocaptor ( www.infocaptor.com).The usual time to create Reports is arround 4 weeks.
The documents delivered to the client should state the Deployment of reports on their server.”Front end Deployment documentation”

Next >> Performance Tuning

Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), Oracle Apps, Reports

Free Dashboards