TM1 Forum

Hi all,

I'm having a big issue setting up the right feeders for my values to stay visible when suppress zero's is on. I've read a lot of information but still I can't manage to fix the problem. Hope anyone can help. I'll describe the situation:

CUBE A
Dimensions: Period-Statline

CUBE B
Dimensions: Period-Statline-Worker

We have been working with CUBE A for years, and this cube consists all our data. For this reason, I've created a feeder that transfers Measure X from Cube A to Cube B. Since we don't use workers in CUBE A, I've set up the transfer to upload Measure X to (Period,Statline,'dummy worker') and this works perfectly. The data in CUBE B is similar to CUBE A, uploaded onto the dummy worker.

Next, when we look at CUBE B, see example, you can see that I've uploaded new data to Measure Y, and Measure X is the transfer from CUBE A (on dummy).

___________Measure Y________Measure X
Total__________1.5__________15
worker A________1
worker B_______0.5
dummy_____________________15

Now, what I'm trying to do is create a new element in CUBE B that divides X by Y. Problem is that this can only be done on consolidated level, because no member has both X & Y on N level. The rule I use is the following:

SKIPCHECK;
['X/Y']=['Measure X'] \ ['Measure Y'];

FEEDERS;
['X/Y']=>['Measure X'] \ ['Measure Y'];

When I don't press the suppress zero's button I get this: (again, works perfectly)

____________Measure Y____Measure X___X/Y
Total___________1.5________15_____10
worker A_________1________________0
worker B________0.5_______________0
dummy____________________15______0

But when I hit the suppress zero's button, Column X/Y doesn't show.
I've also tried these 2 FEEDERS:

['Measure X']=>['Measure X'] \ ['Measure Y'];
['Measure Y']=>['Measure X'] \ ['Measure Y'];

But they don't seem to work.
I really hope someone can help me, cause I'm out of clues.

Thanks in advance.
bloeblahoebla

It doesn't work because you never fed the "Dummy" element in Cube B from Cube A. The feeder you have proposed is not valid. The element A/B contains no data, it's just a formula so it can't be used to feed. The rule for intercube feeders in TM1 is that the feeder statement needs to be written in the cube where the data resides, not the target. Assuming the information you have provided is accurate (and I doubt that it is) here is your feeder, which should go in cube A:

FEEDERS;
[]=>DB(CubeB,!Period,!Statline,'Dummy',!Measure);
['Measure X']=>DB(CubeB,!Period,!Statline,'Dummy','X/Y');
['Measure Y']=>DB(CubeB,!Period,!Statline,'Dummy','X/Y');

Thank you very much for your reply.

I did put in the first line you were giving, that's what I meant with the first part of my text. Transferring the dummy data to CUBE B works perfectly. As that part isn't being suppressed when I hit the suppress zero's button. With your first line I mean:

FEEDERS;
[]=>DB(CubeB,!Period,!Statline,'Dummy',!Measure);

The 2nd and the 3rd line I didn't put in CUBE A and I don't understand how it could help me. Because, Measure Y is only filled in CUBE B. Measure Y can't be found in CUBE A.
Measure Y is directly uploaded into CUBE B and Measure X is transferred from CUBE A to CUBE B, so the only CUBE containing all info I need is CUBE B. For that reason I would suspect to build the formula and feeder in CUBE B, or am I seeing this the wrong way?

If that's the case (Measure X and Y data is only in Cube B) then the feeder in Cube B:

[{'Measure A','MeasureB'}] => ['X/Y'];