Browse the analysis server using SQL server management studio.
Right Click on your Database on the analysis server, and click process.
On the dialog window, cllick the 'Script' Button. Copy this script (in the window below) to the clipboard.
Connect to the relation database (SQL server), and make a New Job and task in the SQL Server Agent.
Create a step in the task that is of the type Analysis Service Command. Paste the script to the window, and fill in the url to the analysis server (AS), and the name of the database in AS.
https://www.youtube.com/watch?v=7UlrhCAA_48
Right Click on your Database on the analysis server, and click process.
On the dialog window, cllick the 'Script' Button. Copy this script (in the window below) to the clipboard.
Connect to the relation database (SQL server), and make a New Job and task in the SQL Server Agent.
Create a step in the task that is of the type Analysis Service Command. Paste the script to the window, and fill in the url to the analysis server (AS), and the name of the database in AS.
https://www.youtube.com/watch?v=7UlrhCAA_48
Ingen kommentarer:
Send en kommentar