MS SQL Server OLAP

Author

Partition

Polly

2005-11-24, 3:23 am

Dear all,

I would like to create two partition in my data cube. One partition
(Partition A) consists of all past data up to last month. This partition is
supposed to be processed manually or monthly. The other partition (Partition
B) consists of current month data. It will be processed daily at specific
time. In the next month, the current month data will be merged to Partition
A. Is it possible to do this and how?

Thanks a lot!

Regards,
Polly

Dave Wickert [MSFT]

2005-11-25, 3:23 am

Sure. Just setup the appropriate tables/views/query bindings for each
partition.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Polly" <Polly@discussions.microsoft.com> wrote in message
news:59CFFDDB-2A8D-4C79-AADA- 678D5D62FB7D@microso
ft.com...
> Dear all,
>
> I would like to create two partition in my data cube. One partition
> (Partition A) consists of all past data up to last month. This partition
> is
> supposed to be processed manually or monthly. The other partition
> (Partition
> B) consists of current month data. It will be processed daily at specific
> time. In the next month, the current month data will be merged to
> Partition
> A. Is it possible to do this and how?
>
> Thanks a lot!
>
> Regards,
> Polly

Polly

2005-11-25, 3:23 am

But how to do? Go to where to do? Where to set schedule to process Partition B?

"Dave Wickert [MSFT]" wrote:

> Sure. Just setup the appropriate tables/views/query bindings for each
> partition.
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Polly" <Polly@discussions.microsoft.com> wrote in message
> news:59CFFDDB-2A8D-4C79-AADA- 678D5D62FB7D@microso
ft.com...
>
>
>

Dave Wickert [MSFT]

2005-11-25, 8:23 pm

Create a partition against the table. Then click the table (this is called a
table-binding), then you can change it to a query-binding. When you do, the
query can be any SQL statement so long as the same columns are returned. You
can change the WHERE clause for one partition; a different WHERE clause for
the other.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Polly" <Polly@discussions.microsoft.com> wrote in message
news:9C02DED2-5833-42DB-A3EE- 51398AF2A99B@microso
ft.com...[color=darkred]
> But how to do? Go to where to do? Where to set schedule to process
> Partition B?
>
> "Dave Wickert [MSFT]" wrote:
>

Polly

2005-11-26, 3:23 am

Dave,

Thanks for your reply.

I have set the following in the WHERRE clause.
For partition A, time< str(year(getdate))+s
tr(month(getdate))+'
01'
For partition B, time> =str(year(getdate))+
str(month(getdate))+
'01'.
Now, I have two partitions and fully process these two partitions.

In the future, I only want to process partition A if data source data is
changed and daily process partition B. Where do I set schedule in Integration
Services? Drag "AS Processing Task" or Partition Processing"? Will these two
partitions automatically merged in the next month and create new month data
for partition B? If no, where I should set the merge?

Regards,
Polly
"Dave Wickert [MSFT]" wrote:

> Create a partition against the table. Then click the table (this is called a
> table-binding), then you can change it to a query-binding. When you do, the
> query can be any SQL statement so long as the same columns are returned. You
> can change the WHERE clause for one partition; a different WHERE clause for
> the other.
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Polly" <Polly@discussions.microsoft.com> wrote in message
> news:9C02DED2-5833-42DB-A3EE- 51398AF2A99B@microso
ft.com...
>
>
>

Sponsored Links