Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-02-29 : 11:49:11
|
| Can someone help me out in telling me what a data cube is and if you have any examples I can look at? We are in the process of using data cubes through SQL. What we are looking for is to be able to have summary of data, but if we wanted to click on a grouping we can go to the details of the data.I just wanted to know if there was any infomation/websites I can go and look at.Thanks,Wendy |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:22:53
|
| Take look at analysis service in books online. |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-01 : 22:02:09
|
As rmaio indicated, you are presumably using Analysis Services to build these cubes? Depending on how many records, Pivot tables in excel can query directly to a SQL server and allow the exact functionality you describe...despite the row limit of 65K in pre Office 2007 versions, the pivot cache can hold significantly more data than that (I feed pivot tables with over 600K rows without to much issue..but saving that data behind the pivot table is not recommended due to file size issues.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Cube - Data Files