That is dependant on the scope of your project, but I would say try to reuse as much of your dimensions as possible, so that would mean more applications, which make use of shared dimensions.
There are lot of things to be considered. More application means more tables in the database. This will increase the size of the database. In a single application, you can have a max of 20 dimensions. So, generalizing, which is better is very vague. I would request you to evaluate both the options in your scenario. I would suggest if you can go with more dimensions, then you can go ahead with it.
just to add some informations, there is no limit for the number of the dimensions but for experience after 18-20 the performances fall down, to have a good performance is better mantain the application until 12 dimensions. More applications in the database doesn't affect so much the performance of the DB but obviously it depends how many applications do you create.
I would think you would need to reduce the number of dimensions. The ideal number of dimensions that should be maintained in an Application is around the 8 mark. The more it increases beyond this the performance of the Applications would reduce.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.