Nick-957131 (2/5/2014)
I suppose my question now is can I (should I) use the same dim / facts and subsequent views to support reporting as well as ssas?Thanks again...
Oh, sure. You'll normally simply preprocess your cubes during overnights for daily work, but if you have reports and the like that don't make sense for the overkill MDX can be sometimes, go nuts.
The reporting database typically won't be real time. If you need real time reports, keep the filters tight and run them off the OLTP system. Warehouses and OLAP are typically used more for overview type stuff, not realtime.
Of course, there's exceptions to that everywhere.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA