Page 1 of 1
Feeders between Cubes & Suppress Zero
Posted: Wed Dec 10, 2008 10:50 pm
by pobrouwers
Hello everybody,
I have a problem when I want to feed between 2 cubes.
My first cube contains Datas updated via TI and my second cube gets values from the first cube via a rule.
Below the rule of my first cube
Code: Select all
FEEDERS;
['S1','Réalisé', 'Volume' ] => DB('s Prev_Ventes_SousGroupe', !Annee, !Commerciaux, !Marques, !Client_Tout, !Produits, 'Volume Réalisé N-1 S1');
Below the rule of my second cube
Code: Select all
SKIPCHECK;
['Volume Réalisé N-1 S1']= DB('Stat_Ventes', dimnm('Annee',dimix('Annee',!Annee)-1), 'S1', 'Réalisé', !Commerciaux, !Marques, !Cient_SousGroupe, !Produits, 'Volume');
FEEDERS;
That's work but when I suppress zero in my second cube, I have no datas (No value is available!)
Do you know this issue ?
Thx
Re: Feeders between Cubes & Suppress Zero
Posted: Wed Dec 10, 2008 11:14 pm
by ScottW
Simple answer, if the rule works but you see nothing with a zero suppressed view then the feeder in the source cube is incorrect. In the destination cube right click a value (consolidated or leaf) and select "check feeders" (or whatever the equivalent French translation is) in the source cube select a leaf cell that you think should be feeding and select "trace feeders" to see if the feeder flags are actually being set.
Just out of interest why the second cube? Looking up the relevant data for the previous period could also be accomplished within the same cube using a "Last Year Actual" version or "Last year Volume" measure.
Also the rule in the 2nd cube should probably be N: in general it is always better to limit rules to leaf calculations and let TM1's standard consolidation algorithm handle the additions. That is unless a general rule or C: rule is required for a specific purpose such as a rate calculation or looking up the value of the last child rather than summing all children.
Re: Feeders between Cubes & Suppress Zero
Posted: Wed Dec 10, 2008 11:41 pm
by pobrouwers
Hello Scott,
Thank you for your answer.
When I check feeders, it returns no feed.... in the both cube -> My Feeder's rule is incorrect but why ?
I don't understand why that doesn't work... Perhaps, In those 2 cubes, I have 2 differents dimensions for the customers ???
If I put N:, I only have value in N level and not in C: level.
Thx
Re: Feeders between Cubes & Suppress Zero
Posted: Thu Dec 11, 2008 12:04 am
by ScottW
The reason you don't get any values in the destination cube for consolidated values with the rule as N: (even with suppress zeros off) is that the leaf cells are not fed.
I think you are most likely correct in your assumption about customer dimensions. My french is rusty to non-existent but I think you are going from All Customers to Customer Groups. As feeding is N level and you are feeding from !Client_Tout presumably the leaf level customer does not exist in Cient_SousGroupe as this dimension is a summarisation. The best way to fix this is via an attribute for group in the customer dimension.
That is:
1/ Create an attribute "Groupe" in Client_Tout and populate all N level elements with the appropriate ancestor name for the N level in Cient_SousGroupe
2/ Your feeder will now be
['S1','Réalisé', 'Volume' ] => DB('s Prev_Ventes_SousGroupe', !Annee, !Commerciaux, !Marques, AttrS('Client_Tout',!Client_Tout,'Groupe'), !Produits, 'Volume Réalisé N-1 S1');
Note I haven't fixed up the period offset. Since you seem to be looking up the value of the previous period in your rule, the feeder should presumably be the inverse and be feeding the next period in your Anee dimension.
Re: Feeders between Cubes & Suppress Zero
Posted: Thu Dec 11, 2008 9:40 am
by pobrouwers
Thank you Scott for your response
I have created the attribute Group in Client_Tout and replace the feeders but that's doesn't work.
However, I belevied in your solution beacause she's logical...
I don't understand why this feeders does'nt work!!!
Any idea ?
Thx
Re: Feeders between Cubes & Suppress Zero
Posted: Thu Dec 11, 2008 10:45 am
by pobrouwers
Re,
I have found.... I have done a mistake in attributes. I use a rule in the dimension Client_Tout :
Code: Select all
['SousSousGroupe' ] =S: if(ellev('Client_Tout',!Client_Tout)=0,elpar('Client_Tout',!Client_Tout,1),stet);
['SousGroupe' ] =S: if(ellev('Client_Tout',!Client_Tout)=0,elpar('Client_Tout',DB('}ElementAttributes_Client_Tout', !Client_Tout, 'SousSousGroupe'),1),stet);
Scott, Thank you very much for your help...