Business Control Setup

[Former Member]

Hi everyone!  I am working on creating Business Controls for the first time.  My first control is to validate that the ending balance sheet value of a prior year is equal to the beginning balance sheet of the current year.  I have attached the business rule.  It is validated.  However, when I attempt to add "12" to the Period section of the lower level the system will not allow it.  Do I not need to tell the system that I want the Prior Year (-1) and Period (12) so that it knows that I want December's ending balance equal to January's beginning balance?

Thank you

[Former Member]

Hi Sean,

for me 12 works just fine. Have you filled in the MONTHNUM property in the TIME dimension?

BR,

Arnold

[Former Member]

Thank you for the reply.  I have filled in the MONTHNUM property.  See the attached image.

[Former Member]

Hi Sean,

my BASE_PERIOD is different to yours, instead of 000 I have 001, 002, ... etc with 003,006,009 and 012 for the quarters.

BR,
Arnold

[Former Member]

Arnold,

I changed all of the BASE_PERIODS to be in line with what you stated.  And, in the Control I used the BASE_PERIOD ID (ID- 012) and the Control Validated.  Is this correct?  Or, is it supposed to be using the MONTH_NUM ID?  If so, it still will not validate using MONTH_NUM.

[Former Member]

Hi Sean,

I have always had BASE_PERIOD and MONTH_NUM as the same numerical value, so I am not 100% sure which one it uses.