<p>This module contains functions to display <span class="caps">OLAP</span> cubes using <span class="caps">HTML</span> tables. Before you can use these methods, make sure that the module is included as helper module so the methods are available in your views:<br /> <pre><br /> class MyOlapController &lt; ActionController::Base<br /> helper ActiveRecord::Olap::TableHelper<br /> &#8230;<br /> end<br /> </pre></p> <h2><code>active_olap_table(cube, options = {}, html_options = {})</code></h2> <p>Displays the complete cube in a <span class="caps">HTML</span> table, using a row for every dimension category combination possible. This method works for cubes with as many dimensions as you like, and it supports multiple aggregate functions, whose results will be displayed in cells next to each other.</p> <h3>Parameters</h3> <ul> <li><strong><code>cube</code></strong>: The ActiveRecord::Olap::Cube instance that was returns by a call to <code>olap_query</code>.</li> <li><strong><code>options</code></strong>: A hash that can be used to control the structure of the resulting table. Currently, no options are supported, so this is reserved for future use.</li> <li><strong><code>html_options</code></strong>: A hash with attributes that will be added to the table-tag.</li> </ul> <h2><code>active_olap_matrix(cube, options = {}, html_options = {})</code></h2> <p>Displays a two dimensional cube as a table, using the categories of the first dimensions as rows and the categories of the second dimension as columns. Currently, this function only works when only a single aggregate function is used.</p> <h3>Parameters</h3> <ul> <li><strong><code>cube</code></strong>: The ActiveRecord::Olap::Cube instance that was returns by a call to <code>olap_query</code>. Note that this function will raise an exception if the cube does not have exactly two dimensions.</li> <li><strong><code>options</code></strong>: A hash that can be used to control the structure of the resulting table. Currently, no options are supported, so this is reserved for future use.</li> <li><strong><code>html_options</code></strong>: A hash with attributes that will be added to the table-tag.</li> </ul> 2008-08-05T09:15:13-07:00 42685 activerecord-olap-tablehelper 37573 2008-08-05T09:20:49-07:00 15870