UsingDirectQueryintheTabularBISemanticModel.docx

Using DirectQuery in the Tabular BI Semantic Model  PAGE \* ArabicDash \* MERGEFORMAT  Using DirectQuery in the Tabular BI Semantic Model SQL Server Technical Article Writer: Cathy Dumas, Business Intelligence Consultant, Avantage Partners. Contributors: Marius Dumitru, Akshai Mirchandani, Edward Melomed, Karen Aleksanyan, Bob Meyers, Siva Harinath Technical Reviewers: TK Anand, Greg Galloway, Marius Dumitru, Edward Melomed, Willfried F?rber, Alberto Ferrari Published: April 2012 Applies to: SQL Server 2012 Summary: This paper introduces DirectQuery, a mechanism for directly querying a SQL Server data source for Analysis Services tabular models. Readers will learn when and how to use DirectQuery in SQL Server 2012.  Copyright This document is provided “as-is”. Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. You bear the risk of using it. Some examples depicted herein are provided for illustration only and are fictitious.? No real association or connection is intended or should be inferred. This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes. ? 2012 Microsoft. All rights reserved.  Table of Contents  TOC \o 1-3 \h \z \u  HYPERLINK \l _Toc320705913 Copyright  PAGEREF _Toc320705913 \h 2  HYPERLINK \l _Toc320705914 Introduction  PAGEREF _Toc320705914 \h 5  HYPERLINK \l _Toc320705915 Sample data  PAGEREF _Toc320705915 \h 5  HYPERLINK \l _Toc320705916 DirectQuery benefits  PAGEREF _Toc320705916 \h 6  HYPERLINK \l _Toc320705917 DirectQuery limitations  PAGEREF _Toc320705917 \h 6  HYPERLINK \l _Toc320705918 DirectQuery architecture  PAGEREF _Toc320705918 \h 7  HYPERLINK \l _Toc320705919 How the DirectQuery architecture differs from ROLAP  PAGEREF _Toc320705919 \h 8  HYPERLINK \l _Toc320705920 Creating a