Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLAP returning data from a separate list
I posted this question under Excel General Questions, but its 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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLAP returning data from a separate list
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. "Shairal" wrote: I posted this question under Excel General Questions, but its 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP returning data from a separate list | Excel Discussion (Misc queries) | |||
Create separate list of only selected data | Excel Discussion (Misc queries) | |||
Data Validation from list on separate Workbook | Excel Discussion (Misc queries) | |||
Returning all data from a list above the nth percentile | Excel Worksheet Functions | |||
Returning a value if data is in a large list | Excel Discussion (Misc queries) |