OLAP – returning data from a separate list

[Shairal]

I posted this question under Excel General Questions, but it’s probably more
of a programming question … hopefully someone can assist me.

We use OLAP cubes created from SQL/SSAS and I am wondering if there is a way
to specify the data returned in the OLAP cube 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!

 

[Patrick Molloy]

i'm not sure about how yuo hold the data in memory, but if it were a
recordset, then you could apply a filter

rst.Filter = "productCode = '" & range("a1") & "'"

for example.