Home  >  Blog  >   MSBI

SSAS Analysis Services Cube Deployment Methods

Rating: 5
  
 
10111
  1. Share:
MSBI Articles

SSAS Cube Deployment

There are many to deploy cube objects (or) cubes
  1.  BIDS (BUSINESS INTELLIGENCE DEVELOPMENT STUDIO)
  2. Deployment wizard
  3. XMLA Script
  4.  Synchronize Database wizard
  5. Backup and Restore
  6. Analysis Management Objects(AMO)
Option       Recommended Use
BIDS      Deploying the latest changes to your local server for                                                           Testing
Deployment Wizard      
Deploying to a Test (or) production environment when                                                        you need more granular control
XMLA Script                                 
Scheduling a Deployment task
Scheduling a Deployment taskSynchronize database wizard 
synchronizing two cubes, such as a staying cube and a production cube
Backup and RestoreMoving a cube from one server to another

Analysis management objects(AMO

Handling deployment programmatically

MindMajix Youtube Channel

BIDS:

SOLUTION EXPLORER → PROJECT (TEXT__FACT) → RC → PROPERTIES →

Build

Output path:- bin/

Deployment

Options

Processing option: Default

Transactional deployment: Fal

Target

Server:

Database:  Text__fact__cube__DB

OK

Deployment wizard:

Deployment wizard

                    Now the “analysis service database” deploys in the specified in the server.

Note:- This wizard deploys (.as database) analysis services database file, as created in the output directory by project build

Using XMLA Script:

  • XMLA refers to “XML for analysis services”
  • This is the frequently used mechanism in real-time.
  • It contains cube name, server name, dimension, fact tables, and their attribute names, etc..Objects information.

 

Checkout SSAS Interview Questions

 

Related Page: How to Create Cube in SSAS

This information is used to modify/add current /new settings.

1) Navigation:-  (Creating a SMLA Script file)

Navigation

Go to the file & monitor the Details.
 
2) Using XMLA Script:-
  • Go to XMLA script file
  • Do the changes whatever required, save file
  • SSMS → open → file → specify XMLA script file path → open
  • Execute the script
  • Observe the cube database in the specified server according to the settings.
 

Backup and Restore

a) BACKUP:- SSMSà analysis services à cube database à RC backupà

backup file: 9AM new.abf Browse

Password: VINAY

CONFIRM password: VINAY à ok

b) RESTORE:- Analysis services → Database → RC → Restore-

Backup file: Browse to 9 AM – new abf

Restore database: VINAY _ 9AM_NEW

Password: VINAY                       
 

Explore SSAS Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 

List of Related Microsoft Certification Courses:

 SSIS Power BI
 SSRS SQL Server
 SCCM SQL Server DBA
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
MSBI TrainingMar 23 to Apr 07View Details
MSBI TrainingMar 26 to Apr 10View Details
MSBI TrainingMar 30 to Apr 14View Details
MSBI TrainingApr 02 to Apr 17View Details
Last updated: 03 Apr 2023
About Author

As a content writer and storyteller, Raunaak Mitra regards himself to be a prodigy in writing. He firmly believes that language is borderless, and anyone can write as long as they have a strong narrative capability and the ability to emote feelings into words. Authors like F. Scott Fitzgerald and R. K. Narayan have influenced him to keep the writing as simple as possible for anyone to understand. Other than being well-versed about technological trends like AI, Machine Learning, AR, VR, Gaming, Microprocessors, Cloud Computing, Industry 4.0, literally any technological advancement (old or new), he also shares a knack to curate fiction on sci-fi, satire, and thriller genres.

read more
Recommended Courses

1 / 15