I am writing a fairly basic report in Deski (XI R2) and want to add a condition to the report where an object is “in list”
Rather than the user typing the values in a prompt (as the values will be dynamic) is there any way of selecting a list of values from an Excel spreadsheet that is maintained locally on a users pc?
I have had a look around the different forums and cant seem to find anything, but I have a vague recollection of us doing something similar in the past with BO 6.1.3
You can use the columns in Excel as the objects in your report. But if you want these objects in the prompt, then you need to create a universe out of your excel source as suggested already.
Read this Universe Design using the Excel sheet
Thank you for your help, I dont have to have a prompt and dont really want to create a universe for the Excel spreadsheet as this is massive overkill. The user is sent an Excel list of product codes and wants to use this as the source for the condition…
“Product Code in list [excel list]”
How can I use the columns in Excel as conditions in my report? I have looked but cannot see how this can be done!
Create a data provider to bring in the Excel sheet.
Then in your query on the universe have your condition as
Object Name in list …
choose Query Results or whatever it’s called - I’m at a Webi shop these days, but it’s in the list of options - and choose the object you want from your Excel data provider.
(BOB member since 2007-04-11)
(BOB member since 2009-10-08)
All working fine