...
| Code Block |
|---|
<Host name="localhost" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<!-- some commented sections that are irrelevant -->
<Context path="/pentaho" docbase="webapps/pentaho/">
<Resource name="jdbc/foodmart" auth="Container" type="javax.sql.DataSource" maxActive="20"
maxIdle="5" maxWait="10000" username="foodmart" password="foodmart"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="com.mysql.jdbc.Driver"
url="jdbc://mysql://servername:3306/foodmart" />
<Resource ... />
...
<Resource ... />
</Context>
</Host>
|
MS Analysis Services link points to SQL Server 2000.
=
If you have problems with this stuff, check the forums other other wiki article, but suffice it to say, if you want to use the foodmart database to learn MDX, you'll want to get the above working before you go on.
Next, visit http://www.databasejournal.com/featu...le.php/1495511 this article. There are 63 different articles (at the time of this post) on writing MDX queries. Don't let the fact these articles are written for Microsoft's OLAP implementation scare you. Almost all the queries work fine in Mondrian -- in fact, if you look closely in the documentation on MDX, Julian (or whomever maintains that page) links to this set of articles as well. If there are any incompatibilities it typically takes a minor tweak to fix it. Just skip all the sections related to using their analysis tool(s), and copy or type up the queries yourself in jpivot, jrubik, or what-have-you.
...