Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: dimensional
73 results found
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
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
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
Power View Reporting on Multi
dimensional
Cubes Released
I’m a little late to the celebration but on Friday some there was some exciting news regarding Power View was announced. You can read about the details of it at the Analysis Services and PowerPivot team blog for Microsoft here. http://blogs.msdn.com
Author:
DevinKnight
Date: 16 days ago Section:
Blog
tags :
Power View
,
PowerPivot
,
SharePoint
,
SQL Server
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
SQL Server “Denali”: Installing SSAS Multi
dimensional
vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model (I covered these new features here ). During ins
Author:
jamserra
Date: 7/25/2011 Section:
Blog
tags :
Denali
,
SQL Server
,
SSAS
,
BISM
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.
Author:
DustinRyan
Date: 9/1/2010 Section:
Article
tags :
Introduction to MDX
,
Learn MDX
,
mdx
,
MDX query syntax
Let’s get Dimensional – from Requirements to Dimensional Design
Hey folks! You asked for it – so coming up on September 8th we’re doing a SQL Lunch that is going to take a business requirement and create a star schema from it to us for our data warehouse. We will build our dimensional model together from a business re
Author:
AdamJorgensen
Date: 9/6/2010 Section:
Blog
tags :
Dimensional Modeling
,
SQL Lunch
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
Free Data Warehouse Training - SQL Lunch #27 Let's Get Dimensional
Join Adam Jorgensen, tomorrow on the SQL Lunch to learn about Dimensional Modeling . Go to SQL Lunch and add this event to your calendar or use the link in this posting. To receive notifications about upcoming SQL Lunches please go here . Every week this
Author:
PatrickLeBlanc
Date: 7/21/2010 Section:
Blog
tags :
Warehouse
,
SQL Lunch
Microsoft Business Intelligence Firestarter - Full BI Project Life Cycle
Course Overview This one day seminar provides an end-to-end overview and direction for BI developers, administrators and managers who want to excel at leading high-performance teams and their organization through the Full BI Project Life Cycle (DW,ETL,OLA
Author:
Slava
Date: 2/23/2011 Section:
Blog
tags :
Dashboard
,
DW
,
SSAS
,
SSIS
,
SSRS
,
BI Training
Free Webinar : Multi
dimensional
Reporting: MDX Essentials for Report Design
PASS DW/BI VC Presents: Multidimensional Reporting: MDX Essentials for Report Design Date / Time Date: 2/23/2011 Start Time: 12:00:00 PM End Time: 1:00:00 PM Timezone: (GMT-05:00) Eastern Time (US & Canada) Short Description Learn the fundementals of
Author:
meganathank
Date: 2/23/2011 Section:
Blog
tags :
MultiDimensional Design
,
MDX
SSAS 2008 Storage Modes
In SQL Server Analysis Services 2008, we have three storage mode options available to us: Relational Online Analytical Processing (ROLAP), Multidimensional Online Analytical Processing (MOLAP) and Hybrid Online Analytical Processing (HOLAP). There are adv
Author:
DustinRyan
Date: 7/21/2010 Section:
Blog
tags :
HOLAP
,
MOLAP
,
ROLAP vs. MOLAP
,
SSAS 2008 Storage Modes
,
ROLAP
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.
Author:
AdamJorgensen
Date: 11/24/2009 Section:
Article
tags :
SSAS 2008
,
SSAS Development
,
SSAS Projects
,
DSV
SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. Part of those details were an update on the SQL Server Analysis Services ( SSAS ) roadmap. The main new feature in SSAS is a new d
Author:
jamserra
Date: 6/29/2011 Section:
Blog
tags :
Denali
,
SQL Server
,
SSAS
,
BISM
Hierarchies in SSAS Multi
dimensional
: 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
Intro to MDX at SQL Saturday #130 – Jacksonville, FL
This weekend is SQL Saturday #130 in Jacksonville, FL. On Friday, April 27th, is a great pre-con session by SQL Server MVP, Kevin Kline on Performance Tuning SQL Server 2008 R2. Go here to get registered for this phenomenal opportunity to learn from an un
Author:
DustinRyan
Date: 4/26/2012 Section:
Blog
tags :
free training
,
SQL Saturday
Troubleshooting MDX Queries
In this post I am going to deviate from Hadoop and HDInsight to focus on SQL Server Analysis Services Mutli-dimensional and more specifically MDX queries. As a consultant one of the common issues I encounter more so than design is that of performance. Typ
Author:
cprice1979
Date: 5/7/2013 Section:
Blog
tags :
Analysis Services
,
Performance Tuning
When to choose SSAS over Tabular Model?
I also read the article with great interest. Although there is clearly a strong future for tabular models I am not sure I would count out dimensional modeling just yet. In the 2012 iteration tabular modeling still seems not ready for prime time in many ca
Author:
Daniel
Date: 7/9/2012 Section:
Forum
When to choose SSAS over Tabular Model?
Bill, I agree, in the near future there probably will not be any reason to continue using multidimensional SSAS but a couple scenarios i may still use multidimensional would be: Accounting for forecasting using writeback (tabular doesn't have writeback) M
Author:
DevinKnight
Date: 7/8/2012 Section:
Forum
connect SSAS to a DB2 data source - "The parameter is incorrect"
Hello, I am new to the SSAS world (SQL Server 2008 R2). I have completed some basic tutorials and now trying to work with my own data at work for my first cube development. Background... I am using DB2 as my dimensional data source. I have the appropriatt
Author:
JamieG
Date: 1/23/2013 Section:
Forum
tags :
connection issues
,
connection manager
,
db2
What is Common Interface Format Layout
What he's kind of referring to is a staging table. Basically it's a table that matches the layout of the source. You land all your data into that staging area and then another process moves/modifies that data from staging into your data warehouse/data mar
Author:
sqlchicken
Date: 3/11/2013 Section:
Forum
tags :
Design
,
etl
,
SSIS Package Design
SQL Server Analysis Services Webinar
Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire month of Back to Basics themed free training. This webinar is for anyone trying to understand the basics behind Analysis Services and how to get started design
Author:
DevinKnight
Date: 4/1/2013 Section:
Blog
tags :
Decision Matrix
,
Webinar
Tuning Multi-Dimensional Cube Processing
In my last post ( HERE ) we talked about troubleshooting and resolving issues with problematic MDX queries. In this post we will look at techniques to tune and troubleshoot the processing side of your Analysis Services cube. Understanding Cube Processing
Author:
cprice1979
Date: 5/11/2013 Section:
Blog
tags :
Analysis Services
,
Cube Processing Dimension Attribute
Looking for suggestions on how to incorporate goals into my data warehouse
I am building a new dimensional data warehouse for the financial institution I work for and I need to include goals for various metrics such as 'Percent of Accounts With a Checking Share', 'Average Services Per Member', etc. The goals would be by branch l
Author:
dmarkel
Date: 12/1/2011 Section:
Forum
tags :
goals
,
metrics
Page 1 of 3 (73 items)
<< Prev
1
2
3
Next >>
Go to page:
[Go]