Process Models & Database Deployment
SQL Server 2014
| Intermediate
- 9 Videos | 54m 33s
- Includes Assessment
- Earns a Badge
After creation, multidimensional models need to be processed and the databases deployed for users to access them. Examine what is involved in processing data models and deploying SSAS databases.
WHAT YOU WILL LEARN
-
describe how processing and reprocessing affects SSAS objects, specifically partitions, databases, cubes, and dimensionsdescribe the different processing options available for SSAS objects, specifically full processing and incremental processingautomate the processing of SSAS objects using AMOuse XMLA to process SSAS objectsuse PowerShell to process and manage partitions
-
implement remote processing of SSAS objectsuse the deployment wizard to deploy an SSAS databasetest a database deploymentuse the Synchronize Database Wizard to synchronize metadata and data between two SSAS databases
IN THIS COURSE
-
1.Defining How SSAS Objects are Processed7m 26sUP NEXT
-
2.Understanding Processing Options for SSAS Objects5m 48s
-
3.Automating SSAS Objects Processing Using AMO7m 47s
-
4.Processing SSAS Objects Using XMLA5m 57s
-
5.Processing Partitions Using PowerShell8m 11s
-
6.Implementing Remote Processing of SSAS Objects5m 18s
-
7.Using the Deployment Wizard to Deploy Databases6m 12s
-
8.Testing a SSAS Database Deployment3m 41s
-
9.Using the Synchronize Database Wizard4m 14s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.