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