Hi Chris, I have a different situatio

Written by Uma Hariharan. Posted in Comments

Hi Chris, I have a different situation and would like your view on single vs. multiple cubes. This is a subscription based BI reporting. I have a dimension with no levels of hierarchy. And this dimension drives the security, i.e., it has one to one relation with the subscribed user. There is no need for a single view across all users. Should this dimension be included in the cube, or should I go with the approach of having a separate cube per user and have this as a filter while building the cube? Many thanks Uma