Feeder for fixed value

Post Reply
sureerat
Posts: 6
Joined: Sat Nov 07, 2009 12:09 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Feeder for fixed value

Post by sureerat »

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.
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Feeder for fixed value

Post by Wim Gielis »

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?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
sureerat
Posts: 6
Joined: Sat Nov 07, 2009 12:09 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Feeder for fixed value

Post by sureerat »

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
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Feeder for fixed value

Post by Wim Gielis »

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
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
sureerat
Posts: 6
Joined: Sat Nov 07, 2009 12:09 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: Feeder for fixed value

Post by sureerat »

Thanks, I use quantity feed to Cost, and it works okay. Just still wondering that feeding between 32 bit and 64 bit is different.
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Feeder for fixed value

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply