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


