simple (?) dimension filtering question
This is a discussion on simple (?) dimension filtering question within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> What are the possibilities of DW/OLAP design which will provide an option to filter results based on exclusivity of ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:05 PM
| ||||
| ||||
 simple (?) dimension filtering question What are the possibilities of DW/OLAP design which will provide an option to filter results based on exclusivity of dimension attributes OR levels, e.g.: - show the value of sales to customer with high and medium salaries (and not low salary)? - show the sales value for customers who shopped product1 and product2 and not the rest of the products? Moreover, is there an option to drill down to those selected dimension members?      |
Linear Mode
