View | Details | Raw Unified | Return to bug 20358
Collapse All | Expand All

(-)src/documentation/content/xdocs/casestudies.xml (+29 lines)
Lines 88-93 Link Here
88
          clinical data.  - Jared Walker (jared.walker at clickfind.com)
88
          clinical data.  - Jared Walker (jared.walker at clickfind.com)
89
        </p>
89
        </p>
90
      </section>
90
      </section>
91
     <section><title>Sunshine Systems</title>
92
        <p>
93
          <link href="http://www.sunshinesys.com">Sunshine Systems</link> developed a 
94
           POI based reporting solution for a price optimization software package which 
95
           is used by major retail chains.
96
        </p>
97
        <p>The solution allowed the retailer's merchandise planners and managers to request 
98
          markdown decision support reports and price change reports using a standard browser. 
99
          The users could specify report type, report options, as well as company, division, 
100
          and department filter criteria. Report generation took place in the multi-threaded 
101
          application server and was capable of supporting many simultaneous report requests.
102
        </p>
103
        <p>The reporting application collected business information from the price optimization 
104
          application's Oracle database. The data was aggregated and summarized based upon the 
105
          specific report type and filter criteria requested by the user. The final report was 
106
          rendered as a Microsoft Excel spreadsheet using the POI HSSF API and was stored on 
107
          the report database server for that specific user as a BLOB. Reports could be 
108
          seamlessly and easily viewed using the same browser.
109
        </p>
110
        <p>The retailers liked the solution because they had instantaneous access to critical 
111
          business data through an extremely easy to use browser interface. They did not need 
112
          to train the broader user community on all the complexities of the optimization 
113
          application. Furthermore, the reports were generated in an Excel spreadsheet format, 
114
          which everyone was familiar with and which also allowed further data analysis using 
115
          standard Excel features.
116
        </p>
117
        <p>Rob Stevenson (rstevenson at sunshinesys dot com)
118
        </p>
119
      </section>
91
    </section>
120
    </section>
92
  </body>
121
  </body>
93
  <footer>
122
  <footer>

Return to bug 20358