Analysis Services
Who is online?
0
guests and
3
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Create a new article
Home
»
Articles
» analysis-services
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
Analysis Services
Email
Understanding Analysis Services Relationships using Dimension Usage
In this article Devin examples how each relationship type works inside Analysis Services. After reading this you should be able to translate your data warehouse design into a cube design that can be used by your end users.
tags :
SSAS
DevinKnight
- 3/29/2011 - Comments:
8
- Views: 3151
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: 1371
Email
SSAS - Setting Attributes as Properties for Excel
Learn how to stop your end users from slicing your cube by items like First name, or email address, and still give them the ability to see this information with a couple of clicks. These techniques will improve your cube performance and enhance your user'...
MikeDavis
- 1/10/2011 - Comments:
13
- Views: 2941
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: 1350
Email
Getting Started With DAX in PowerPivot
In this article you will get a quick introduction the DAX, the formula language used in PowerPivot. With this tutorial you will get a start on modifying PowerPivot data.
tags :
PowerPivot
,
DAX
DevinKnight
- 10/20/2010 - Comments:
2
- Views: 2253
Email
MDX 101: Introduction to MDX
In this article, Dustin will cover the basics of the Multi Dimensional Expression (MDX) Language and introduce you to writing your first MDX statement.
tags :
MDX
,
Introduction to MDX
,
Learn MDX
,
MDX query syntax
DustinRyan
- 9/14/2010 - Comments:
11
- Views: 2582
Email
Creating 1000 Per member Per month Calculation in SSAS
Learn how to create the 1000pmpm calculation in SSAS. Learn how to easily create this popular calculation called “Per Member Per Month Per 1000” calculation or the “Per Customer Per Month Per 1000” calculation.
tags :
SSAS
,
1000pmpm
,
Calculation
,
MDX
MikeDavis
- 9/3/2010 - Comments:
1
- Views: 7476
Email
MDX Time Calculations Done the Right Way
In this article Devin shows you a unique way of writing time calculations. These calculations are dynamic so no matter what measure is used it will show it YTD, Previous Period, etc...
tags :
SSAS
,
MDX
DevinKnight
- 8/11/2010 - Comments:
22
- Views: 2667
Email
Creating your first Data Mining Structure and Model
Learn how to built a Data Mining Structure and Model. Understand how a view is set up to support the Data Mining.
tags :
SSAS
,
Data Mining
,
Mining Structure
,
Mining Model
MikeDavis
- 8/10/2010 - Comments:
2
- Views: 1674
Email
MDX Scripting with SCOPE Statement
In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.
tags :
MDX
,
SCOPE statement
,
MDX Scripting
DustinRyan
- 8/4/2010 - Comments:
15
- Views: 3639
Email
Creating a Hierarchy Using SSAS 2008
In this article, Brian is going to walk you through the steps to create a date hierarchy in SQL Server Analysis Services 2008.
tags :
Hierarchies using SSAS 2008
briankmcdonald
- 7/22/2010 - Comments:
0
- Views: 1856
Email
Creating dimensions in SSAS 2005 and 2008 -- differences
This article discusses the procedure to create dimensions in SAS 2005 and 2008. In both SSAS 2005 and 2008 we can create dimensions using wizards. The biggest difference is in 2005 the wizard asks lot more questions than in 2008. In 2008 the wizard is a l...
tags :
SSAS 2005
,
SSAS 2008
indupriya
- 7/6/2010 - Comments:
0
- Views: 1173
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:
15
- Views: 3414
Email
Parent-Child Dimension in Analysis Services
This article discusses use a Parent-Child dimension in your data warehouse and how you can configure Analysis Services to use a table structured this way. You will also read about an alternative to using a Parent-Child dimension because they can be harmfu...
tags :
SSAS
DevinKnight
- 6/7/2010 - Comments:
8
- Views: 3911
Email
Applying Security to Calculated Measures
Tired of not being able to secure your Calculate Measures through SSAS? One of the biggest issues facing Analysis Services Developers these days is applying security to calculated measures through roles. The problem is with the default behavior exhibited ...
tags :
SSIS
,
Calculated Measure
,
Security
AdamJorgensen
- 2/21/2010 - Comments:
1
- Views: 1592
Email
This Year - Last Year SSAS Calculated Member
In this quick demo I’m going to add a calculated member to the AdventureWorks cube that allows an end user to do a This Year/ Last Year comparison for a given measure.
tags :
Calculated Members
,
Calculated Measures
,
SSAS
,
Analysis Services
tinocash
- 2/16/2010 - Comments:
1
- Views: 1950
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:
14
- Views: 2359
Email
Setting up Many to Many in SSAS 2008 Cube
Learn how to set up a many to many relationship in SSAS 2008.
tags :
SSAS Cube Many-to-Many Many to Many Relationship Fact Dimension
MikeDavis
- 1/26/2010 - Comments:
13
- Views: 3086
Email
Road Trip with MDX Series (Intro to MDX Structures)
In this intro to MDX we will cover Dimensions, grains, measures and tuples
MikeMollenhour
- 12/30/2009 - Comments:
0
- Views: 856
Email
Road Trip with MDX Series (Trip Plan Intro)
This is a several part Series of MDX. I will take through definitions and examples starting from a beginers percpective ending in advanced calculations.
tags :
MDX AS
MikeMollenhour
- 12/29/2009 - Comments:
0
- Views: 659
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: 1531
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:
2
- Views: 1911
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: 724
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: 1566
Email
Kicking the Tires of MDX Rest Stop #2 MDX Journey Location Atlanta Georgia
This is the second part of a multipart series entitled MDX Rest Stop. This covers slicing by multiple dimension and basic MDX syntax.
MikeMollenhour
- 11/30/2009 - Comments:
2
- Views: 623
Page 1 of 2 (30 items)
<< Prev
1
2
Next >>
Go to page:
[Go]