Hi,
Can anyone give an example which explains the following situation? Appreciated it.
"If your Cognos TM1 model uses conditional feeders where the condition clause contains a fed value"
conditional feeders contains a fed value
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: conditional feeders contains a fed value
For conditional feeders, please refer to this link.macsir wrote: Can anyone give an example which explains the following situation? Appreciated it.
"If your Cognos TM1 model uses conditional feeders where the condition clause contains a fed value"
Extract
Consequently "where the condition clause contains a fed value" would probably mean a situation in which either A or B is a fed value in the example above.You can use conditional FEEDERS to reduce or eliminate over-feeding. Typically you would use a conditional FEEDER to accompany a conditional rule. To illustrate the point, consider the over-feeding example that we discussed earlier:As we discussed before, the system is ignoring the value of “B” when it is constructing the FEEDER. You can construct conditional FEEDERS as follows to solve the problem:Code: Select all
['A']=>['A+B' ];
Note that in order to conditionally feed, you need to use a DB function. In this case, you put an IF statement in the parameter of the DB function that represents the cube name. Return the cube name for cells that you want to feed and ‘’ (null) for ones that you don’t.Code: Select all
['A']=>DB(IF(['B']=0,'','OverFeedSource'), !Time, !Product, 'A*B'); ['B']=>DB(IF(['A']=0,'','OverFeedSource'), !Time, !Product, 'A*B');
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: conditional feeders contains a fed value
Appreciated it. Alan.
I got it.
I got it.