We use OLAP cubes and I am wondering if there is a way to specify the data
returned based on a separate list. For example, we have thousands of
products and I will get a list of say 20 specific products that someone needs
a report on. Is there a way that I somehow link this list to the product
field in my OLAP cube and have it return only the products that are in my
list? Otherwise, I have to go through the products field and select each one
individually €“ which can be very time consuming.
Any thoughts/suggestions would be greatly appreciated!