Solved

cube filtering

  • 6 March 2018
  • 1 reply
  • 20 views

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?  

icon

Best answer by jens.mikkelsen 6 March 2018, 15:05

View original

1 reply

Hi.

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

Reply