Jasper BI & Data Warehouse

Introduction To leverage this capability to the greatest extent, it is important to get familiar with configurability of this feature. This tutorial covers some of the most commonly used configuration parameters associated with the scheduling feature. Pre-Requisites Access to the file system of and the ability to stop and start an operational installation of JasperReports Server Access to a running outbound mail server. Setting Up the Connection to your Outbound Email Server In order for the scheduler to successfully send email notifications and distribute reports, it must be configured to connect to an outbound email server. Step Action 1 Open the following configuration file in your preferred text editor:  /WEB-INF/js.quartz.properties 2 Set the value for the  mail.sender.host  property to your outbound mail server. Example :  report.scheduler.mail.sender.host=outbound.yourdomain.com ...

Introduction Testing is very important for data warehouse systems to make them work correctly and efficiently. There are three basic level of testing that are listed below:   Unit Testing   Integration Testing System testing UNIT TESTING In the Unit Testing each component is separately tested. In this kind of testing each module i.e. procedure, program, SQL Script, Unix shell is tested. This tested is performed by the developer. INTEGRATION TESTING   In this kind of testing the various modules of the application are brought together and then tested against number of inputs. It is performed to test whether the various components do well after integration. SYSTEM TESTING I n this kind of testing the whole data warehouse application is tested together. The purpose of this testing is to check whether the entire system work correctly together or not. This testing is performed by the testing team. Since the size of the whole data wareho...

Introduction The data warehouse evolves throughout the period of time and the it is unpredictable that what query the user is going to be produced in future. Therefore it becomes more difficult to tune data warehouse system. In this chapter we will discuss about how to tune the different aspects of data warehouse such as performance, data load, queries ect. Difficulties in Data Warehouse Tuning Here is the list of difficulties that can occur while tuning the data warehouse. ·         The data warehouse never remain constant throughout the period of time. ·         It is very difficult to predict that what query the user is going to produce in future. ·         The need of the business also changes with time. ·         The users and their profile never remains the same with time. ·         The use...