[Mondrian] Roll-up query using a single aggregation table

Julian Hyde julianhyde at speakeasy.net
Tue Jun 12 16:15:39 EDT 2007


No. Aggregation tables only contain one level of aggregation.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Thiyagu Palanisamy
Sent: Tuesday, June 12, 2007 6:21 AM
To: mondrian at pentaho.org
Subject: [Mondrian] Roll-up query using a single aggregation table



Hi, 

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. 
Is it possible to define an aggregation table to have both summary &
detailed data? 
Can you please give an example? 


Thanks, 
Thiyagu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070612/7f6be689/attachment.html 


More information about the Mondrian mailing list