cancel
Showing results for 
Search instead for 
Did you mean: 

[OPEEND] refering to last year END and not last Period

Former Member
0 Kudos

Hi

I am trying to do a carry forward for the month and subsequestly do a FX translation. For the [OPEEND], the system is reffering to last year DEC and not thelast month which is what I want to do. How can I define OPEEND to look at just last period and not last year last period?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Here is the problem :

  1. When I am running my BCF rule (Snapshot included) it is not picking any records for the logic.

    • DIM Properties:
      • COPYOPENING for DS01 - Y
      • DATASOURCE_TYOE - I
      • Category Properties are blank but member exists
      • FLOW_TYPE - 100 is OPENING and 999 is CLOSING; INPUT Allowed - Y for Both
    • Script :

*RUN_PROGRAM COPYOPENING

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

ENTITY = %COMPANY_SET%

*ENDRUN_PROGRAM

Still is not picking any records. Please suggest.

former_member186338
Active Contributor
0 Kudos

Category Properties are blank but member exists - why?

former_member186338
Active Contributor
0 Kudos

Hi Akshat,

Please read this document

Even if you are using BPC10.

Vadim

Former Member
0 Kudos

Thanks for the reply Vadim. I understand that OPENING_YEAR and OPENING_PERIOD are to be used. But does that means every close users will have to update these? Right now I have my properties blank. Also, what values are supposed to be give. Say I am in year 2014 and closing Mar. So my source should be Feb Close data from 2014. Can you please help?

former_member186338
Active Contributor
0 Kudos

You can use relative month and year!

Vadim