Scope: After discussing the issues of Tower Asset Audit in telecom industry in India, in partnership with Westrix, a telecom TSP, we came up with a product to handle Asset management, Audits, Energy audits with ingrained reports and dashboards on Key business metrics. This product has been developed in using a latest Java framework.

Product consists of 3 different layers (tiers).

1. Presentation Layer

2. Business Layer

3. Data Access Layer

In this application the presentation layer, business layer and data access layer are physically located on the same J2EE server. The different layers of the application are isolated from each other and connected through well defined interfaces.

JSF, Icefaces and Facelets are used to build the presentation layer of the application. JFS allows us to create rich GUI for web application. It resolves the technical challenges of creating rich GUI web application. In this layer we have jsp pages and Icefaces components integrated into Facelet containers. All the request to the web server are passes through faces servlet.

The POJO classes and classes to process the business logic are used to create the Business Layer. The POJO classes with the help of spring framework create an ideal solution to implement the Business Layer.

The data access layer handles all the logic to save and retrieve the data from data base. Hibernate O/R mapping tools is an ideal solution for enterprise application of any size. Hibernate handles all the logic to store and retrieve POJO objects. It also handles resource management and transaction management activities.

The product will have a capability to generate pre-built reports on the basis of solution bought by customer under SAAS model. We will integrate Jasper Soft Reports as pre-built reports into the system or for large customers we plan to integrate Business Objects Platform/Crystal reports solutions. The dash boarding layer will be created for each customer on the basis of solution chosen by them. For dash boarding either Xcelsius will be used or a Flex based dash board will be developed by our team. Depending upon the budget and solution being purchased by individual customer.

Multi Colour Column Chart component lets you configure the colour of each bar/column based on color values stored in the database/excel sheet. This allows the colour of a specific data item to remain constant when the results change in the query result. In an Xcelsius standard PIE chart, the colour configuration is based on specific rows in the excel sheet. The user can only configure the colour for a specific row (red for 1st row, green for 2nd row). This limits the user to associate a particular colour to a particular data value in the data store. For e.g. The data values in the excel sheet for a specific period are ‘Apple’, ‘Orange’, ’Lemon’ and the respective colour codes assigned are ‘red’, ’orange’, ’yellow’ (based on the respective excel rows) and over a period new values like ‘papaya’, ’grapes’, ’guava’ get filled in the same rows(based on data set from the data store), the same colour code ‘red’, ’orange’, ’yellow’ will be displayed instead of the desired values ‘papaya green’, ’purple’, ’green’. With this component, user will be able to map the colour with a specific data value. For eg:, the user can add an additional column in the dimensional table to represent the colour code and hence the colour can be based on the actual values itself rather than on specific excel rows. Hence in the above example, ‘red’ will be consistently displayed for ‘Apple’, ‘Orange’ for ‘Orange’.  More...

 

This component lets you export data out of your Xcelsius dashboards into an Excel Sheet. It goes one step forward in providing export facility from multiple ranges within an excel worksheet. The .xlx component is packaged along with a jsp file which should be hosted on a Java supported web application server. The jsp file needs a temporary location with ‘Write’ permissions/rights for it to create temporary files.

 

• No need to use multiple components to achieve the ‘Export to Excel’ functionality - XML Data Connection, URL Button, etc. The ‘Export To Excel’ component contains all the necessary properties required to export data to an Excel Format. The steps involved:

1. Use the ExportToExcel.xlx component within Xcelsius. Set all necessary properties.
2. Host the Export_Excel.jsp file in a Java supported web application server

• Allows export of multiple data ranges
• As the package is based on a mix of Xcelsius and Java technology , the ‘Export As Excel’ feature can be experienced on all platforms without being tied down only to a Windows based platform (.aspx hosted on IIS). More...