tag:blogger.com,1999:blog-5098208425613902582.post3964868177987155797..comments2023-05-24T04:03:44.929-07:00Comments on Tips and Tricks for SQL Server Developers: Dynamic Cube Partitioning in SSAS 2008SQL BI Devhttp://www.blogger.com/profile/05174359128365572180noreply@blogger.comBlogger35125tag:blogger.com,1999:blog-5098208425613902582.post-45526566824571238242013-06-20T17:14:14.437-07:002013-06-20T17:14:14.437-07:00An excellent guide and a very well structured proc...An excellent guide and a very well structured process, exactly what I've been looking for. Thanks so much!DanChttps://www.blogger.com/profile/12649037490895040628noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-60347157183154791272013-06-20T17:11:18.256-07:002013-06-20T17:11:18.256-07:00This comment has been removed by the author.DanChttps://www.blogger.com/profile/12649037490895040628noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-48123321036928505132013-03-26T20:21:41.446-07:002013-03-26T20:21:41.446-07:00Thanks. It is very helpful.Thanks. It is very helpful.Anonymoushttps://www.blogger.com/profile/03563205171278246458noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-66535839766171744532013-02-28T06:50:23.376-08:002013-02-28T06:50:23.376-08:00Thanks, very good.Thanks, very good.mosebackemonarkihttp://mosebackemonarki.wordpress.com/noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-16019391343106039332013-02-07T10:02:42.968-08:002013-02-07T10:02:42.968-08:00Thanks for the great post. Helped me out a ton.Wh...Thanks for the great post. Helped me out a ton.<br>What if we want to retrieve the partition size for each partition created and processed. Then output to a the partitionLog table?Chrishttp://www.blogger.com/profile/05121140326544674741noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-37752800292123255952013-02-03T22:55:08.249-08:002013-02-03T22:55:08.249-08:00Hey Hari,First of all thanks for this amazing post...Hey Hari,<br>First of all thanks for this amazing post. <br><br>I have run into a problem which I cant seem to get a handle on, so I am bothering you. In the second script task I see an error "The binary code for the script is not found". I built the script code alone and found that it could not find Microsoft.Analysis Services.dll. Are you using SQL Server 2005 for the solution because this comes when we migrate it to SQL Server 2008. I am using 2008 so I am not sure what else can cause this issue.<br>Do you have any idea how to fix that?kautukhttp://www.blogger.com/profile/13548049802698756776noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-27244364820081753072012-12-27T09:07:01.821-08:002012-12-27T09:07:01.821-08:00I had to research the same problem. You have to s...I had to research the same problem. You have to set the "Delay Validation" property of the task to "True." That solved the problem for me.<br><br>http://mohitnayyar.blogspot.com/2007/10/selective-cube-measure-groups.html<br>d4a47ec8-5047-11e2-b143-000bcdcb5194https://openid.aol.com/opaque/d4a47ec8-5047-11e2-b143-000bcdcb5194noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-35198465399603121152012-12-20T17:13:54.812-08:002012-12-20T17:13:54.812-08:00I am getting many request offline to send the solu...I am getting many request offline to send the solution. To make it easier, I have added a link at the end of the article to download the solution!Hari Sharmahttp://www.blogger.com/profile/17519330349426599363noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-58413623586896961052012-12-07T10:42:22.555-08:002012-12-07T10:42:22.555-08:00Hi Guys , I saw some of you got the package , I as...Hi Guys , <br>I saw some of you got the package , I asked <br>Hari 100 times to provide it to me without any result , <br>can somebody send the package to vali_loghin@yahoo.com<br><br>Thank you in advance !!!<br>Val <br>Valhttp://www.blogger.com/profile/17737752234000487788noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-46254223260319268772012-12-07T10:29:52.325-08:002012-12-07T10:29:52.325-08:00Great article! I can't wait to see the project...Great article! I can't wait to see the project.<br>Could please forward the project to gasblr@gmail.com<br><br>Thank you very much.Shaan Shttp://www.blogger.com/profile/12342708837046894914noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-37076192054214109402012-12-05T13:12:47.264-08:002012-12-05T13:12:47.264-08:00I'm having difficulties with the Step 11. In A...I'm having difficulties with the Step 11. In Analysis Services Processing task I add the 'Sales_20100101-20100131' partition as an object. I add an expression with a Property of 'Processing Commands' and drag and drop the variable @[User::ProcessPartitionXMLA]into the Expression. When I save the package and edit this task the object has disappeared. If I try and run the package without saving I have a Package validation error - 'Processing commands contain DDL that is not valid'. I manually ran the modified script in SSMS and it worked fine.Peter Murdockhttp://www.blogger.com/profile/11359223991967411476noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-37356330375458645222012-11-12T15:50:19.607-08:002012-11-12T15:50:19.607-08:00Can you send me the project also? rkolofer21@gmail...Can you send me the project also? rkolofer21@gmail.com<br><br>Thanks a lot!rkoloferhttp://www.blogger.com/profile/03171475828610663745noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-79597371069103917492012-10-31T09:10:10.918-07:002012-10-31T09:10:10.918-07:00Never mind, I solved the problem.Apparently for so...Never mind, I solved the problem.<br>Apparently for some reason the script requires that any object ID will be identical to that object's name (even though the script dosen't even have parameters object IDs). In my case I had a MeasureGroup ID different than the MG name, so it didn't recognize the partition as existing.<br>Only after re-creating the MG with same ID as the name, it passed the value 1 to IsPartitionExists variable.Shmulikhttps://me.yahoo.com/a/p6QV04sM0OMawhhkXYdSeiG5W.1lGg--noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-3204420983200354802012-10-29T08:42:04.164-07:002012-10-29T08:42:04.164-07:00Hi,Thanks for the detailed explanation.I applied y...Hi,<br>Thanks for the detailed explanation.<br>I applied your instructions step by step on my cube, and managed to create partitions up until the current month (Oct 2012).<br>Problem is, once it got to the current partition, it won't skip the Execute DDL Task, and it fails the package, saying this partition already exists.<br>I placed a PostExecute Breakpoint on the second Script Task, and realized that the variable IsPartitionExists keeps getting the value 0, even though the partition already exists and as per the script it should get value 1, hence skip the DDL Task (that's what the precedence constraint is for).<br>Any idea of why does the script keeps placing value 0 to the variable?<br><br>Thanks,<br>MuliShmulikhttps://me.yahoo.com/a/p6QV04sM0OMawhhkXYdSeiG5W.1lGg--noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-9912100001805848202012-10-22T03:30:54.751-07:002012-10-22T03:30:54.751-07:00Could you pleease send me project too? hongseboy@g...Could you pleease send me project too? hongseboy@gmail.comJulian Linhttp://www.blogger.com/profile/03247280710753825063noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-55366879979828126682012-10-15T06:33:48.256-07:002012-10-15T06:33:48.256-07:00Could you pleease send me project too; mtnrkl@gmai...Could you pleease send me project too; mtnrkl@gmail.comMehmet Arslanhttp://www.blogger.com/profile/13079953764913712719noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-91804628030736088702012-10-14T12:16:13.355-07:002012-10-14T12:16:13.355-07:00Hi DearThank, it's excellent example.Can you s...Hi Dear<br>Thank, it's excellent example.<br>Can you send me your sample code?<br>My Email Address is:hamedpalik@gmail.comdatamininghttp://www.blogger.com/profile/13991297521902081394noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-3372738160193633372011-01-22T13:27:55.520-08:002011-01-22T13:27:55.520-08:00Harris,If you look at ProcessPartitionSales_201001...Harris,<br>If you look at ProcessPartitionSales_20100101-20100131.xmla file, it will always process only this partition because ProcessOption is used as ProcessFull. At run time variable ProcessPartitionXMLA will convert the static partition into running partition.<br><br>However, In your Dimension Processing Task, make sure the ProcessOption for dimensions are ProcessUpdate.Hari Sharmahttp://www.blogger.com/profile/17519330349426599363noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-43441039669335443662011-01-20T08:19:50.053-08:002011-01-20T08:19:50.053-08:00HariThe variable for processing the fact is workin...Hari<br><br>The variable for processing the fact is working now so please ignore the above posts. There was apparently error in initializing the variable.<br><br>Now I have some thing else for you :)<br><br>When i run the package it creates new partition and process the dimensions and the freshly created partition. The problem is if I am processing Partition for December it deletes all the old records from the cube and only December is available for viewing. I need to keep the old records in cube and process the new partition to add new records.<br><br>Any thoughts?<br><br>Cheers<br><br>HarrisHarrisnoreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-23706590145109927542011-01-20T06:28:50.993-08:002011-01-20T06:28:50.993-08:00HariI am using a variable @ProcessXMLA to process ...Hari<br>I am using a variable @ProcessXMLA to process a partition. The problem now is if I put this XMLA code in Analysis Services Processing Task's Processing Command property without setting any expression the task works fine but if I use the same as a variable in expression it gives me the error which I mentioned in earlier post.<br><br>Thanks for your help.<br><br>HarrisHarrisnoreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-10707727119532367552011-01-20T03:12:44.802-08:002011-01-20T03:12:44.802-08:00Hi HariFor the first question its no more problem ...Hi Hari<br><br>For the first question its no more problem now.<br><br><br>For the second one your answer does make sense. but I went through the full step 11 i have selected the available partition the default one for processing. then in expression i have selected the Partition Processing Variable. when i run the package now it still gives me the same error. when i open Analysis Services processing task now I cannot see the default partition in object list. there is nothing every thing is removed.<br><br>Can you please comment on this?Harrisnoreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-83586144658747383452011-01-15T00:25:40.351-08:002011-01-15T00:25:40.351-08:00@Harris,For your first Question - I have mentioned...@Harris,<br>For your first Question - I have mentioned how to generate XMLA script in STEP5.<br><br>For your second question - Please go throgh Step 11 once. To avoid any validation errors, you need to select the default partition to be processed (which is already processed by you). At run time, variable will take of running partition.<br><br>Does this make sense?Hari Sharmahttp://www.blogger.com/profile/17519330349426599363noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-63522943847572430852011-01-14T10:08:22.961-08:002011-01-14T10:08:22.961-08:00I have found the way to get xmla script :)there is...I have found the way to get xmla script :)<br><br>there is one more problem in the cube processing task when i give variable for processing the current partition it says <br><br>TITLE: Package Validation Error<br>------------------------------<br><br>Package Validation Error<br><br>------------------------------<br>ADDITIONAL INFORMATION:<br><br>Error at Analysis Services Processing Task 1 [Analysis Services Processing Task]: Processing commands contain DDL that is not valid.<br>Error at Analysis Services Processing Task 1: There were errors during task validation.<br><br>(Microsoft.DataTransformationServices.VsIntegration)<br><br>do you have any suggestion on this.<br><br>regards<br><br>harrisharrisnoreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-19377890103630969582011-01-14T05:19:12.183-08:002011-01-14T05:19:12.183-08:00Hi Harii followed your guidelines step by step usi...Hi Hari<br><br>i followed your guidelines step by step using my own cube. In the end I cannot see the partition under cube in solution explorer when i process the cube the newly created partition has been processing which is fine, but in order to generate the script i cannot see the partition in the solution explorer...<br><br>any helpharrisnoreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-46845582263131713032011-01-13T14:46:53.939-08:002011-01-13T14:46:53.939-08:00Amazing! The same is conceptually explained in Exp...Amazing! The same is conceptually explained in Expert Cube Development with SSAS 2008 book. The authors also present a solution with that book. But I found the one presented here, to be the simplest. Thanks.Anonymousnoreply@blogger.com