External Database Connection for Dashboard - Data Volume Restriction

If they are looking for a data dump, why even show it in OneStream? Why not just create a dashboard button and make a rule that writes it into an EXCEL file and downloads the file with the same button?

The problem with a data adapter approach is it will bring all the data at once and then show it. You can use a Large pivot grid which will support paging. However, since the purpose is a data dump, this approach is not practical.

Even Table View is not going to work since you have a large number of records to deal with. I've seen clients always asking for this, and I've always questioned why you need it. In most cases, the user runs a pivot grid and performs a sum. Which is what OneStream is doing, so why? Is it that you don't trust the system?