You might be engaged on a BI undertaking that entails SSAS Tabular mannequin. As you can’t course of the mannequin manually it is advisable to develop an answer to course of the mannequin mechanically. There are two situations right here:

1. You’ve got an up and working SQL Server Integration Providers (SSIS) occasion: On this case you may construct a SSIS bundle to course of the Tabular Mannequin.
2. You should not have an SSIS occasion prepared on the server: So it is advisable to create a SQL Server Agent Job.

On this publish I’m expressing straightforward methods to resolve the issue primarily based on the above situations.

Comply with the steps beneath:

1. Create a brand new SSIS undertaking utilizing (SQL Server Information Instruments) SSDT
2. Proper click on on the “Connection Managers” space and choose “New Evaluation Providers Connection”

1. Click on “Edit”
2. Enter the SSAS Tabular server
3. Go away “Location ” BLANK! You may face the next error: “A connection can’t be made. Be certain that the server is working.”
4. Click on “Use Home windows NT Built-in Safety”
5. Choose your SSAS Tabular catalog from the listing. In my case it’s Journey Works
6. Click on OK
7. Put a “Evaluation Providers Processing Process” on Management Circulation and double click on on the duty
8. Go to Processing Settings
9. Choose the Evaluation Providers Connection
10. Click on “Add”
11. Tick the database and click on OK
12. You must see one thing just like the picture beneath within the “Evaluation Providers Processing Process Editor” window. Be aware that the article sort is “Database”.
13. Click on OK

Now you may run the bundle by urgent F5 and your SSAS Tabular mannequin might be processed.

Now it is advisable to deploy the SSIS undertaking to SSIS Catalog after which create a SQL Server Agent Job to run the SSIS bundle in a single day.

On this case it is advisable to use SSMS to generate the XMLA scripts for processing the Tabular mannequin. To take action comply with the beneath directions:

1. Open SSMS and hook up with a Tabular Evaluation Providers server and develop “Databases”
2. Proper click on on a desired database and choose “Course of Database”
3. In “Course of Database” window choose the processing mode from the dropdown listing

1. Click on on the small rectangle of the “Script” button and choose “Script Motion to New Question Window”
2. When you do NOT have to course of the database now click on on “Cancel” button
3. The wanted XMLA scripts is generated in SSMS
4. Copy the generated XMLA code
5. In SSMS hook up with the SQL Server occasion that you simply need to outline a brand new SQL Server Agent job for processing the Tabular database
6. Create a brand new job by proper clicking on “SQL Server Agent” and deciding on “New” after which “Job”
7. Sort a descriptive identify for the brand new job and go to steps and click on New to create a brand new step
8. Sort a reputation for the step
9. In Sort part choose “SQL Server Evaluation Providers Command” from the dropdown listing
10. Sort within the Tabular mannequin server tackle within the “Server” part
11. Now paste the XMLA script that you simply’ve copied earlier than after which OK

All carried out!

Now you may run the job and your Tabular mannequin might be processed.

NOTE: Don’t forget to outline a schedule for working the job steadily. As defining a brand new job is out of scope I didn’t clarify it intimately.