<p>The <code>enable_active_olap</code> is used to activate your model for performing <span class="caps">OLAP</span> queries. It can just be included in your class, and you’re set to go!</p>
<pre>
class Project < ActiveRecord::Base
enable_active_olap
end
</pre>
<h2>Passing a block</h2>
<p>However, you may use this opportunity to define some dimensions and aggregates for this class by passing a block. These can later be used in your <span class="caps">OLAP</span> queries using the symbol that you used as name.</p>
<pre>
class Project < ActiveRecord::Base
enable_active_olap do |olap|
# register a dimension using this syntax
olap.dimension <:dimension_symbol>, <dimension_definition_hash>
# register an aggregate function using this syntax
olap.aggregate <:aggregate_name>, <aggregate_definition>
end
end
</pre>
<p>Note that you don’t have to define these dimension here, you can actually pass complete dimension definitions to <code>olap_query</code>. However, it usually is good practice to have all your definitions in one place. You could move them to a separate file if you wish. Moreover, you can use the short-hand names of these dimensions when calling <code>olap_query</code>.</p>
<ul>
<li>See the [[dimensions]] page to see how dimension definitions are constructed.</li>
<li>See [[aggregates]] to see how aggregates are defined and used.</li>
<li>See [[olap_query]] to see how queries are executed using dimensions and aggregates.</li>
</ul>
2008-07-31T13:33:08-07:00
41427
enable_active_olap
37573
enable_active_olap
2008-08-04T13:18:55-07:00
15870