We have a data warehouse with summary and detail level data with Cognos as the reporting tool. If we have data for 100 large customers loaded in the fact tables and are trying to use Cognos Query Studio. Here is the scenario: one user has access to data for 5 customers through the security layer and another user has access to data for 25 customers. Assuming the volume of data and other factors are the same per customer, should the query performance be slower for the user exposed to data for 25 customers versus the user with 5 customers? If both users are using a customer select prompt and choosing 4 months of detail data, will the user with exposure to more customers have a longer response time?
Software/Hardware used: Cognos Query Studio and SQL Server