Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim123456789jim
Starting Member
13 Posts |
 Posted - 2014-01-28 : 12:12:22
|
| Hi Team,We need to partition our cube dynamically based on year and period(ex 201306). So when there is a data load/update is happening in the fact only the particular partition is processed and not all. Dynamic partition I mean, when there is a load happening for a particular Year and Period, then a partition need to created in the cube.Please suggest. Thanks.RegardsJim |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-29 : 04:29:42
|
| you can do this by generating XMLA script for the create partition dynamically based on arrinving date values.First you need to maintain a table with information of existing partitions for each measure group.In your SSIS package you need to check incoming date values against the values in the table and see if there are any new year /period values coming. then you can generate XMLA script based on these new values and execute it using Analysis Services DDl task and use Analysis Services processing task for processing them.seehttp://sql-developers.blogspot.in/2010/12/dynamic-cube-partitioning-in-ssas-2008.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Partioning cube Measures dynamically