script to denormalize for reporting and corresponding changes in install.sh