I'm trying to make a table box with two fields from the same .qvd and I cannot get it to load. I can get one of them to load, but when I try and add another field (doesn't seem to matter which), it fails to load and tells me "Out of object memory." I've tried this with up to 36gb of RAM and it always fails. Really stumped right now... Thanks for the help!
Look at the table viewer. How many tables are there? Are they all associated or do you have data islands (unconnected tables)? Unconnected tables mean a cartesian product if you use two fields from different tables in one table box. That can be really bad for performance.
And showing 4 million records in a table box doesn't make much sense either. Try making some selections first. Nobody is capable of analysing 4 million records individually in reasonable time.
Agreed that showing 4 million records doesn't make sense, but we're trying to build a dashboard so that other controls get you narrowed down to a point where the table box shows a smaller, meaningful number of records.
Six tables - all connected. The table that I am pulling from has four connections, but they are all dashed lines with arrows going to it, and not the solid lines that the other tables have between them. Not sure what that difference means or if it's important.
Yes, I do get a notice for a loop when I reload the data. It's saying that one or more tables will be loosely coupled (which, I assume, is what the dashed lines mean?)
