I have a calculated dimension in an object that groups our clients into roughly 10 buckets. I also have 4 or 5 variables for each of these buckets that I want to assign. The calculated dimension changes infrequently, the variables more often...
Example (buckets are the calculated dimension, rev/exp are the variables):
Rev Increase Expense Increase
Bucket 1 1.05 1.02
Bucket 2 1.10 1.15
Bucket 3 1.07 1.01
From above I want to be able to assign the variables to the calculated dimension in an as automated way as possible.