1 DAX

2 MDX

3 참고자료

• DAX Calculate the Max for a Group
  
  

• Counting Consistent Customers in MDX
  
• Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions
  
• MDX Guide for SQL Folks: Part III - Advanced Analysis
  
• http://www.reportportal.com
  
• MDX - 용어와 개념
  
• Configuring HTTP Access to SQL Server 2008 Analysis Services on Microsoft Windows Server 2008
  
• 디자인 경고 규칙
  
• Using SSRS to report SSAS 2008 database structure using DMVs SSAS.DMV.sql 원본
  
  
  
• tools
  
  • http://code.google.com/p/ranet-uilibrary-olap/downloads/detail?name=Ranet.UILibrary.Olap-1.3.3.0-6571.msi&can=2&q=
    
  • http://code.google.com/p/galaktikabusinessmonitor/downloads/detail?name=Galaktika.BusinessMonitor-4.5.461.0.msi&can=2&q=
    

• IIS(인터넷 정보 서비스) 8.0에서 Analysis Services에 대한 HTTP 액세스 구성
  
• Introduction to MDX for PowerPivot Users, Part 5: MDX Queries
  
• Introduction to MDX for PowerPivot Users, Part 4: Filtering
  
• MDX Guide for SQL Folks: Part I - Navigating The Cube
  
• Free MDX Training Video Now Live
  
• Returning Selected Items in an Excel Slicer Using MDX in PowerPivot and SSAS
  
• Letting More Developers Dance with Elephants: What We Learned
  
• Named Sets and Block Computation in SSAS 2012
  
• Controlling the Position of Subtotals in DAX with GenerateAll()
  
• Analysis Services PowerShell Provider (SQLAS) in SQL Server 2012
  
• Natural and Unnatural Hierarchies in the SSAS 2012 Tabular Model
  
• SSAS Best Practice 2011
  
• Aliasing Columns in DAX
  
• 클라이언트PC 엑셀에소 전송계층 오류시
  
• Solving the Events-In-Progress Problem in DAX V2.0
  
• DAX Queries, Part 1
  
• DAX Queries, Part 2
  
• DAX Queries, Part 3
  
• DAX Queries, Part 4
  
• DAX Queries, Part 5
  
• DAX Queries, Part 6
  
  
• SQL Server 2008 R2 Analysis Services Performance Guide
  
• SQL Server 2008 R2 Analysis Services Operations Guide
  
• Replacing Linkmember with a Many-to-Many Relationship
  
• Open source BI
  
• http://ssas-wiki.com/w/Articles
  
• http://www.olap4j.org/
  
• Analysis Services Distinct Count Optimization
  
• SQL Server 2008 White Paper: Analysis Services Performance Guide
  
• Roadmap for SQL Server “Denali” and Beyond
  
• Using XMLA Command to Clear Cache of an Analysis Service Database
  
• Adding Actions to a Cube in SQL Server Analysis Services 2008
  
• How to restore an Analysis Services Database
  
• Microsoft Win2003에서 SQL Server 2005 Analysis Services에 대한 HTTP 액세스 구성
  
• http://www.bidn.com/
  
• Explore filtered models in SQL Server 2008
  
• A Decision Tree inside out
  
• A Neural Network in SQL Server
  

SQIAR (http://www.sqiar.com) is a leading global consultancy which provides innovative business intelligence services to small and medium size (SMEs) businesses. Our agile approach provides organizations with breakthrough insights and powerful data visualizations to rapidly analyse multiple aspects of their business in perspectives that matter most. -- Sqiar 2013-11-16 09:53:19