• Domain: Manufacturing
  • Technologies Used: WebFOCUS, Javascripts
Back to Case Studies

Aged Account Receivable report

  • Project was from accounting department which gives better insights of pending bills of the customers.
  • Project involved 3 views of the report – Summary, Monthly and Detail.

Challenge:

  • Dynamic handling of columns and aggregation in the report based on view selected.
  • Analyzing report data and complex joins since data for the reports were coming from 10 different tables.
  • User had and option to select up to 5 subtotals at a time and some special requirements for subtotals were also there based on specific selection.

Solution:

  • Created Single synonyms using synonym editor in webFOCUS including all tables and handling joins at webFOCUS synonym level.
  • Launch page development was done after learning java script and getting inputs from tech support forums for java script.
  • Handling of columns and specific subtotals were done by using dynamic parameters in the report.
  • Created the report codes by dividing the codes into modules for ex- separate files for default parameters, drill parameters, sorting logic and main report files. This approach was useful in debugging and understanding the codes.
Back to Case Studies

© 2014 G N Solutions Pvt. Ltd. All Rights reserved.