Our Data Warehouse/Mart is using DB2 Partitioning.
Outside of always using prompted reports, which work fine,
how do you "join" correctly to get the SQL to include the
use of the "part_nbr" (partition number) correctly?
This becomes an issue when creating a general report or cube
without prompts.
Outside of always using prompted reports, which work fine,
how do you "join" correctly to get the SQL to include the
use of the "part_nbr" (partition number) correctly?
This becomes an issue when creating a general report or cube
without prompts.