<div dir="ltr">Hi Julian,<div>Many thanks for your feedback!</div><div>(1) I think for new users it would be an advantage to have a XSD or DTD to easily lay out the OLAP schema by using a GUI (any popular XML editor supports some graphical helpers to easily create an XML doc). I am also talking about new users who are not familiar with Java. So having an XSD/DTD that they can easily reference in their XML editor would give them a good "guide" on how to structure the Mondrian schema. After working with XSD/DTD a few times, the user will get comfortable writing OLAP schema by hand.</div>
<div>(2) For seasoned users a XSD/DTD is still useful just as a quick validation. </div><div>(3) It might be a good idea to have a public reference to each version of the XSD/DTD. So instead of asking users to download the XSD/DTD, you can ask them to just do this:</div>
<div><!DOCTYPE Schema PUBLIC "<a href="http://ci.pentaho.com/view/Analysis/job/mondrian-4.0/lastSuccessfulBuild/artifact/lib/mondrian.dtd" target="_blank">http://ci.pentaho.com/view/Analysis/job/mondrian-4.0/lastSuccessfulBuild/artifact/lib/mondrian.dtd</a>" > </div>
<div>... I am not too sure if this a permanent location.</div><div><br></div><div>If you are wondering why I am talking about all this ... here is the link to the blog post I am currently working on:</div><div style>Mondrian 4 Blog Post</div>
<div style><a href="https://docs.google.com/document/d/18_A72AR61wN2pMm59LNDLwYWefJt9nplKsROYz5jrFY/edit">https://docs.google.com/document/d/18_A72AR61wN2pMm59LNDLwYWefJt9nplKsROYz5jrFY/edit</a></div>
<div style><br></div><div style>Please note that this tutorial is targeted at users not familiar with Java.</div><div>Any feedback is appreciated!</div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Wed, Jan 16, 2013 at 10:13 PM, Julian Hyde <span dir="ltr"><<a href="mailto:jhyde@pentaho.com" target="_blank">jhyde@pentaho.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div style="word-wrap:break-word"><div>See comments inline.</div>
<div><br></div><div><div><div><blockquote type="cite">
<div class="gmail_extra"><div class="gmail_quote">On Tue, Jan 15, 2013 at 1:05 PM, Diethard Steiner <span dir="ltr"><<a href="mailto:diethard.steiner@gmail.com" target="_blank">diethard.steiner@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div><div class="gmail_extra"><div class="gmail_quote">
So I have been creating an XML file based on the Mondrian 4 DTD you mentioned. <br><div dir="ltr">There seems to be a problem with the Measure element within Measures ... which turns out to be invalid based on this DTD. I am following the example from the Mondrian 4 book. Screenshots attached. Based on the DTD, there seems to be only MeasureOrRef valid within Measures.</div>
</div></div></div></div></blockquote></div></div></blockquote><div><br></div></div><div>Mondrian's schema definition uses something like super-types to define collections of allowable elements. "MeasureOrRef" is such a supertype. There is no actual XML element called "MeasureOrRef". The allowed children of Measures are Measure and MeasureRef. </div>
<div><br></div></div></div><div><div><blockquote type="cite"><div class="gmail_extra"><div class="gmail_quote"><div dir="ltr"><div>- It is not possible to define a degenerate dimension: The DTD is unaware of any column attribute for the attribute element (sample in Mondrian 4 book shows an attribute column)</div>
</div></div></div></blockquote><div><br></div></div><div>That was a typo in the book. It should read "keyColumn" and not "column", thus:</div><div>
<div title="Page 22">
<div style="background-color:rgb(238,238,255)">
<div>
<div>
<pre><span style="font-size:10pt;font-family:Courier"><Dimension name='Payment Type' table='sales_fact_1997'>
<Attributes>
</span></pre>
<pre><span style="font-size:10pt;font-family:Courier"> <Attribute name='Payment Type' keyColumn='payment_type'
approxRowCount='3'/>
</span></pre>
<pre><span style="font-size:10pt;font-family:Courier"> </Attributes>
</Dimension></span></pre></div></div></div></div></div><div><br><blockquote type="cite"><div class="gmail_extra"><div class="gmail_quote">- It is not possible to create a FactLink as a child of DimensionLinks<br>
</div></div></blockquote><div><br></div></div><div>This is a similar misunderstanding to MeasureOrRef. DimensionLinks allows children whose supertype is "DimensionLink". The elements that have that property are ForeignKeyLink, FactLink, ReferenceLink, NoLink, CopyLink.</div>
<div><br></div><div>Only ForeignKeyLink, FactLink, NoLink are described in ch 4 and 5 currently.</div><div><br></div><div>Thanks for the feedback... keep it coming!</div><div><br></div><div>For feedback related to the book, you can also post to Manning's forums (<a href="http://www.manning-sandbox.com/forum.jspa?forumID=823" target="_blank">http://www.manning-sandbox.com/forum.jspa?forumID=823</a>). Or this list. Whichever you prefer.</div>
<span><font color="#888888"><div><br></div><div>Julian</div><div><br></div></font></span></div></div><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div></div>