📄 workbench.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><!-- == $Id: //open/mondrian-release/3.0/doc/workbench.html#2 $ == This software is subject to the terms of the Common Public License == Agreement, available at the following URL: == http://www.opensource.org/licenses/cpl.html. == Copyright (C) 2008 Pentaho == Copyright (C) 2007 JasperSoft == Copyright (C) 2007-2007 Julian Hyde and others == All Rights Reserved. == You must accept the terms of that agreement to use this software. --> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <title>Mondrian Schema Workbench</title></head><body><!-- doc2web start --><!-- page title --><div class="contentheading">Mondrian Schema Workbench</div><!-- end page title --><p>The Mondrian Schema Workbench is a designer interface that allows you to create and test Mondrian OLAP cube schemas visually.The Mondrian engine processes MDX requests with the ROLAP (Relational OLAP) schemas.These schema files are XML metadata models that are created in a specific structure used by the Mondrian engine.These XML models can be considered cube-like structures which utilize existing FACT and DIMENSION tables found in your RDBMS.It does not require that an actual physical cube is built or maintained; only that the metadata model is created.</p> <p><b><i>Note</i></b>: For documentation on publishing Mondrian Schemas to Pentaho's BI Platform, see <a href="http://wiki.pentaho.org/display/PentahoDoc/Publishing+an+Analysis+Schema+Using+Schema+Workbench">Publishing an Analysis Schema Using the Schema Workbench</a> <img src="images/workbench_schema_editor.png"><p>It provides the following functionality:</p><ul> <li>Schema editor integrated with the underlying data source for validation. (See above)</li> <li>Test MDX queries against schema and database <a href="images/workbench_mdx_query_runner.png">Screenshot</a></li> <li>Browse underlying databases structure <a href="images/workbench_jdbc_explorer.png">Screenshot</a></li></ul><p>A more detailed manual is <a href="schema_workbench.pdf">Schema Workbench Manual</a><p></p><h2>Using the Workbench</h2><p></p><table style="text-align: left; border-collapse: collapse;" border="1" cellpadding="10" cellspacing="0"> <tbody> <tr> <td style="vertical-align: top;"> <p>To build and create the workbench jar, at the command line, type:</p> <pre> ant workbench<br></pre> <p>Example output:</p>Buildfile: build.xml<br>Overriding previous definition of reference to jdk<br> <br>version:<br> <br>prepare:<br> <br>parser:<br> [javacup] Files are up to date.<br> <br>generate.resources:<br> [resgen] C:\MONDRIAN_SourceForge\open\mondrian\src\main\mondrian\resource\MondrianResource.java is up to date<br> [resgen] C:\MONDRIAN_SourceForge\open\mondrian\classes\mondrian\resource\MondrianResource.properties is up to date<br> [resgen] C:\MONDRIAN_SourceForge\open\mondrian\src\main\mondrian\resource\MondrianResource_en_US.java is up to date<br> [resgen]C:\MONDRIAN_SourceForge\open\mondrian\classes\mondrian\resource\MondrianResource_en_US.propertiesis up to date<br> [resgen] C:\MONDRIAN_SourceForge\open\mondrian\src\main\mondrian\resource\MondrianResource_de_DE.java is up to date<br> [resgen]C:\MONDRIAN_SourceForge\open\mondrian\classes\mondrian\resource\MondrianResource_de_DE.propertiesis up to date<br> [resgen] C:\MONDRIAN_SourceForge\open\mondrian\src\main\mondrian\resource\MondrianResource_de.java is up to date<br> [resgen]C:\MONDRIAN_SourceForge\open\mondrian\classes\mondrian\resource\MondrianResource_de.propertiesis up to date<br> [resgen] C:\MONDRIAN_SourceForge\open\mondrian\src\main\mondrian\resource\MondrianResource_es_ES.java is up to date<br> [resgen]C:\MONDRIAN_SourceForge\open\mondrian\classes\mondrian\resource\MondrianResource_es_ES.propertiesis up to date<br> <br>def:<br> <br>compile.java:<br> <br>compile:<br> <br>info:<br> [echo] ==============================================================<br> [echo] | Mondrian configurationinfo |<br> [echo] ==============================================================<br> [echo] project.location = C:\MONDRIAN_SourceForge\open\mondrian<br> [echo]jdk.home = C:\Program Files\Java\jdk1.5.0_05<br> [echo] catalina.home = C:\apache-tomcat-5.5.12<br> [echo] junit.home = C:\junit4.0<br> [echo] mondrian.foodmart.catalogURL = file:C:\MONDRIAN_SourceForge\open\mondrian/demo/FoodMart.xml<br> [echo] mondrian.foodmart.jdbcURL = jdbc:odbc:MondrianFoodMart<br> [echo]mondrian.jdbcDrivers =sun.jdbc.odbc.JdbcOdbcDriver<br> [echo] ==============================================================<br> <br>compile.tests:<br> <br>jar:<br> [jar] Building jar: C:\MONDRIAN_SourceForge\open\mondrian\lib\mondrian.jar<br> <br>workbench:<br> [jar] Building jar: C:\MONDRIAN_SourceForge\open\mondrian\lib\workbench.jar<br> <br>BUILD SUCCESSFUL<br>Total time: 47 seconds<br> <p>This will create <code>lib/workbench.jar</code>. Include drivers for your database on the classpath.</p> <p>To start the workbench., at the command prompt, type</p> <p>In Windows:</p> <blockquote> <pre>ant workbench-run<br></pre> <p>Or the following</p> <pre>java -jar lib/workbench.jar<br></pre> </blockquote> <p>In UNIX/Linux:</p> <blockquote> <pre>java -jar lib/workbench.jar </pre> </blockquote> </td> </tr> <tr> <td style="vertical-align: top;"> <p>Set properties for connection to your cube database via <code>Tools > Preferences</code>.</p> <blockquote> <p><img src="images/workbench_preferences.png"></p> </blockquote> <p>These preferences and the last 4 schemas edited are kept in a "workbench.properties" file in the root of the classpath.</p> <p>If you change the connection properties, you will need to close/save the existing schema editor(s) and restart to see the effects.</p> </td> </tr> <tr> <td style="vertical-align: top;"> <p>Create a new schema or open an existing one.</p> <p>If you open an existing schema, the Workbench validates that the tables and columns underlying the cube definitions actually exist in the database.</p> <blockquote> <img src="images/workbench_get_schema.png"> </blockquote> </td> </tr> <tr> <td style="vertical-align: top;"> <p>Create or edit elements in the schema. The Workbench validates your changes against the cube database tables and column names.</p> <blockquote> <img src="images/workbench_database_validation.png"> </blockquote> <p>The Workbench validates edits against the Mondrian schema DTD.</p> <blockquote> <img src="images/workbench_database_error.png"> </blockquote> </td> </tr> <tr> <td style="vertical-align: top;"> <p>Save your schema and run some MDX queries to test. Error messages and results are displayed.</p> <blockquote> <img src="images/workbench_mdx_query_runner.png"> </blockquote> </td> </tr> </tbody></table><p> </p><hr noshade="noshade" size="1"><p> Author: Sherman Wood, JasperSoft; last modified April 2007.<br> Version: $Id: //open/mondrian-release/3.0/doc/workbench.html#2 $ (<a href="http://p4web.eigenbase.org/open/mondrian/doc/workbench.html?ac=22">log</a>)<br> Copyright (C) 2008 Pentaho<br> Copyright (C) 2007 JasperSoft<br> Copyright (C) 2007-2007 Julian Hyde and others</p><br><!-- doc2web end --></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -