Whilst I can go and build them natively in the DB it feels like that is a couple of extra steps to achieve the same outcome:
- Build the view in DB
- Create 'external' BO in AIM
- Build the view in AIM
- Repeat the process for the Prod version
Or, am I doing the whole thing wrong? Bruce, I am expecting you to evangelise for Stored Procs at this point