1 person found this helpful
I've posted a starter SQL here:
Then you take the ranges of accounts (with the help of a finance person) and you map them in the CSV file. It's a domain file because you aren't sourcing the group mappings from your financial system -- you are 'making them up' to work with OBIA. Those Group Account Nums are used throughout the ETL & RPD (in logical columns) to rollup individual account based data.
Thanks for the information.