There are multiple approaches of storing Summary Data, not only two.
One I am aware is
1. You can create a snapshot of the Fact Tables which will maintain only Summarized Data.
2. You can modify the Fact Table itself which can include Summarizing at the running Level. Let see Running_Total_Sales is the field in the FACT table which will contain the SALES up to DATE.
3. Try to create Materialized View scripts which can be used for populating the Summarized Data, which would nothing but a snapshot again.
There are multiple approaches of storing Summary Data, not only two.
One I am aware is
1. You can create a snapshot of the Fact Tables which will maintain only Summarized Data.
2. You can modify the Fact Table itself which can include Summarizing at the running Level. Let see Running_Total_Sales is the field in the FACT table which will contain the SALES up to DATE.
3. Try to create Materialized View scripts which can be used for populating the Summarized Data, which would nothing but a snapshot again.