OLAP – returning data from a separate list

S

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!
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top