From: Sherman W. <sw...@lu...> - 2005-07-17 05:28:39
|
Can the references on the Web about aggregate tables and materialized views be included as links? It would be good to show a relationship between the MDX and the generated SQL. Maybe with and without aggregates? For Agg_2, it is still a snowflake. Maybe include the definition of the complete cube so folks can see it? The AggGen details in the 'Command runner' and 'Aggregate tables' pages are duplicated. Have them in one place? In links to AggGen, do a positional link on the Command runner page ie http://mondrian.sourceforge.net/cmdrunner.html#AggGen Sherman Wood 415 516-4894 -----Original Message----- From: mon...@li... [mailto:mon...@li...] On Behalf Of Julian Hyde Sent: Saturday, July 16, 2005 8:52 PM To: mon...@li... Subject: [Mondrian-devel] Feedback on aggregate tables documentation? Hi all, I've reorganized and extended the documentation for aggregate tables which Richard wrote. This is going to be a key feature in 1.2, and I'd appreciate it if someone could proof-read and make constructive suggestions. Under http://mondrian.sourceforge.net/, see "Aggregate tables". In the "Aggregate tables" document I've added some diagrams, to explain visually concepts like "lost" and "collapsed" dimensions. I decided to depart from the FoodMart schema for these diagrams, for a couple of reasons. To make the names simple enough to fit on the diagram, and to illustrate what happens when I was struggling for a word to describe what happens to the "product" dimension in agg_2. The dimension is not collapsed into the aggregate table; all that is retained is a foreign key to the original dimension table. But I wouldn't call this a "shrunken" dimension, because the original dimension is being used. I am also debating how much content to put into the schema guide. My instinct is to have every concept in that one document, but at a superficial level if necessary. I included a section "Tools for designing and maintaining aggregate tables", and then proceed to explain why there aren't any yet! Aggregate management is going to be a hard problem. Suggestions for tools which could help this welcome. I've also made some changes to the "Writing a schema", and "Performance" documents. Any further comments? Julian |