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

Sure. Just setup the appropriate tables/views/query bindings for each
partition.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote

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

"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 (AT) online (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote

Dave,

Thanks for your reply.

I have set the following in the WHERRE clause.
For partition A, time<str(year(getdate))+str(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: