Post reply

Data Cube / SQL Server 2012 / BI

  • June 11, 2013 at 5:02 am

    #274909

    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

  • June 11, 2013 at 6:09 am

    #1622840

    Do not need in dopuble posting!

    Your starting point might be here:

    http://msdn.microsoft.com/en-US/library/ms170208(v=sql.110).aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • June 11, 2013 at 6:17 am

    #1622848

    Thanks Eugene

    Eugene Elutin (6/11/2013)

    Do not need in dopuble posting!

    Your starting point might be here:

    http://msdn.microsoft.com/en-US/library/ms170208(v=sql.110).aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply