Feeders for rules in same cube with DB function.

[BullaQ]

Hi everybody,

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



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'];

[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.