Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Getting Started with SQL Server 2012 Cube Development

You're reading from   Getting Started with SQL Server 2012 Cube Development Learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach with this book and ebook

Arrow left icon
Product type Paperback
Published in Sep 2013
Publisher Packt
ISBN-13 9781849689502
Length 288 pages
Edition 1st Edition
Languages
Concepts
Arrow right icon
Author (1):
Arrow left icon
Simon Lidberg Simon Lidberg
Author Profile Icon Simon Lidberg
Simon Lidberg
Arrow right icon
View More author details
Toc

Table of Contents (17) Chapters Close

Getting Started with SQL Server 2012 Cube Development
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Self-service Business Intelligence, Creating Value from Data FREE CHAPTER 2. Installing SSAS and Preparing for Cube Development 3. Creating Your First Multidimensional Cube 4. Deploying and Processing Cubes 5. Querying Your Cube 6. Adding Functionality to Your Cube 7. Securing Your Cube Project 8. Using Aggregations to Performance Optimize a Cube 9. In-memory, the Future 10. Cubes in the Larger Context Index

Deploying objects to Analysis Services


Everything that you have so far written and configured using the graphical interface has generated code. This code is in the Analysis Services Scripting Language (ASSL) code that is part of the XML for Analysis (XMLA) language used by Analysis Services and is right now stored as part of your project in SQL Server Data Tools. Deployment is the process where these commands get sent to the Analysis Services server, and where the objects you have configured get created.

Tip

For more information about XMLA and ASSL, refer to the following links:

http://msdn.microsoft.com/en-us/library/ms186604.aspx

http://msdn.microsoft.com/en-us/library/ms128525.aspx

If you want to view the code that is generated, you can always right-click on any object in the Solution Explorer window and choose the View Code option.

A common way of doing deployment is through the Deploy menu that you find in the Build menu in SQL Server Data Tools window. This will send the deployment script...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image