ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   OLAP €“ returning data from a separate list (https://www.excelbanter.com/excel-discussion-misc-queries/241328-olap-%E2%80%93-returning-data-separate-list.html)

shairal

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!



All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com