How can I create more than one Cube with different dimension views? 1

[fuhbar]

Hi

I have the following problem.

I have a Transformer model with 3 dimensions.
Lets say dimension A is about regions, dimension B is about suppliers, and dimension C is about materials.

Dimension A has one level with 50 regions.

Now I want to create one cube for each region in Dimension A. I filter the dimension A with a dimension view, which exclude all regions but one. The problem is now, that all other dimensions aren't filtered that way, so that I get a cube whose measurements are filtered by regions X1 as described above. But all other dimension are shown completely, many of them with zero values. This should not be the case, cause in region X1 only 100 from 1000 suppliers are delivering, for example.

So I have to filter the remaining dimensions B and C in terms of region X1 and so on for each cube.

I know I could filter my data sources by regions X1 and so on, but then I would need for each of the 50 cubes one TR model, I guess.
I want to use one TR model to create all 50 Cubes.

Does anybody have any suggests?

Thanks in advance
christian

 

[ianhawksey]

Hi fuhbar
if i understand correctly, you want one cube for each category in dimension A, ie each region.
have you tried using a cube group,based on dimension A, and the region level? this will give you a cube automatically for each category (region) which appears at the region level. all data for the other dimensions will appear in each cube as appropriate.
hope this helps

Regards

Ian

 

[fuhbar]

Yeah you understood it correctly and your solution works.

Thanks Ian