TM1 Forum

Discussing all things TM1, Planning Analytics, PAx and PAW
https://www.tm1forum.com/

Feeders for rules in same cube with DB function.

https://www.tm1forum.com/viewtopic.php?t=14688

Page 1 of 1

Feeders for rules in same cube with DB function.

Posted: Tue May 28, 2019 7:29 pm
by BullaQ
Hi everybody,

I would appreciate it if anyone could help me with this.

Image

This are two cubes with same dimension elements and rules. Then only difference it is the name and some values of the elements in one dimension. But if you can see it the cube "Activo Fijo Tributario" does not working on consolidation elements for the element "Depreciation" and "AY" and in the cube called "Activo Fijo Financiero" it work fine and both have same rules (only with the order dimension and name changed).

This are the rules:

Code: Select all

SKIPCHECK;

['Budget', 'January','LM']=
N:DB('CP_CB20_Activo_Fijo_Tributario','LM', !Centro Beneficio Cons,!Centro Costo,ATTRS('year',!year,'previousyear'),!Activo Fijo,!Version_Holding,DB('Calendar',!Version_Holding,'Budget Month','String'),!Moneda,!Sociedad,'Real')-1;

['Budget','depreciation','January']=N:if(['LM']<1,0,(['AY']/['LM']));

['Budget','depreciation']=N:if(['LM']<1,0,DB('CP_CB20_Activo_Fijo_Tributario',!Indicadores Activo Fijo,!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'January',!Moneda,!Sociedad,!Escenario));

['Budget','AY']=N:
DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,ATTRS('Month',!Month,'previousperiod'),!Moneda,!Sociedad,!Escenario)-
DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,ATTRS('Month',!Month,'previousperiod'),!Moneda,!Sociedad,!Escenario);

['Budget', 'LM']=N:if(DB('CP_CB20_Activo_Fijo_Tributario',!Indicadores Activo Fijo,!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,ATTRS('Month',!Month,'previousperiod'),!Moneda,!Sociedad,!Escenario)-1<0,0,
DB('CP_CB20_Activo_Fijo_Tributario',!Indicadores Activo Fijo,!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,ATTRS('Month',!Month,'previousperiod'),!Moneda,!Sociedad,!Escenario)-1);

FEEDERS;

['LM','Budget']=>DB('CP_CB20_Activo_Fijo_Tributario','LM',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,!Month,!Moneda,!Sociedad,'Budget');

['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'February',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'March',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'April',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'May',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'June',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'July',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'August',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'September',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'October',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'November',!Moneda,!Sociedad,'Budget');
['AY','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','AY',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'December',!Moneda,!Sociedad,'Budget');

['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'February',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'March',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'April',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'May',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'June',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'July',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'August',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'September',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'October',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'November',!Moneda,!Sociedad,'Budget');
['Depreciation','Budget','January']=>DB('CP_CB20_Activo_Fijo_Tributario','Depreciation',!Centro Beneficio Cons,!Centro Costo,!Year,!Activo Fijo,!Version_Holding,'December',!Moneda,!Sociedad,'Budget');

['Depreciation']=>['AY'];
['LM']=>['Depreciation'];

Re: Feeders for rules in same cube with DB function.

Posted: Wed May 29, 2019 10:27 am
by Steve Rowe
You've only posted one of the rule sheets so its going to be hard to tell the.

Have you used the various rule trace and check rule / feeder pieces of functionality to try and diagnose the issue? Its probably an issue with a feeder statement and if you test from the source cell then you should be able to deduce whats wrong. Probably a simple syntax or dimension order issue if you have transposed the rule sheet from one cube to another.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited