Santosh Kumar who did the BIRT component implemented another nice sample. This time he uses the Symphony spreadsheet editor to display data from a Notes database graphically. The text below is from him. I demonstrated this sample in the keynote at DNUG two weeks ago and it was very well received.
With Lotus Productivity Editors and Symphony making OpenDocument Format (ODF) spreadsheets more pervasive in user and enterprise space, business users would like to view, drill into, manipulate and graph Notes data directly in Spreadsheets. These spreadsheets not only offers familiarity to end users, but also offers basic data analysis, manipulation and visualization features.
This composite application demonstrates how Lotus productivity Spreadsheets can be more integral component as composite application to display tabular and graphical information from Domino databases. The application enables to access Notes data from selected documents or view categories in Spreadsheet. The application build with productivity editors api's enables spreadsheet formatting with ability visualize Notes data in bar graph, line graphs, or pie charts. The application provides ability to drill down and open notes document related to tabular data.
This sample application also demonstrates how spreadsheets can be integrated with Lotus Sametime. It provides presence awareness for live names directly in spreadsheet with ability to chat and communicate without leaving the context.
The screenshot above shows data from view category "Kraja Systems" from Sales Lead application is displayed in tabular format in spreadsheet and pie chart is created for total revenue
for each type of lead. Users can also drill down to notes document directly from the spreadsheet by clicking on hyperlink.
Its also possible to display data from selected documents. The below screenshot display data from selected documents and creates bar chart for revenue for type of car against each year.
Also presence awareness has been enabled for names( in this case location manager). Within spreadsheet, one can chat with respective person to track status or get more information.
This prototype has been built with existing productivity editors and Universal Network Objects ( UNO ) API to visualize data in spreadsheet and leveraging composite application infrastructure to enable as composite component. This showcases how in built productivity editors in Notes 8 can be made more integral to composite applications.