Data Cube / SQL Server 2012 / BI

• rosstaylor2000xx

  Valued Member

  Points: 71

  More actions

  June 11, 2013 at 5:02 am

  #276196

  Hi Folks,

  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..

  Regds,

  Ross