I work on a system which only has the capacity to retain data for 30 days. Once a week we produce a report which aggregates the data by a couple of dimensions. We would like to be able to produce long-term trend reports on that aggregated data (i.e. over multiple years). What is the best way to do that?
@jim_cross - Did sundareshr's answer below regarding Summary Indexing help you out? If yes, please click “Accept” below the answer to resolve this post. If no, please leave a comment with more feedback. Thanks.