SSAS Analysis Services Cube Deployment Methods

SSAS Cube Deployment

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)

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:

                    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)

• 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                       
 

List of Related Microsoft Certification Courses: