We are piloting use of Ideas for a new use case. Many of the older ideas have Team\Allocations identified and these show in the DWH/Ad-hoc reports just fine.
Problem is that for new ideas create during this pilot, none of the Team\Allocations are showing in the DWH.
Only difference I can find between those ideas that have Team\Allocations in DWH and those that don't is that those Ideas that don't have used Staff OBS field to identify the department that the role/resources shall be supplied from. Maybe this is a red herring - I'm currently testing this by removing Staff OBS content for some resources on an Idea, and I've got the Load DWH job running in incremental mode, now.
Any other ideas? Perhaps a timeslice isn't really getting refreshed and so Load DWH job doesn't detect a change, therefore the new stuff isn't loaded?
Problem resolved by CA Support.
Load Datawarehouse job was failing due to a field size limitation. The failure occurred part way through the job's run - after updating investment metadata, before updating time based data (hours, costs....). CA Support sent us a patch, possibly from 14.3 as we are on 14.2. All good, now.