TM1 Forum

For example I have 2 cubes. One of them contains 3 dimensions Items, Numbers and measures1 (with elements - element 1 and element 2).
Another contains 4 dimensions - Items, Numbers, months and measures2 (with elements 3 and element 4).

I wrote rule in the second cube
[element 3] = N: DB('Cube1',!Items,!Numbers,'element 1');

How I can write a feeder in the first Cube if I don't have dimension months there?

I tried to wrote
['element 1'] => DB('Cube1', Items, !Numbers, !months, 'element 3'); but it shows error because I don't have dimension months in Cube 1. One thing works if I write
['element 1'] => DB('Cube1', Items, !Numbers,'Jan', 'element 3'); but I must write 12 feeders for every months. It isn' convinient.

Also I don't have consolidated elements in months dimension. (I have heard about advice to write feeder as)
['element 1'] => DB('Cube1', Items, !Numbers,'Total','element 3');

Can you give me any advice?

I'm no expert, but my suggestion would be: add a consolidation element to Month and then use your last feeder. Because when a consolidation is fed, so are its children. And a consolidation in Month would come in handy anyway

I echo what Comma says. Plus, a month dimension with no hierarchy for rolling into quarters and then a year? Quite unusual.

tomok wrote:I echo what Comma says. Plus, a month dimension with no hierarchy for rolling into quarters and then a year? Quite unusual.

Actually this dimension is in auxiliary cube where I don't need consolidation. And also the dimension is being used as a picklist so I don't want to have consolidation elements there.

ok. I will use another dimension in that cube - with consolidation.

even if you are using a dimension in a picklist, you can still have consolidated elements.

a picklist can be based on a subset from the dimension, which would allow you to limit it to level 0 elements.