Aggregate Awareness

0

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.

Query:

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: 3 years 10 months ago

0 Answers:

No answers yet
Feedback