I am a newbie to this forum and relatively new to SQL especially SQL Server.
My first query in this area:
I have got 2 tables with one common field on which i can make a join.
A/ I have been asked to convert this data into a cube.
All i know is that a cube is more then 2 dimensional data. Would love your input on where i can learn about cubes and how do i achieve this in sql server 2012 as i already have a license for it.
B/ The objective of this exercise i believe, is to keep ready as many reports in as many permutation combinations as possible so that when a user asks for this data, its readily available and very fast to execute.
Wouldn't a view just work for this or is that too simple and time consuming to modify every time there is a different request?
C/ We also would like to use the BI part of SQL Server 2012. End result is for users to use Excel to interact and play with the data/reports.
Can users directly through excel leverage the BI tools of SQL Server 2012
Thanks in advance..