SSAS administration articles
Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Create a new article
Home
»
Articles
» ssas-administration
Communifire Articles
Topics
Most recent articles
Featured articles
.Net Development
Analysis Services
MDX and DMX
SSAS Administration
SSAS Development
Business
Data Mining
Data Warehouse Performance Tuning
Data Warehousing Design
Integration Services
SSIS Administration
SSIS Development
Miscellaneous
Press Releases
Product Reviews
Reporting Services
SSRS Administration
SSRS Development
Training and Certification
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
Page 1 of 1 (8 items)