|
Home > Archive > MS SQL Data Warehousing > March 2006 > Whats in a cube?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| ChrisR 2006-03-05, 8:24 pm |
| I know that I define what makes up a cube. I know that I point Analysis
Services to a data source. But when I create a cube, is it actually making a
copy of that data source defined by my dimensions and measures? Or is it
just creating meta data with my definitions?
TIA, ChrisR
| |
|
| a Real time ROLAP storage provide "only" a metadata around your data and
execute SQL query against the source (slow access)
a MOLAP storage get an entire copy of the data + metadata. (fast access)
in ROLAP mode you can create aggregation in the database himself, so you'll
found new tables created in your database which contains aggregated data.
MOLAP mode is recommanded by default for optimal performance.
but there is many other options regarding your needs.
"ChrisR" <ChrisR@noEmail.com> wrote in message
news:OeE9bIOPGHA.1760@TK2MSFTNGP10.phx.gbl...
>I know that I define what makes up a cube. I know that I point Analysis
> Services to a data source. But when I create a cube, is it actually making
> a
> copy of that data source defined by my dimensions and measures? Or is it
> just creating meta data with my definitions?
>
> TIA, ChrisR
>
>
|
|
|
|
|