<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16441" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=277221520-12062007><FONT face=Verdana
color=#000080 size=2>No. Aggregation tables only contain one level of
aggregation.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=277221520-12062007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=277221520-12062007><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Thiyagu
Palanisamy<BR><B>Sent:</B> Tuesday, June 12, 2007 6:21 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] Roll-up query using a
single aggregation table<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Hi,</FONT> <BR><BR><FONT
face=sans-serif size=2>I'm trying to come up with a Mdx which do roll-up and
all the data (summary & detailed) for the query coming from the same
Aggregation table. </FONT><BR><FONT face=sans-serif size=2>Is it possible to
define an aggregation table to have both summary & detailed data?</FONT>
<BR><FONT face=sans-serif size=2>Can you please give an example?
</FONT><BR><BR><BR><FONT face=sans-serif size=2>Thanks,</FONT> <BR><FONT
face=sans-serif size=2>Thiyagu</FONT></BLOCKQUOTE></BODY></HTML>