TM1 RULE not consolidating

[DYNA]

Good day All,


I am having a challenge with the following rule
['Opening Balance'] = If((ATTRS('Calendar',!Calendar , 'IsMonthApril')@='Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags')@='Y') ,0,DB('MDA Trial Balance ',!Calendar,!Version,!Data Source,!Client,!Property Sector,!Property Grade,!Property,!Account - MDA,'Opening Balance'));

I am trying to make opening balance zero since it is the beginning of the financial year , the rule does return the zeros for the specified cells but doesn't consolidate to the top level.

when i specify N: it doesn't not work at all .


Any direction or help would be much appreciated

[Wim Gielis]

Hi

Did you use feeders ? And correctly ?

[MarenC]

Hi,

Is MDA Trial Balance a different cube to the cube the rule is in?

Maren

[DYNA]

Thanks for responding , Actually I request an assistance with feeding this rule

Yes , MDA TRIAL BALANCE is different cube.

[konstantin-spb]

Hi,

Try something like this:

Source cube (in your code with a SPACE at the end of the cube name?):
'MDA Trial Balance '

Code: Select all

FEEDERS;

['Opening Balance'] => DB( 
    IF( ATTRS('Calendar', !Calendar, 'IsMonthApril') @= 'Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags') @= 'Y',
        '',
    'Unnamed Cube', !Calendar, !Version, !Data Source, !Client, !Property Sector, !Property Grade, !Property, !Account - MDA, 'Opening Balance') ;

Target cube:
'Unnamed Cube'

Code: Select all

FEEDSTRINGS;
SKIPCHECK;

['Opening Balance'] = N:
    IF( ATTRS('Calendar', !Calendar, 'IsMonthApril') @= 'Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags') @= 'Y',
        0,
    DB('MDA Trial Balance ', !Calendar, !Version, !Data Source, !Client, !Property Sector, !Property Grade, !Property, !Account - MDA, 'Opening Balance') );