Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Dimensions Rss

   Items 1 to 20 of 20   
 

MDX Guide for SQL Folks: Part I - Navigating The Cube

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.   Read more...
By Frank A. Banin 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 18,671 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,866 reads

Managing Slowly Changing Dimension with Slow Changing Transformation in SSIS

The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,435 reads

MDX Guide for SQL Folks: Part III - Advanced Analysis

Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.  Read more...
By Frank A. Banin 2013/02/14 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 5,335 reads

MDX Guide for SQL Folks: Part II - Hierarchies and Functions

Learn everything about MDX by drawing only on your SQL knowledge.   Read more...
By Frank A. Banin 2012/12/18 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 7,059 reads

MDX Guide for SQL Folks: Part I - Navigating The Cube

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.   Read more...
By Frank A. Banin 2014/06/13 (first published: 2012/11/01) | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 18,671 reads

Functions for using the keys from the Date and Time Dimensions

Three functions for obtaining the date and time dimension keys with a date or the date from the keys  Read more...
By Joshua A. Walker 2011/05/03 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,235 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,866 reads

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005

I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?  Read more...
By Additional Articles 2009/09/15 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,992 reads

Script dimensions using Windows PowerShell and AMO

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.  Read more...
By Additional Articles 2009/05/01 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,441 reads

Functions for using the keys from the Date and Time Dimensions

Three functions for obtaining the date and time dimension keys with a date or the date from the keys  Read more...
By Joshua A. Walker 2011/05/03 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,235 reads

Process Dimensions in an Analysis Service database

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,451 reads

Date Dimensions Part 2

Continuing with his discussion of how to implement a date dimension in SQL Server Analysis services, expert warehousing expert Vincent Rainardi discusses how to use this dimension as a reference dimension as well as other advanced topics.  Read more...
Rating: |  Discuss |   Briefcase | 11,421 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,866 reads

The Date Dimension in Analysis Services

Data warehousing author and expert, Vincent Rainardi, brings us a new article that looks at one of the most frequently used dimensions in Analysis Services.  Read more...
Rating: |  Discuss |   Briefcase | 16,946 reads

MSSQL Analysis Services - Attribute Member Names

Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.  Read more...
By Additional Articles 2008/10/24 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,860 reads

Parent-child dimensions in SQL Server 2005

Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.  Read more...
By Additional Articles 2008/10/10 | Source: SearchSQLServer | Category: dimensions
Rating: (not yet rated)  Rate this |   Briefcase | 3,230 reads

Attribute Member Keys – Pt 1: Introduction and Simple Keys

Join Business Intelligence Architect Bill Pearson as he kicks off an exploration of Attribute Member Keys, a continuation of a body of articles surrounding significant components of the Analysis Services dimensional model. In this article we introduce Attribute Member Keys, focusing upon the simple keys and their properties.  Read more...
Rating:  Rate this |   Briefcase | 1,983 reads

Many-to-Many Dimensions in Analysis Services 2005

See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.  Read more...
By Additional Articles 2008/06/27 | Source: TechNet Blogs | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,255 reads

Dimension Attributes: Introduction and Overview, Part III

Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we continue our introduction to dimension attributes, focusing upon the Misc group of attribute properties.  Read more...
By Additional Articles 2008/05/29 | Source: Database Journal | Category: business intelligence
Rating:  Rate this |   Briefcase | 908 reads
   Items 1 to 20 of 20   
 
Tags
analysis services (ssas) (10)    
mdx (5)    
cube (4)    
hierarchy (3)    
olap (3)    
amo (2)    
data warehousing (2)    
datawarehouse (2)    
datetime (2)    
powershell (2)    
business intelligence (1)    
date manipulation (1)    
integration services (ssis) (1)    
proclarity (1)    
rdbm (1)    
security (1)    
sql server 2008 (1)    
xmla (1)