I am working on a report for a client which is running from a Jet cube based on Inventory items. The cube includes a URL pointing to a picture file for each item. The images are held in a separate location.
When running the report, it appears that a majority of the report run time seems to be devoted to pulling in the images from the URL.
From a report performance perspective, would it be more efficient to load the images directly into the cubes and bypass the URL altogether? My guess is yes, but I am wondering if there are other downsides that I need to consider (both from a cube and report perspective).
Any suggestions?