cancel
Showing results for 
Search instead for 
Did you mean: 

How to write Slogic for Hard Code members

venkata_singanamala2
Participant
0 Kudos

Hi All

Can any one please help on how to write slogic for  the Destination TIME?.

Ex: Source CAT: ACTUALS     Jan to July  = $1000(monthly)  Destination CAT: PLAN(always)   Destionation TIME=DECEMBER(always)

Appreciated your thoughts and guidence

Thx

Ramana

Accepted Solutions (1)

Accepted Solutions (1)

venkata_singanamala2
Participant
0 Kudos

Hi Roberto

Thanks for your script logic code and it is very helpful

Once again thank you very much

Thx

Ramana

Answers (3)

Answers (3)

venkata_singanamala2
Participant
0 Kudos

Hi Roberto

Thank you very much for your help and advice.Its YTD for consolidation appalication and want to transfer   post consolidated income statement data with 25% every month to DECEMBER( Jan to July) from ACTUALS to PLAN. Following script logic code  is in palce :

*SELECT(%YEAR,[YEAR],TIME,[ID]=%TIME_SET%)
*XDIM_MEMBERSET  CATEGORY=ACTUALS
*XDIM_MEMBERSET  DATASRC=BAS(ALL_DATASRC)
*XDIM_MEMBERSET  ENTITY=BAS(ALL_ENTITIES)
*XDIM_MEMBERSET    FLOW=NO_TRANS
*XDIM_MEMBERSET  GROUPS=CG1
*XDIM_MEMBERSET  RPTCURRENCY=USD
*XDIM_MEMBERSET TIME=%TIME_SET%

*WHEN ACCOUNT.ACCTYPE
*IS PL
   *REC(EXPRESSION=%YEAR%.JAN/4,CATEGORY=PLAN,{WHERE}%TIME_SET%YEAR.DEC)
*ENDWHEN
*COMMIT

Thanks in Advance for help

Ramana

former_member186498
Active Contributor
0 Kudos

Hi Ramata,

"{WHERE}%TIME_SET%YEAR.DEC" is completely wrong a mix of metadata language "{WHERE}" and a sequence of values %TIME_SET%, the variable that contain the Time parameter and "YEAR.DEC" correct sintax "%YEAR%.DEC" that force the december value, the correct syntax is TIME=%YEAR%.DEC

try this

*SELECT(%YEAR,[YEAR],TIME,[ID]=%TIME_SET%)
*XDIM_MEMBERSET CATEGORY=ACTUALS
*XDIM_MEMBERSET FLOW=NO_TRANS
*XDIM_MEMBERSET GROUPS=CG1
*XDIM_MEMBERSET RPTCURRENCY=USD
*XDIM_MEMBERSET %MONTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL

*WHEN ACCOUNT.ACCTYPE
*IS PL
    *FOR %MONTH%=JAN,FEB,MAR,APR,MAY,JUN,JUL
          *REC(FACTOR=1/4,CATEGORY="PLAN",TIME=%YEAR%.DEC)
    *NEXT
*ENDWHEN
*COMMIT

Kind regards

     Roberto

venkata_singanamala2
Participant
0 Kudos

Hi Roberto

Thank You very much for your time and sending back or reply.

Unfortunately the code what you had mention is not helping for correct syntax.

I have tried several property values(ex: Period) in TIME dimension but there is no success

Still searching online for TIME Variable to see how to incorporate fixed destionation members.

For Month: System is generating Error message that MONTH is not defined  as DIMENION in Consolidation Application and ever same for PERIOD

Once Again, thank you very much for your response all the time

Thanks

Ramana

venkata_singanamala2
Participant
0 Kudos

Hi Roberto

Thank You very much for your response and documents info link. I am looking here how to write slogic on December month where the requirement is below

ACTUALS >  JAN  $1000   PLAN/DEMBER(Fixed)

ACTUALS >  FEB  $2000   PLAN/DEMBER(Fixed)

Until JUL PLAN/DEMBER(Fixed)

I did use your code but getting following error message:   

UJK_VALIDATION_EXCEPTION:LINE 10 syntax error: " syntax error"

--

*REC(EXPRESSION=%YEAR%.JULY/4,CATEGORY=ACTAVG,{WHERE} %TIME_SET% YEAR.DEC) - Line 10

Thanks

Ramana

former_member186498
Active Contributor
0 Kudos

Hi Ramana,

is YTD or Periodic?

Please expain better where you have the input values (from jan to jul and you want to sum this on dec or vice versa you want to divide the sum of dec equal from jan to dec).

Plese read the guide there are several error in this line.

Please post all the script logic so we can try to help you

Kind regards

     Roberto

former_member186498
Active Contributor
0 Kudos

Hi Ramana, I'm not sur to understand what you ask but if you want a script to write on DEC the sum of the month from Jan to jul, you can write something like (where %TIME_SET% should be on year.DEC)

*Select (%YEAR%,[YEAR],Time,[ID]=%TIME_SET%)

*XDIM_MEMBERSET Time = %TIME_SET%

*XDIM_MEMBERSET CAT= ACTUALS

*REC(EXPRESSION=%YEAR%.JAN+%YEAR%.FEB+.....+%YEAR%.JUL,CAT= PLAN,%TIME_SET%)

*COMMIT

there are several how to guide for script logic in SAP f.e.

http://scn.sap.com/docs/DOC-4259 or the application help http://help.sap.com/saphelp_bpc75_nw/helpdata/en/a6/69182aed2c4df78e3f7b9d586735ac/content.htm

Kind regards

     Roberto