Hello,
problem #1:
Rule: ['Viso dienų skaičius per mėnesį' ] = N: ATTRN('Laikotarpiai', !Laikotarpiai, 'Dienų sk.'); (rules takes attribute "Dienų sk." (number of days on month) from time dimension)
Feeder: ['2010.01'] =>['Viso dienų skaičius per mėnesį' ];
Problem:
for some reason, feeder is not working for some elements (when I do check feeders on "Katilinė Bukčių g. 58" one of child elements is shown as "not fed"). Restarting a server does not help. Any ideas why some elements are not fed? Dimension hierarchy is OK.
Problem 2#:
Rule (it is in cube "Faktas"):
['Dienų skaičius priode(Energijos)''' ] = N: DAYno(DB('Faktas', !AG, !Laikotarpiai, 'Periodo pabaigos data (Energijos)'));
Feeder #1: ['Periodo pabaigos data (Energijos)'] => ['Dienų skaičius priode(Energijos)'''];
Feeder #2: ['Periodo pabaigos data (Energijos)'] => DB('Faktas', !AG, !Laikotarpiai, 'Dienų skaičius priode(Energijos)''');
Should I use feeder 1 or feeder 2? The accumulation result seems to be the same; will it be the same in all cases? Which feeder would you recommend to use?
Simple feeder works only for some elements
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Simple feeder works only for some elements
Re problem #1:
Let me start by saying that what you are doing with this looks very weird to me. Can you tell us why you need to populate so many nodes in this cube with what is effectively a set of constants?
Secondly, why do you need a feeder in the first place? Consolidating numbers of days seems pretty pointless anyway.
The feeder itself will feed only if there is any value on any element of the dimension containing the element 'Viso dienų skaičius per mėnesį' for '2010.01'. Apparently, there isn't.
Re problem 2#:
Both feeder statements mean exactly the same and there is no practical or theoretical difference between them.
However you can't always use the "[]" syntax; sometimes you are forced to use the DB() syntax, namely when referencing other cubes, nesting functions or applying S rules.
Let me start by saying that what you are doing with this looks very weird to me. Can you tell us why you need to populate so many nodes in this cube with what is effectively a set of constants?
Secondly, why do you need a feeder in the first place? Consolidating numbers of days seems pretty pointless anyway.
The feeder itself will feed only if there is any value on any element of the dimension containing the element 'Viso dienų skaičius per mėnesį' for '2010.01'. Apparently, there isn't.
Re problem 2#:
Both feeder statements mean exactly the same and there is no practical or theoretical difference between them.
However you can't always use the "[]" syntax; sometimes you are forced to use the DB() syntax, namely when referencing other cubes, nesting functions or applying S rules.
Kamil Arendt
-
- Posts: 42
- Joined: Wed Nov 10, 2010 12:35 pm
- OLAP Product: Cognos 8 BI
- Version: 9.5.1
- Excel Version: Excel 2007
Re: Simple feeder works only for some elements
This TM1 project is a direct migration from Cognos Planning, and this measure was used in calculations. I need to consolidate it so it can be a part of non N: level rules.qml wrote:Re problem #1:
Let me start by saying that what you are doing with this looks very weird to me. Can you tell us why you need to populate so many nodes in this cube with what is effectively a set of constants?
Secondly, why do you need a feeder in the first place? Consolidating numbers of days seems pretty pointless anyway.
The feeder itself will feed only if there is any value on any element of the dimension containing the element 'Viso dienų skaičius per mėnesį' for '2010.01'. Apparently, there isn't.
By saying "any value on any element" you mean entered value, not calculated one, right?
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Simple feeder works only for some elements
No, not really. This can be a calculated value as well, as long as it's fed itself. Of course, at the beginning of such a feeder chain there has to be a normal input value somewhere.kudzis wrote:By saying "any value on any element" you mean entered value, not calculated one, right?
Kamil Arendt