September 4, 2002 at 12:30 pm
I have followed word for word the documentation on how to create a DTS package to process a cube. The intention ofcourse is to create a scheduled job to refresh the cube each night.
The step says it is successful, but I when I go to look at the cube, there is no change from the previous time.
My DTS pkg is structured such that I truncate table A, repopulate table A, and then execute an "Analysis Services Processing Task". I set the task to do a full process on the cube I am interested in, which is based on table A. Again execution says successful so there are no error messages to trouble shoot this.
Remember this when a developer tells you it will just be temporary. Temporary = Permanent.
September 4, 2002 at 4:29 pm
Be sure to do a REFRESH on the cube database. One other note: If you have the cube processing in its own DTS package and you are executing this package from another package it will not work. The Cube DTS package has to run in its own schedule for some reason. If you run the DTS package manually it should run fine.
Hope this helps,
Skip Gallagher
Quest Industries, Inc.
(479) 685-4546
Skip Gallagher
Quest Industries, Inc.
(479) 366-0789
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply