Below is a screenshot of a very common type of Hyperion Brio workbook. This workbook does three things.
-
Queries, transforms, and pivots
-
Generates nice looking reports for end users (Excel won't do here. I'd include a report but need to keep the data private)
-
Bursts the reports and sends to end users. (Like 400+ end users)
Item one is done nicely by current Toad Data Point. The second and third item can only be done by Toad Data Point Classic. Its rather awkward to have to go back and forth between the two. The Analysts at this company do a combination of exploratory AND advanced automated report generation. They have hundreds of Brio workbooks like this.
If anyone else out there is converting from Brio to Toad and have this or similar issue please chime in!