Search Results: Cube Design

• 
  Using Dimension Member Property Values in MDX/DataSets/Reports

  I get a bit frustrated with accommodating SSAS cube design decisions for SSRS shortcomings. Specifically, it does not make sense in the cube design to set the AttributeHierarchyEnabled property to TRUE for attributes with high cardinality. These attribute

  Author:  Timo     Date: 3/30/2011     Section: Forum

  tags : AttributeHierarchyEnabled, custom member property, MDX, query designer
• 
  How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?

  Hi people, How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?. I have a data cube designed and deployed on Microsoft SQL Server Analysis Services R 2. I have a customer dimen

  Author:  Mobzam     Date: 12/14/2011     Section: Forum

  tags : Calculations
• 
  SSWUG Free Expo Event: Understanding SQL Server Analysis Services on 20th May 2011

  Here is another free expo/event from SSWUG about SSAS on 20th May 2011 Sessions will cover the following topics: Common Mistakes with SSAS Cube Designs SSAS Partitioning and Aggregation Strategies Properly Using the SSAS Query Cache Overcoming SSAS Implem

  Author:  meganathank     Date: 3/20/2011     Section: Blog

  tags : Free Event, SSWUG, SSAS
• 
  MDX Calculation Builder Automatically Builds MDX Calculations for You

  One of the most powerful aspects of Analysis Services is the ability to easily view your facts over time. What's not always so easy is writing those calculations that make complex time analysis possible. MDX can have a steep learning curve, which is where

  Author:  DustinRyan     Date: 10/31/2011     Section: Blog

  tags : BI xPress, MDX Calculation Builder
• 
  Different Granularity in a Single Dimension

  There is no perfromance hit due to the lack of foreign keys, in fact I would suggest using views in you DSV instead of the actual tables. That is dicussed in this book. Expert Cube Design. There is a perfromance hit when using strings instead of int's in

  Author:  MikeDavis     Date: 10/18/2010     Section: Forum

  tags : Cube, Design, ssas
• 
  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.

  Author:  DevinKnight     Date: 3/29/2011     Section: Article

  tags : SSAS
• 
  Free SSAS Expo again from SSWUG on FRiday (20th May 2011)

  SSWUG.ORG’s virtual expo will review various aspects of SQL Server Analysis Services (SSAS), which enables the server to be used for analytical processing and data mining. Through our in-depth sessions with four of the leading experts in the information t

  Author:  indupriya     Date: 5/19/2011     Section: Blog

  tags : SSWUG.org, SSAS Expo
• 
  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.

  Author:  AdamJorgensen     Date: 11/24/2009     Section: Article

  tags : Cube Design, SSAS 2008, SSAS Development, SSAS