TM1 Forum

I have used 32 bit before and no need to do feeder for the rule that equal to specific value.

ie; ['price']= N:if(['Sales']>0,99,77);

However, I'm now using 64 bit. Price cell always shows me "not fed". Does anyone have any ideas?

Thank you very much.

sureerat wrote:I have used 32 bit before and no need to do feeder for the rule that equal to specific value.

Hmmm, why is that if I may ask? Is it a rather small cube so that you can do without the sparse consolidation algorithm?

Actually, 'Price' in this cube will be linked to use in another cube which is bigger than this cube.
ie, in Cost cube ['Cost']=N:DB('Price cube', !month,'price')*0.5;
['Margin']=N:if (['Cost']>33, ['A']+['B'],[C']).

I found out that in Margin cell show me 'Not fed', because 'Cost' and 'price'is not fed. I also try to write the rule in Price cube reference to 'price' cell, it always show me not fed. It makes me think that we need to feed for fixed value, but I don't know how to do it. Any suggestion.

Do you know about condition feeder? I also have problem, my data is messed up. (sometimes show right value, but sometimes it disappears)

Thanks

sureerat

Why don't you feed from price to cost? (which probably means a lot of overfeeding, but even that's better than not feeding...)

Just a question. Do you also track quantities sold in your Cost cube? If yes, maybe you can feed from quantities to cost.

Margin would be best done with a consolidation: revenue (price * quantity) with weight 1, and cost with weight -1 as the 2 children.

Wim

Thanks, I use quantity feed to Cost, and it works okay. Just still wondering that feeding between 32 bit and 64 bit is different.

As far as I know, this is exactly the same and I would be surprised if it weren't the case.