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 |
|
gdeconto
Posting Yak Master
107 Posts |
 Posted - 2003-12-04 : 15:59:25
|
| I dont use cubes but am interested in doing so.I have looked at the documentation to see if I could answer the following question but wasnt able to. Maybe someone here would know the answer??question: does MSSQL allow the joining of cubes?we have a very large database (millions and millions of records) but large amounts of the data are old and dont need to be accessed often.rather than have the system spend hours and hours generating cubes for data that is not often used, I was wondering if we could:a. generate a cube for the old, less often used datab. generate a cube for the newer, more useful datac. join the cubes somehow (similar to how you can use UNION to join the content of two or more tables) so that the user can see the content of the pre-generated old data and newly generated new datathis way we can quickly build and scan the new info, and when needed scan the entire dataset.any help appreciated. |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-05 : 07:35:29
|
| You have options. In your case, probably you would want to create partitions for the cube and only process the newest partitions. There is a document on technet which explains Analysis Services performance tips that explains this concept. But you must have the Enterprise Edition of Analysis Services to do this.You can also create virtual cubes, which is kind of like a view of the cube. Here you can join cubes or leave out measures and dimensions for an existing cube.Finally there is a concept called Linked Cubes which I am not entirely familiar with as it also requires Enterprise Edition.I think what you most likely are looking for is partitioning the cubes. Hope this helps.--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
 |
|
|
|
|
|
combining cubes