i created a cube with 4 measure groups and 5 dimensions,
one of the measure group is customer sales, which containes sale records range from Jan 1st, 2008 to Dec 31st,2009, and i partitioned it by month. each partition contains roughly 15 millions records.
the attribute relationships in the time dimension is as following,
the customer dimension's key attribute is customer number, and there are 5 million members(the number is still daily growing). except for the relationships between the key and the other attributes, there are no direct or indirect relationship between other
attributes. each of these 18 attributes generally have quite a few members.
purchase last month:yes,no
i then processed the cube, and accessed the data from within excel2007.
i dragged the sales amounts measure and then the year-month-date hierarchy,
it took about 10 seconds to show the sales amounts for the year 2008 and 2009.
i then clicked on the plus sign beside the "2008" to expand it, however, it took nearly 1 minute to get the results.
i then clicked on the
View Complete Post