Aggregate Awareness

For performance optimization created a summary sales fact table at the grain of Week . The sales fact  table at the grain of week is summary of Sales Fact at the grain of day.


1) Does Jasper soft support aggregate awareness i.e if use selects week dimension then should query week fact table else day fact table . Note that OLAP Cube or MV is not created .



shaibu.cheradai's picture
Joined: Sep 22 2015 - 11:16pm
Last seen: 7 years 2 months ago

0 Answers:

No answers yet