[Mondrian] Few questions about "lost" dimensions aggregate tables
kCheng
xwcheng at gmail.com
Tue May 26 22:01:31 EDT 2009
Hi All,
Suppose there is a fact table has below definition :
Fact Table :
time_id,
location_id,
product_id,
measure
so one possible aggregate table would be(lost time dimension) :
location_id,
product_id,
measure
I have two questions
1: When there is query only takes with one dimension attribute(for example
: location_id, measure), does mondrian would use this aggregate table or
not?
2: The location and product dimensions has more than one levels(just the
same as foodmart sample data), does mondrian would always using this
aggregate table
for every MDX query contains levels from location and product dimension.
thanks,
kcheng
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090527/85b5a546/attachment.html
More information about the Mondrian
mailing list