You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!