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.
Feeder for fixed value
-
- 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
Hmmm, why is that if I may ask? Is it a rather small cube so that you can do without the sparse consolidation algorithm?sureerat wrote:I have used 32 bit before and no need to do feeder for the rule that equal to specific value.
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
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
-
- Posts: 6
- Joined: Sat Nov 07, 2009 12:09 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
Re: Feeder for fixed value
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
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
-
- 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
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
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
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
-
- Posts: 6
- Joined: Sat Nov 07, 2009 12:09 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2007
Re: Feeder for fixed value
Thanks, I use quantity feed to Cost, and it works okay. Just still wondering that feeding between 32 bit and 64 bit is different.
-
- 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
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
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