How to dynamically determine which partitions to process?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » How to dynamically determine which partitions...

How to dynamically determine which partitions to process?

Rate Topic

Display Mode

Topic Options

Author

Message

femi

Posted Friday, March 08, 2013 2:40 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 1:01 PM
Points: 22, Visits: 17

Hello,

I have a Tabular model with a partitioned fact table based on date field. I have data in there from jan 1 to jan 10 partitioned daily..thus 10 partitions.

I now want to process the cube because I have new data for the 11th coming in.

My questions are;

1) How do I dynamically ask SSAS to create a fresh partition for day 11?

2) How do I ask SSAS to process partition 11 ONLY.

Thanks

Post #1428771

« Prev Topic | Next Topic »

Permissions