Post reply

What is CUBE?

  • November 6, 2008 at 8:53 am

    #201273

    i do apologies if this question is very silly to you but i am just wondering when people send question and says problem with cube, working with cube. what it mean?

  • November 10, 2008 at 6:19 am

    #896249

    hi,

    It s a sentence that has benn used over collacially and there is nothing wrong in it as far as the concept of questioning has reached the user.

    Regards

    cholan

  • November 10, 2008 at 10:33 am

    #896426

    Hi there!

    From Microsoft BOL: "The CUBE operator generates a result set that is a multidimensional cube. A multidimensional cube is an expansion of fact data, or data that records individual events. The expansion is based on columns that the user wants to analyze. These columns are called dimensions. The cube is a result set that contains a cross tabulation of all the possible combinations of the dimensions."

    Maybe these articles can help get you started:

    http://msdn.microsoft.com/en-us/library/ms175939.aspx

    http://msdn.microsoft.com/en-us/library/ms175680(SQL.90).aspx

    Regards,

    Michelle Ufford
    SQLFool.com - Adventures in SQL Tuning

  • November 10, 2008 at 7:08 pm

    #896677

    I would say Cube is a representation of data similiar like a rubix cube. Where you can look at data from different angles(in analysis world - Dimensions). You can use "where" clause which is similiar like slicing the cube. Does that make sense ?;)

  • November 10, 2008 at 10:18 pm

    #896723

    dva2007 (11/6/2008)

    i do apologies if this question is very silly to you but i am just wondering when people send question and says problem with cube, working with cube. what it mean?

    suppose you have different database and these are not related to each other in any way.

    you know what the data is. but you dont know how to relate them to get the proper results.

    now use the CUBE for merging and producing the desired reports. use SQL server Dataware housing for more implementations

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • November 11, 2008 at 7:14 am

    #896933

    A cube reminds me of a pivot table in Excel.

Viewing 6 posts - 1 through 5 (of 5 total)

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