AnsweredAssumed Answered

Some Idea Allocations not available DWH

Question asked by Dale_Stockman Champion on Mar 9, 2016
Latest reply on Mar 21, 2016 by Dale_Stockman

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.


  • Yes, DWH timeslices cover the allocation periods used in the Ideas
  • Yes, Load DWH job has been run after the team allocations were established.
  • Looking at calendar periods, not fiscal - so Financial settings are not pertinent (I have Ideas with calendar allocation data showing up in DWH, just fine, with Financial settings blank)


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?