We have two cubes:
1. Cube 1 has a time dimension with the levels year-month
2. Cube 2 has a time dimension with the levels year-month-day
We want to create a virtual cube from these two cubes. We tried to create a
new shared time dimension Year-Month-Day and changed the member property
"Disabled" of the Day level to true when using the dimension in Cube 1. But
the aggregated sum of the measure at the Month level in the cube is still
wrong. Does anyone know how the property "Disabled" is supposed to work?
Disabled means - "Determines whether the level is disabled. Disabled levels
are not available in the cube. They are used when the most detailed level of
data is not available in the fact table"..
We can fix this in the fact table behind Cube 1 (add the day 01 to every
time member), but we would like to do it in the cube.