Skip to Content
0
Former Member
May 29, 2008 at 11:38 AM

Can I link a query with an Excel file without using universe designer?

17 Views

Post Author: nicmac3030

CA Forum: WebIntelligence Reporting

I have an Excel file that contains a list of 200 seller codes. The list is updated on a weekly basis.

I need to create a query in Webi that shows ONLY those records in our main table that match one of the seller codes on the Excel list.

Is there an easy way of doing this? I don't really want to hassle our universe designer guy with a new file to import every week. But if that's the only way to do it, we will have to.

Back in BO v5 we used an Excel macro to add all the codes into a long text string with commas & pasted that into the query designer. Unfortunately there are many queries that need to be updated, so hopefully there's a way to automate this.

Thanks for your help. Cheers, Nick