Who is online?  0 guests and 1 members
Home  »  search results

Search Results: Partitions

57 results found
  • Process Affected Partions and Creation of Dynamic Partions
    Hi ssingam. I really have to spend some time to create a blog with this one. I get a lot of help requests about this one. I would start by naming partitions by their date. Lets say your monthly partitions would be named 201201, 201202, and so on. And your
    Author: marcoadf marcoadf     Date: 5/24/2012     Section: Forum
  • Using SSIS to Automate the Creation of Cube Partitions
    This article will show you a method for using SSIS to create SSAS partitions in and automated process. No longer will you have to create partition in the designer. Create an SSIS package to do all the work for you the schedule it to run when needed.
    Author: DevinKnight DevinKnight     Date: 2/2/2010     Section: Article
    tags : Partitions, SSIS, SSAS
  • Analysis Services Aggregations
    In a previous article Devin showed how creating partitions can help performance optimization in SSAS. Now you are ready for the next performance tuning phase where you will design aggregations on your partitions.
    Author: DevinKnight DevinKnight     Date: 12/25/2009     Section: Article
  • Handle millions of rows evryday
    "maybe to Regions", this does not sound me good. Partitioning, has several advantages, such as inserting (switch in and switch out) and performance query. If you implement partitioned by Regions, I think you wont get the benefit of insert. Rebuilding your
    Author: marcoadf marcoadf     Date: 1/17/2012     Section: Forum
  • Anaylsis Services Partitions and Aggregations PASS Session
    For a little more than a year now I've been a part of the PASS BI SIG and have tried to contribute whenever possible. The SIG is split into several focus groups that meet on all BI topics. I help in leading the SSIS group. Today I actually had an opportun
    Author: DevinKnight DevinKnight     Date: 12/18/2009     Section: Blog
  • How to process changed records in SSAS cube.
    I will suggest you not to loop. If you do so, you will wait each time to process partition. Since you want to decrease time processing, you must parallel scripts. Have you an idea of how many partitions you may process? To dynamic create partitions, what
    Author: marcoadf marcoadf     Date: 12/22/2010     Section: Forum
  • How to process changed records in SSAS cube.
    I have never tried this, but I bet your could figure out a way to get the number of partitions and use a for each loop to process the partitions.
    Author: MikeDavis MikeDavis     Date: 12/21/2010     Section: Forum
    tags : Partition, SSAS
  • How to process changed records in SSAS cube.
    Hi Marco, I have created 3 partitions based on quarters and refreshing changed partition. But, some times changed data is falling in more than 3 partitions and henche some data is missing in the cube. Actually we can't predict the change of data, it may f
    Author: Siva Siva     Date: 12/30/2010     Section: Forum
  • Creating Analysis Services Partitions Using BIDS
    As your database grows in size, Analysis Services cubes that use that database grow along with it. As such, one thing that can improve performance of your cube is partitioning (splitting up) your measures. In this post, I am going to quickly show you how
    Author: briankmcdonald briankmcdonald     Date: 10/28/2010     Section: Blog
  • Parallel Loads in SSIS
    In this article, Brian shows you how to create a parallel load in SSIS. After this article, you'll be able to create a workload table to parallelize a data flow on multiple servers or on a single server with multiple cores.
    Author: BrianKnight BrianKnight     Date: 4/27/2010     Section: Article
  • SSAS performance tuning (Case Study)
    In the previous post , we have seen that only few smart moves/changes can make cube processing time far less than the current cube processing time. In this post, we will explore the way to identify the performance bottleneck and different ways to resolve
    Author: sirfnet sirfnet     Date: 3/16/2011     Section: Blog
  • Tuning Multi-Dimensional Cube Processing
    In my last post ( HERE ) we talked about troubleshooting and resolving issues with problematic MDX queries. In this post we will look at techniques to tune and troubleshoot the processing side of your Analysis Services cube. Understanding Cube Processing
    Author: cprice1979 cprice1979     Date: 14 days ago     Section: Blog
  • Analysis Services Processing Task - Best Practise
    Hi All, A simple request ;-) I want use the Analysis Services Processing Task task to fully regenerate my cube - To run "Process Full" on all cube partitions, measures and dimensions. What I found (rightly or wrongly) was that just choosing the Cube with
    Author: robbie robbie     Date: 9/15/2010     Section: Forum
  • How to process changed records in SSAS cube.
    Hi Marco, Wish you happy new year. We have decided to create partitions at yearly level since volume of the data is very less at month quarter level. Also, we identified that just need to process 2 partitions at a time (i.e current year and last year if d
    Author: Siva Siva     Date: 1/3/2011     Section: Forum
  • Analysis Services Partitions
    Dealing with large amounts of data in a cube can drag down performance on two levels (query performance and processing performance). In this part one article learn how you can performance tune Analysis Services to increase both query and processing perfor
    Author: DevinKnight DevinKnight     Date: 12/21/2009     Section: Article
    tags : Partitions, SSAS
  • How to process changed records in SSAS cube.
    Yes, it will be duplicated. When you create partitions, there is a warning tooltip to ensure that query splits data into diferent partitions. Since you have only 3 partitions (let's say 201101, 201010 and 201007) you can make the first partition (201007)
    Author: marcoadf marcoadf     Date: 12/30/2010     Section: Forum
  • Dynamic Partition Slices
    I have partitioned my cube on 13 most recent months, where each month get it's own partition, and a 14th to handle legacy months. Partitions work great, but now I want to add a dynamic slicer that I can drop in as an expression and use the current month a
    Author: KingConch KingConch     Date: 5/18/2012     Section: Forum
  • Slow Cube Build Times
    I have a production Cube Sql 2008 R2 SP1 that takes about 1 hr and 45 minutes to each day. I ran a trace on the build process to see where the time is really being chewed up. The two largest resource processes in the build are the degenerate dimension a
    Author: fsugeiger fsugeiger     Date: 12/6/2011     Section: Forum
    tags : Cubes
  • How to process changed records in SSAS cube.
    Hi marcoadf, Thanks for your reply. I think I'm very close to solve this issue. Could you please give me sample script task code that you are using so that i can test it my side. Also, How are you generating dynamic partitions by using SSIS package. I hop
    Author: Siva Siva     Date: 12/22/2010     Section: Forum
  • How to process changed records in SSAS cube.
    Hi Marco, Probably 2-3 partitions[Max] . I have total 4 measure groups and may need to refresh 8-10 [no. of MG* no.Of partitions] partitions at a time. So, i would create 1 container for each MG and place 2-3 script tasks parallel so that all can be refre
    Author: Siva Siva     Date: 12/22/2010     Section: Forum
  • Data Purging Machanism
    Yes, I have hundreds of dtsx doing that. Indeed, when you switch out your table must be empty in those partitions you are working (also know as target partitions). Typically, I create 2 temp tables: 1- One temp table (temp1) to switch out data from table.
    Author: marcoadf marcoadf     Date: 10/3/2012     Section: Forum
  • How to process changed records in SSAS cube.
    Hi All, One of my SSAS cube was taking long time to process and performance of the cube also bad. I am trying to create partitions to improve the query performance as well as processing time of the cube. But, my fact table is not static (not transactional
    Author: Siva Siva     Date: 12/20/2010     Section: Forum
  • How to process changed records in SSAS cube.
    Hi Marco, Thank you very much for your reply. Do we need to call this script task inside foreach loop to process partitions one by one or script task would process parallelly? Also, Could you pls guide me how to create dynamic partitions inside SSIS. yeah
    Author: Siva Siva     Date: 12/22/2010     Section: Forum
  • Windows 7 in GodMode
    I recently became aware of a special hack in Windows 7. It is called GodMode and can very simply be one of the easiest hacks that I’ve ever seen. I guess technically it’s not a hack because it is more or less a hidden feature. A feature which allows you t
    Author: briankmcdonald briankmcdonald     Date: 11/9/2010     Section: Blog
  • ROW_NUMBER() Function and Creating a Row ID on the Fly
    The ROW_NUMBER() function is a great function that was added with the release of SQL 2005 and is also included in SQL 2008. ROW_NUMBER makes it very easy to number your rows across the entire data set or across partitions of your data. Here are a couple e
    Author: DustinRyan DustinRyan     Date: 6/16/2010     Section: Blog