Skip to Content
0
Former Member
Aug 04, 2009 at 08:34 PM

Add a U type dim to a DM Package

32 Views

I am trying to add a U type dimension to the prompt for a DM package. But I only seem to be able to add dims which are already defined in the "Dynamic Constants" section in the Script Editor (Entity_dim, Category_dim, etc.). I can find no way to get any other dimensions in that list, so I can prompt the user for them. I have tried adding the dim to the system constants, adding a variable to the SSIS package, all sorts of tricks, no luck. Any ideas? This is a package which just runs some logic to call a stored procedure, so everything else works well.

THanks,

Paul