Post reply

DTS OLAP options limited?

  • March 12, 2004 at 2:34 pm

    #59245

    I have a virtual dimension that I want to process via DTS.  When I right-click in Analysis Manager, I can select full or incremental.  When I create an OLAP task in DTS and point to the same dimension, the incremental option is greyed out.  If I use disconnected edit to change the ProcessingOption to incremental (2), the edit attempt errors off with "invalid processing option" (when editing the package). 

    Suggestions?

    Thanks,

    Larry

    Larry

  • March 15, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 17, 2004 at 4:22 pm

    #499229

    Have you already ran at least one full processing yet? If yes, have you recently changed the structure of any dim tables? I would try to run a full process, then go into DTS and see if you are able to select incremental.

    HTH

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply