Scheduling a DIMENSION Process Job
Hi All i a have a daily job that runs at 2am, this job extracts the data from the source and then reprocess the CUBES, of lately we are getting the following error: 'WBBindings' required element is missing under /Partition at line 1, column 405 and one interesting that i noticed was that if i process the DIMENSION the night before , the 2am job runs great, i'm still confused why its like that any ideas? Now i want to know how should i schedule a job that first processes the DIMENSIONS and then the CUBE? Please any help will be great. Thanks
May 16th, 2012 10:07am

There appears to be the workaround: http://social.msdn.microsoft.com/Forums/fi-FI/sqlanalysisservices/thread/66e93950-0763-4a65-9ffd-94224be3f89dArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 10:55am

Thanks Arthur, this is what i did. On the DEV server there is a package called CUBE process, i opened the package and added another "Analysis Services Processing Task" control item and selected all the DIMENSIONS that needs to processes before the CUBE process takes place and places both the DIMENSION PROCESS task and the CUBE PROCESS task in a container. Now how should i execute the task ? just select the container and click on the green arrow ( i did it and nothings happening). I'm doing all this in BIDS. Please need advice. Thanks
May 16th, 2012 11:04am

If you are doing this in BIDS, then why just not to run the entire package (F5)?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 11:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics