Dimension order best practice
Hello everyone,
I am trying to optimize the system's performance.
Now, my cube has 12 dimensions and dimension order as below:
When I refreshed database for my application, it showed the warning:
I am not sure in the future; if my block is more than 1.000.000, I am definitely sure that I cannot refresh DB.
My question is:
Is this the best practice for my app ?
I am using "Plan Element" dimension to calculate the data.
Thanks, and have a nice day!
Tagged:
0