Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Cube / SQL Server 2012 / BI Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 5:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 17, 2013 12:33 PM
Points: 3, Visits: 11
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
Post #1461997
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse