We all know Sql Server Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Who has used this service in their projects? I need some guidance on what this really involves?
The Data Mining tools and the OLAP functionality are really two different things. My former company has implemented OLAP, but they're not using the Mining. As far as OLAP goes, you really, really, have to understand your data. You need to be able to identify areas where aggregation is going to help. I'd make sure you have a very good understanding of how to build a good star schema, because standard OLTP, while it can be used, is just not conducive to building cubes. The technology for building the cube is extremely simple to learn and implement. It's when you want to start putting on role based entitlement for security or taking direct control over what is displayed to the end users that you have to move into MDX. Then things get hard.
SSAS Cubes are mainly used for easy retrieval of data for creating reports and analysing the data from different perspectives to make crucial business decisions.SSAS plays a major role in the MS Business Intelligence. More often the historical data is stored in the SSAS cubes from the datamart(Fact and Dimension tables).Designing the SSAS Cubes is very important since the performance of the cube highly depends on the Cube design.