Passing only selected accounts into the report
I'm trying to create a webi report based on customer master data and am required to fetch information regarding selected accounts only (approx 200,000 accounts), Had it been few handful accounts, i'd use query filter to just bring results for desired accounts but this is way too much info to select from the list of values manually. I'm positive there's a better efficient way to achieve this result which I can't seem to figure it out at all. Can some one please help me with this ?
btw, I've been provided with an excel sheet containing list of accounts required for the report. Can you create two queries (one for customer master data from universe and the other for only required customer accounts from excel) and merge them to filter the report, is that possible ?
I'd really appreciate any insight/thoughts on this .