Use Different Data Storage Types for Metadata in Different Cubes
We have two cubes that use time differently. One uses months as the most basic level, whereas another cube breaks months down into weeks, so the data storage type used for the month dimension member will vary between dynamic calc and store. However, whenever I try to toggle one the weekly cube's month value to dynamic calc, it forces the rest of the cubes that only drill down to the month to dynamic calc instead of leaving them as store.
Is there a way to customized data storage type across different cubes without forcing standardization across all cubes?
0