Multidimensional_Model_Programming.pdf

(4750 KB) Pobierz
1112037314.001.png
Multidimensional Model
Programming
SQL Server 2012 Books Online
Summary : Analysis Services provides several APIs that you can use to program against
an Analysis Services instance and the multidimensional databases that it makes
available. This section describes the approaches available to developers who want to
create custom applications using Analysis Services multidimensional solutions. You can
use this information to choose the programming interface that best meets the
requirements of a particular project. Analysis Services development projects can be
based on managed or non-managed code that runs on a Windows platform, or other
platforms that support HTTP access.
Category: Reference
Applies to : SQL Server 2012
Source : SQL Server 2012 Books Online ( link to source content )
E-book publication date : January 2013
1112037314.002.png
Copyright © 2012 by Microsoft Corporation
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means
without the written permission of the publisher.
Microsoft and the trademarks listed at
Microsoft group of companies. All other marks are property of their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and events
depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,
logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without any
express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors
will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
Contents
Database Objects ...............................................................................................................................13
Security Roles ......................................................................................................................................15
Dimensions...........................................................................................................................................20
Attributes and Attribute Hierarchies...........................................................................................26
Attribute Relationships ....................................................................................................................27
User Hierarchies..................................................................................................................................29
Write-Enabled Dimensions.............................................................................................................35
Dimension Translations ...................................................................................................................36
Database Dimension Properties...................................................................................................37
Proactive Caching (Dimensions)...................................................................................................41
Cube Properties ..................................................................................................................................42
Dimension Relationships.................................................................................................................44
Calculations ..........................................................................................................................................49
Partitions ...............................................................................................................................................50
Perspectives .........................................................................................................................................59
Cube Translations ..............................................................................................................................61
Cube Cells .............................................................................................................................................62
Cube Storage.......................................................................................................................................65
Establishing Secure Connections in ADOMD.NET.............................................................. 120
Working with Connections and Sessions in ADOMD.NET .............................................. 127
Performing Transactions in ADOMD.NET.............................................................................. 130
Working with the ADOMD.NET Object Model .................................................................... 136
Working with Schema Rowsets in ADOMD.NET ................................................................. 137
Retrieving Data Using the CellSet............................................................................................. 141
Retrieving Data Using the AdomdDataReader.................................................................... 143
Retrieving Data Using the XmlReader..................................................................................... 147

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin