SSAS administration articles

SSAS Administration

• • Email
  SSAS Data Security (Dimension and Cell Security)
  SSAS provides the way to secure analysis services database/cube data from unauthorized access. Analysis services provides secure access by creating object called "roles". This article will talk in detail about dimension and cell level security.
  tags : Advanced Feature, SSAS, SSAS Tutorial, Tutorial
  sirfnet   -  1/14/2011   -  Comments: 0  -  Views: 2610
• • Email
  SSAS Data Security (Dimension and Cell Security)
  SSAS provides the way to secure analysis services database/cube data from unauthorized access. Analysis services provides secure access by creating object called "roles". This article will talk in detail about dimension and cell level security.
  tags : Advanced Feature, SSAS, SSAS Tutorial, Tutorial
  sirfnet   -  1/10/2011   -  Comments: 4  -  Views: 2363
• • Email
  
  Analysis Services Dynamic Security
  This article explains one method that can be used for dynamically configuring security in Analysis Services. All security information is stored in relational tables making it easier to manage.
  tags : SSAS
  DevinKnight   -  6/17/2010   -  Comments: 18  -  Views: 5398
• • Email
  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.
  tags : SSAS, Partitions, SSIS
  DevinKnight   -  2/2/2010   -  Comments: 15  -  Views: 3427
• • Email
  Analysis Services Usage-Based Optimization (UBO)
  Devin continues to show how performance optimization in SSAS can be done in a few short steps. This article details a feature called Usage-Based Optimization (UBO) that allows you to use user queries to tune query performance.
  tags : SSRS, Partitions, Aggregations
  DevinKnight   -  12/28/2009   -  Comments: 2  -  Views: 2473
• • Email
  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.
  tags : SSAS, Partitions, Aggregations
  DevinKnight   -  12/25/2009   -  Comments: 3  -  Views: 3159
• • Email
  Analysis Services 200x Then and Now ...
  In this article, Adam takes us through the major changes from SQL Server Analysis Services 2000 through Analysis Services 2008.
  tags : Upgrading SSAS, SSAS 2000, SSAS 2005, SSAS 2008
  AdamJorgensen   -  12/23/2009   -  Comments: 0  -  Views: 1324
• • Email
  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...
  tags : SSAS, Partitions
  DevinKnight   -  12/21/2009   -  Comments: 6  -  Views: 2372