Olap cube processing
1. The olap cube and the dimensions has to be prcessed to have the updates.
2. This can be done manually or automatic.
3. Manual process --- to open sql server management studio, connect to analysis services, click on the analysis database dimensions first --- dimensions will be listed on the explorer details window on the side, select all right click and process.
4. Now click the dimension --- right click and process.
5. If there are errors in processing please check you data first, for example primary key validation, datetime format.
1. The olap cube and the dimensions has to be prcessed to have the updates.
2. This can be done manually or automatic.
3. Manual process --- to open sql server management studio, connect to analysis services, click on the analysis database dimensions first --- dimensions will be listed on the explorer details window on the side, select all right click and process.
4. Now click the dimension --- right click and process.
5. If there are errors in processing please check you data first, for example primary key validation, datetime format.
Now let us see how to automate the process.
1. Using the manual process above click on script to generate the scripts. copy in a notepad.
2. Open microsoft sql server management studio.
3. Connect to the database.
4. Open sql server agent.
5. Click on jobs --- right click and click on new job.
6. Clcik on general --- enter the name of the job, please not you should rights on the database to perform this job.
7. Now click on the step --- click new step, enter the step name, select the type as sql server analysis services command , under run as -- select sql agent service account, now copy the scipt under the command, click ok
8. Click on the schedule -- schedule it.
9. Click on notifications --- select the mail to be notified if the job fails.
No comments:
Post a Comment