SSAS Development

SSAS Development

• • 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: 5172
• • 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: 4220
• • 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: 8383
• • 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: 2654
• • 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: 2887
• • 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: 2017
• • 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: 4965
• • 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: 4  -  Views: 2390
• • 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: 3149
• • 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: 20  -  Views: 5043
• • Email
  Seven Steps to a Cube in Analysis Services 2008
  In this article, Adam walks you through the basics of building a cube in SSAS 2008.
  tags : SSAS, Cube Design, SSAS Development, SSAS 2008
  AdamJorgensen   -  11/24/2009   -  Comments: 1  -  Views: 1944
• • Email
  Configuring an SSAS 2008 Project
  In this article, Adam takes you through the basics of configuring an SSAS project in Business Intelligence Development Studio. He explores some options you will use every day, and some you should consider using to improve your team development.
  tags : SSAS 2008, SSAS Development, SSAS Configuration, Visual Studio
  AdamJorgensen   -  11/24/2009   -  Comments: 0  -  Views: 1808
• • Email
  Creating a Data Source in SSAS 2008
  In this article, Adam walks through the process and options when creating a data source as your first step towards cube development in Analysis Services 2008.
  tags : SSAS Security, SSAS Development, SSAS Data Sources
  AdamJorgensen   -  11/24/2009   -  Comments: 0  -  Views: 1898
• • Email
  Creating a Data Source View(DSV) in SSAS
  Continuing with the series on building your first cube, Adam takes you through exploring the UDM in SSAS 2008 and creating a DSV from which your cube can be designed.
  tags : DSV, SSAS 2008, SSAS Development, SSAS Projects
  AdamJorgensen   -  11/24/2009   -  Comments: 0  -  Views: 2286