Analysis Services

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