I am planning a couple of projects and wondered if I could combine efforts.
We have two specific goals:
1. Reduce load on our OLTP environment by reporting from a dedicated report environment
2. Implement dimensional modeling / cube functionality for analysts
My question is, can I (should I) develop reports over the data source views which will ultimately support the OLAP environment? Currently, I extract data to a staging area and I am in the process of building views which would support dims and facts. Would you suggest building other views over the same staging data to support reporting and / or building reports over the dims / facts or cube itself?
Sorry for the multi-question, fully-loaded, open-ended post. Thanks for your insight.