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

Content with tags Analysis Services (SSAS), Dimensions Rss

   Items 1 to 10 of 10   
 

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,020 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 | 6,724 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 2012/11/01 | Source: SQLServerCentral.com | Category: mdx
Rating: |  Discuss |   Briefcase | 12,600 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,920 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,405 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,282 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,675 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,197 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,961 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,234 reads
   Items 1 to 10 of 10   
 
Tags
cube (4)    
mdx (4)    
hierarchy (3)    
olap (3)    
amo (1)    
date manipulation (1)    
powershell (1)    
proclarity (1)    
rdbm (1)    
security (1)