Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel
In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole functionality ready-made in few seconds. Believe it or not, try the following:
- Open “SQL Server Data Tools” (This is new name assigned to Visual Studio IDE/BIDS in SQL Server 2012 RC0)
- Use MultiDimensionalProject & create a cube with any method you want.
- Process & Deploy it.
So far these are the intial setup steps for the trick I wanted to show you.