DTS cube processing not working

  • 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.

  • 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