I have noticed the the cubes that we have here use shared dimensions.
For almost all cubes(5-6) there are at least 4-5 common dimensions.
According to what I have been preached so far, the shared dimensions are so that you can reuse them. That is not what is practised here.
cube1 has somedim1, dim2_c1, dim3_c1...
cube2 has xyzdim1_c2,xyzdim2_c2,dim3_c2..
dim3_c1 and dim3_c2 are the same dimensions, one for each cube.
I don't know if I am missing something. Shouldn't the use the same dimensions? Could there be any reason for this.
This happens pretty often in a warehouse where competing factions "own" different cubes. Instead of creating an overall cube structure to make things simpler for everyone, each group uses the structure that is simplest for them. This allows everyone as much freedom as possible, and grossly degrades the overall usefullness of the warehouse!
Thanks Pat, for the reply.
Also another wierd thing is the cubes are on views. That is some of the dimensions are on views with join conditions. I thought even this will be poor performing. What do you think on this. How can views be avoided?