Search Results: dimension

• 
  Junk Dimensions with no Loading Needed

  When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be in any other dimension. When this occurs you can combine them into one dimension call a Junk Dimension. In this example yo

  Author:  MikeDavis     Date: 5/6/2011     Section: Blog

  tags : Cube, Dimension, DSV, Junk Dimension, SSAS
• 
  SSAS Parent Child Dimension Properties

  I’ve saved the best for last, so they say. Well, depending on how you look at it. Over the last week, I’ve blogged about all of the other sections in Analysis Services dimensions except for parent-child, so now it’s time to finish off ou

  Author:  ChrisSchmidt     Date: 3/6/2013     Section: Blog

  tags : memberswithdata, memberswithdatacaption, parent child naming template, ssas dimensions, ssas parent child dimensions, unaryoperator
• 
  Create Date Dimension with Fiscal and Time

  Here are three scripts that create and Date and Time Dimension and can add the fiscal columns too. First run the Dim Date script first to create the DimDate table. Make sure you change the start date and end date on the script to your preference. Then run

  Author:  MikeDavis     Date: 2/4/2011     Section: Blog

  tags : date, Date Dimension, dim date, dim time, dimension, fiscal, time, ssas
• 
  SSAS Different Dimension Granularity

  In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example, if you have budget measures and actual numbers. If you are trying to budget your expenses you budget at a higher level than the actual

  Author:  MikeDavis     Date: 5/28/2010     Section: Blog

  tags : Cube, DImension, Granularity, Define Relationship, SSAS
• 
  How to create Day,Month,yearwise Cube in SSAS

  about time dimension, there is some posts about it. take a look at: Mike's post in2bi's post In SSAS, there is this link with a good tutorial on how to build time dimension in your as cube. If this helps you, mark post as answered please. Best regards.

  Author:  marcoadf     Date: 2/10/2012     Section: Forum

  tags : build, dimension, table, time
• 
  Dimensional Data Model -- General Concepts

  This article covers the general concepts of data modelling in simple terms. A very brief overview of dimensions and measures is provided.

  Author:  indupriya     Date: 7/20/2010     Section: Article

  tags : BI basics, concepts, Dimensional data
• 
  How to create Day,Month,yearwise Cube in SSAS

  Well, there is a lot of concepts that you should take in consideration. 1st of all, you will need a fact table. In this table you should have a day code. This day code typically has YYYYMMDD format so it can be a integer and benefict from many advantages.

  Author:  marcoadf     Date: 2/10/2012     Section: Forum

  tags : code, day, month, quarter, table, time dimension, year
• 
  SSAS Dimension Properties : Misc and Source

  Previously I’ve blogged about both Basic dimension properties ( here ) and Advanced dimension properties ( here ), so today I’d like to finish off this initial set by blogging about the misc and source sections of the properties of an attribut

  Author:  ChrisSchmidt     Date: 3/4/2013     Section: Blog

  tags : dimension misc properties, dimension properties, dimension source properties
• 
  Loading Type 1 and Type 2 Dimensions made Easy with Task Factory

  Ever had to load a Data warehouse? Isn’t it so much fun creating all of those transforms to load a type 2 dimension? Of course it’s not; it is a lot of work. Well now you can load those dimensions very easily using Task factory. Task Factory is a group of

  Author:  MikeDavis     Date: 6/8/2011     Section: Blog

  tags : SSIS, Task Factory, Tasks, Type 1, Type 2
• 
  SSIS: parallel processing not supported by analysis services processing task

  I'm processing all the Dimensions related to the Cube through SSIS. I process the Cube separately once all the Dimensions have been processed. I use the SSIS component "Analysis Services Processing Task": - In the editor, I add the required Dimensions wit

  Author:  amrit     Date: 3/22/2011     Section: Forum

  tags : Enterprise Edition, Parallel Processing, SSAS, Standard Edition, Warning, SSIS
• 
  Normalization vs. Dimensional Modeling

  This article is a basic overview and comparison between normalization and dimensional modeling.

  Author:  ShawnHarrison     Date: 1/11/2010     Section: Article

  tags : dimensional, fact, snowflake, star, normalization
• 
  Dimension "Process Update"

  I am working in a scenario where I want to update certain cell values in the dimension tables (in the DW) and then bring those changes to the cube dimensions using "Process Update". I know there is a writeback option but I want to update my datawarehouse

  Author:  az.asharma     Date: 7/6/2011     Section: Forum

  tags : cube, Dimension, Distinct Count, Process Update
• 
  Date Filtering in Excel from your Analysis Services Dimension

  I recently had to set up another Date Dimension and went through the process of setting up all the properties in the date dimension so that when it is used in Excel, the end users would then be able to use the Date Filters built into Excel. The Excel Date

  Author:  guavaq     Date: yesterday     Section: Blog

  tags : Excel, SQL Server Analysis Services, SSAS, ssis
• 
  Creating a tabular database

  In SQL Server 2012 Analysis Services, Microsoft introduced the xVelocity engine and the tabular model for databases into Analysis Services. This gives much more compression and performance, but not all of the features of multi-dimensional databases are av

  Author:  ChrisSchmidt     Date: 10/23/2012     Section: Blog

  tags : 2012, Analysis Services, BI, BISM, Business Intelligence, DAX
• 
  Insert Unknown Row to Dimension Table

  When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables. For me, this is a monotonous task that I hate doing. I was recently on a project that had a large number of dimensions and I refused to write a T-SQL St

  Author:  PatrickLeBlanc     Date: 6/15/2010     Section: Blog

  tags : Dimension, Script, T-SQL, Warehouse
• 
  Gotchas With Referenced Dimensions

  A referenced dimension relationship allows us to create a relationship between a measure group and a dimension that is indirectly related to the measure group using an intermediate dimension. This is great, because we can now create relationships between

  Author:  DustinRyan     Date: 1/25/2013     Section: Blog

  tags : materialize referenced dimension, referenced dimension
• 
  Have any of you used this Slowly Changing Dimension Component?

  For small dimensions it is usable (the standard SCD), but for slightly bigger dimensions it slows down the package because it doesn't use cache. Here are some alternatives . You can support a request to improve performance at Microsoft .

  Author:  SSISJoost     Date: 1/18/2011     Section: Forum

  tags : SCD, Slowly changing dimension, SSIS, Performance
• 
  Add missing dimension members during fact load

  This is a variation of a pattern I saw in SQL Server Integration Services Problem Design Solution by Erik Veerman, Jessica Moss, Brian Knight, and Jay Hackney. I would highly recommend this book. I found at least 4 chapters in the book that were each wort

  Author:  Daniel     Date: 4/20/2012     Section: Blog

  tags : Inferred member, missing dimension lookup
• 
  Hierarchies in SSAS Multidimensional: What’s really happening up (or down) in there?

  A few days ago I got an interesting question. The question was “When you build an hierarchy in SSAS, what’s actually happening to it on disk?” As in, how does the file system actually place it in files so it can easily identify the hiera

  Author:  ChrisSchmidt     Date: 3/5/2013     Section: Blog

  tags : hierarchies, natural hierarchy, unnatural hierarchy
• 
  MDX Scope with an If Then Exception or Filter

  The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here . The issue I am going to cover will be using the scope statement when you only

  Author:  MikeDavis     Date: 8/5/2010     Section: Blog

  tags : Exception, Filter, If Then, Scope, MDX
• 
  SSAS Processing All Dimensions

  When working with SSAS it is sometimes necessary to process every dimension before continuing with development. This can be accomplished with a couple of clicks on the menu bar. Click on Database and then process. Then you will see each dimension processi

  Author:  MikeDavis     Date: 12/8/2010     Section: Blog

  tags : Process all Dimensions, SSAS
• 
  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

  Author:  indupriya     Date: 7/6/2010     Section: Article

  tags : SSAS 2008, SSAS 2005
• 
  Handling Large Many to Many bridge tables

  In some scenarios you will need to create a many to many relationship in your cube in SSAS. I have an article that shows you how to do this here . One of the problems that arise from many to many bridge tables are the size of these tables. In this example

  Author:  MikeDavis     Date: 5/6/2011     Section: Blog

  tags : Cube, Dimension, Factless Fact Table, Many to Many, SSAS, Bridge Table
• 
  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.

  Author:  sirfnet     Date: 1/10/2011     Section: Article

  tags : SSAS, SSAS Tutorial, Tutorial, Advanced Feature
• 
  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.

  Author:  sirfnet     Date: 1/10/2011     Section: Article

  tags : SSAS, SSAS Tutorial, Tutorial, Advanced Feature