<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE id=ridTitle>Blank</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE><!-- body { font-family: Arial, Helvetica; font-size: 10pt; color: #000000; margin-top: 25px; margin-left: 25px; } P.msoNormal, LI.msoNormal { font-family: Helvetica, "Times New Roman"; font-size: 10pt; margin-top: 0px; margin-left: 0px; color: "#ffffcc"; } --></STYLE>
<META content="MSHTML 6.00.6000.16441" name=GENERATOR></HEAD>
<BODY id=ridBody background=cid:504555320@22052007-0C18>
<P><SPAN class=504555320-22052007><FONT face=Verdana
color=#000080>Richard,</FONT></SPAN></P>
<P><SPAN class=504555320-22052007><FONT face=Verdana color=#000080>Is there a
way to explicitly choose particular aggregate tables without specifying the
roles of all of the columns?</FONT></SPAN></P>
<P><SPAN class=504555320-22052007><FONT face=Verdana color=#000080>I have read
<A
href="http://mondrian.pentaho.org/documentation/aggregate_tables.php#Recognizing_explicit">http://mondrian.pentaho.org/documentation/aggregate_tables.php#Recognizing_explicit</A> and
the example therein. But I would like to just write</FONT></SPAN></P>
<P><SPAN class=504555320-22052007><FONT face="Courier New"> <Cube
name="Sales"><BR> <Table
name="sales_fact_1997"> <BR>
<AggName name="agg_c10_sales_fact_1997"/><BR>
</Table><BR><BR> </FONT><FONT face=Verdana
color=#000080>...</FONT></SPAN></P>
<P><SPAN class=504555320-22052007><FONT face=Verdana color=#000080>without any
embedded AggFactCount, AggForeignKey, AggMeasure, AggLevel elements, and have it
figure out the purposes of the columns. I tried AggPattern instead of AggName,
still no luck.</FONT></SPAN></P>
<P><SPAN class=504555320-22052007><FONT face=Verdana color=#000080>I also found
that when I made a mistake, it printed </FONT></SPAN></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><SPAN class=504555320-22052007></SPAN><SPAN class=504555320-22052007><FONT
face="Courier New" color=#000080>Too many errors, '1', while loading/reloadin
aggregates.</FONT></SPAN></P></BLOCKQUOTE>
<P><SPAN class=504555320-22052007><FONT face=Verdana color=#000080>but did not
tell me what the errors were!</FONT></SPAN></P>
<P><SPAN class=504555320-22052007><FONT face=Verdana
color=#000080>Julian</FONT></SPAN></P></BODY></HTML>