Just after some advice about whether something is possible.
I have developed a data-warehouse that encompasses all products, However due to the nature of the business what I want to do is create two separate cubes, both that only report on a selection of the products, i am trying to avoid extra security roles in Targit which is used to browse the cubes or creating extra SQL tables which i believe would enable me to achieve the result but with more to manage.
Is it possible to add a filter to a cube so that it only includes some dimension members?
Best answer by jens.mikkelsenView original
If you create a table in your DWH containing only the dimension values you want to see and creates a dimension containing this table, and set the 'unknown member behavior' of the dimension to 'None' you will only get data on 'known' members. Place this in a separately cube.
Regards Jens Jørn