Page 1 of 1

TM1 RULE not consolidating

Posted: Tue Jun 21, 2022 7:03 am
by 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

Re: TM1 RULE not consolidating

Posted: Tue Jun 21, 2022 8:53 am
by Wim Gielis
Hi

Did you use feeders ? And correctly ?

Re: TM1 RULE not consolidating

Posted: Tue Jun 21, 2022 9:49 am
by MarenC
Hi,

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

Maren

Re: TM1 RULE not consolidating

Posted: Tue Jun 21, 2022 12:50 pm
by DYNA
Thanks for responding , Actually I request an assistance with feeding this rule

Yes , MDA TRIAL BALANCE is different cube.

Re: TM1 RULE not consolidating

Posted: Tue Jun 21, 2022 8:01 pm
by 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') );