Private vs Shared dimensions
In the TARGIT Data Model Editor, I am bit puzzled about the difference between Shared dimensions and Private dimensions.
Or, maybe I understand the difference, but I cannot see when I should actually use Private dimensions. Why can't I just create all my dimensions as Shared dimensions?
0
Comments
My recommendation will be to only use Shared Dimensions for reusability and reporting across different Cubes(Fact Tables).
Private dimensions only exists in the scope of the current cube. They can't be reused by other cubes. Only place these makes sense is in cases where you have a cube, not part of the virtual cube, but would also like to have dimensions with names unique to the cube, but which also exists in another context as a shared dimension.
Please sign in to leave a comment.