]po[ Data Warehouse Light

Data Warehouse "Light" is a reporting tool implemented using Microsoft Excel and its "Pivot Table" functionality.  There are no sacrifices in functional operability, the "light" only refers to the limit on the data size,  which  can handle up 65,000 records, due to the limitations of Microsoft Excel.  Data stored within the ]project-database[ is exported and then formatted to be read by Microsoft Excel, allowing companies to view and study their financial records stored within ]project-open[ using a third party software, Excel.  This package is closed source and currently only available through its commercial purchase at the Project-Open Store .  

 

 

References

Maturity

  • Active and Stable

Related Tutorials

Related Object Types 

  • [Report]

Related Packages

Related Modules

 

 

Package Documentation 

Procedure Files

tcl/intranet-dw-light-procs.tcl       Data Warehouse Light 

Procedures

im_companies_csv       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_companies_csv1       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_dw_light_handler       This procedure gets called for all page requests in /intranet-dw-light . 
im_invoices_csv       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_invoices_csv1       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_projects_csv       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_projects_csv1       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_timesheet_csv       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_timesheet_csv1       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_users_csv1       Returns a "broad" CSV file particularly designed to be Pivot-Table friendly. 
im_vacation_csv       Returns a CSV file for vacation data 

SQL Files

sql/common/companies-export.sql        
sql/common/invoices-export.sql        
sql/common/projects-export.sql        
sql/common/timesheet-export.sql        
sql/common/users-export.sql        
sql/postgresql/intranet-dw-light-create.sql        
sql/postgresql/intranet-dw-light-drop.sql        

Content Pages

www/
      index.tcl Show the list of current task and allow the project manager to create new tasks.
 
  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com