| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
OLAP €“ returning data from a separate list
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning a list of data and only including in the chart if choose | 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) | |||
Hybrid Mode
