|
Home > Archive > MS SQL Server OLAP > March 2006 > How to create partitions in AS2005?
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]
| Author |
How to create partitions in AS2005?
|
|
| yongli 2006-03-27, 8:28 pm |
| I have one fact table in the dsv and was able to create a measure group and a
default partition based on the fact table. Now how can I split the fact into
multiple partitions in the OLAP? It doesn't seem to have a filter or slice
option for the fact table like in AS2000.
Thanks,
| |
| Deepak Puri 2006-03-27, 8:28 pm |
| You can still set up partition filtering in AS 2005:
http://msdn2.microsoft.com/en-us/library/ms175611(SQL.90).aspx[color=darkred]
Creating and Managing Local Partitions
You can use the Partition Wizard to create additional partitions in a
cube. The Partition Wizard is opened by first expanding a measure group
entry on the Partitions tab in Cube Designer and then clicking New
Partition. For the different ways to allocate data from a measure group
to a partition, see the following table.
...[color=darkred]
http://msdn2.microsoft.com/en-us/library/ms175325(SQL.90).aspx[color=darkred]
Filtering a Fact Table for Multiple Partitions
When the same fact table is used for more than one partition in a cube,
it is important that the same rows are not used in more than one
partition. It is possible for a row that is used in more than one
partition to be included multiple times when the cube is processed or
queried; this can cause queries to return incorrect data.
You can use filters in partitions to ensure that data is not duplicated
among the partitions. A partition's filter specifies which data in the
fact table is used in the partition.
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
| |
| yongli 2006-03-29, 1:30 pm |
| Thanks, I just wish that I do not have to specify partitions in a query.
"Deepak Puri" wrote:
> You can still set up partition filtering in AS 2005:
>
> http://msdn2.microsoft.com/en-us/library/ms175611(SQL.90).aspx
> Creating and Managing Local Partitions
>
> You can use the Partition Wizard to create additional partitions in a
> cube. The Partition Wizard is opened by first expanding a measure group
> entry on the Partitions tab in Cube Designer and then clicking New
> Partition. For the different ways to allocate data from a measure group
> to a partition, see the following table.
> ...
>
>
> http://msdn2.microsoft.com/en-us/library/ms175325(SQL.90).aspx
> Filtering a Fact Table for Multiple Partitions
>
> When the same fact table is used for more than one partition in a cube,
> it is important that the same rows are not used in more than one
> partition. It is possible for a row that is used in more than one
> partition to be included multiple times when the cube is processed or
> queried; this can cause queries to return incorrect data.
>
> You can use filters in partitions to ensure that data is not duplicated
> among the partitions. A partition's filter specifies which data in the
> fact table is used in the partition.
> ...
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
>
|
|
|
|
|