Process Models & Database Deployment

SQL Server 2014
  • 9 Videos | 58m 33s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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 dimensions
    describe the different processing options available for SSAS objects, specifically full processing and incremental processing
    automate the processing of SSAS objects using AMO
    use XMLA to process SSAS objects
    use PowerShell to process and manage partitions
  • implement remote processing of SSAS objects
    use the deployment wizard to deploy an SSAS database
    test a database deployment
    use the Synchronize Database Wizard to synchronize metadata and data between two SSAS databases

IN THIS COURSE

  • Playable
    1. 
    Defining How SSAS Objects are Processed
    7m 26s
    UP NEXT
  • Playable
    2. 
    Understanding Processing Options for SSAS Objects
    5m 48s
  • Locked
    3. 
    Automating SSAS Objects Processing Using AMO
    7m 47s
    FREE ACCESS
  • Locked
    4. 
    Processing SSAS Objects Using XMLA
    5m 57s
    FREE ACCESS
  • Locked
    5. 
    Processing Partitions Using PowerShell
    8m 11s
    FREE ACCESS
  • Locked
    6. 
    Implementing Remote Processing of SSAS Objects
    5m 18s
    FREE ACCESS
  • Locked
    7. 
    Using the Deployment Wizard to Deploy Databases
    6m 12s
    FREE ACCESS
  • Locked
    8. 
    Testing a SSAS Database Deployment
    3m 41s
    FREE ACCESS
  • Locked
    9. 
    Using the Synchronize Database Wizard
    4m 14s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

COURSE Troubleshooting SSAS
Likes 8 Likes 8  
COURSE Designing Multidimensional Models
Likes 7 Likes 7  
COURSE Managing Tabular Data Models
Likes 11 Likes 11