We are just beginning to use Oracle Analytics. We manage large amounts of data and much of what my team does is runs queries for lists of items. This can be 10, 100, or 1000s of different item numbers. We do not want to hand select the items in the filter. I created a dataset from an Excel spreadsheet for a list of items and have successfully been able to run one of the queries for that list of items but how do I update the item list for the next query? We used to use Access and we could just copy and paste the items into a table and run them and then copy and paste a new list of items into the table and run those.
Cannot copy and paste into the dataset