Sounds like a nightmare.<p>You were definitely on the right track to set up an ODS and then stand up a DW in front of that. Looks like you were firmly stuck in the &quot;not allowed&quot; camp and trying to work around absurd limitations.<p>&gt; PS, they are looking for a BI guy...<p>No thanks.<p>I&#x27;m spoiled by being a consultant. Anyone who wants to pay our rates is already committed to making changes.