The particular problem that I'm having that Oracle is looking at is if I do something simple like:

select customer_name, customer_number
from customer_dim
where source_system = 'tms_frc' (only 0.4 % of the table)

It will not use the bitmapped index, even on very highly selective values. If I use a btree instead, the index works as you would expect it to.