Skip to Content
author's profile photo Former Member
Former Member

TMVL parameter on SAP BPC

Hello experts,

I'm a junior in BPC, ı was trying to offset the months in Script Logic, in other words the image of the work that ı want to do is :

OCAK : January , SUBAT :february , ....

ı wrote a formula but it didn't worked exactly:

//************ for A_MUS (client A)

.

.

.

.

*XDIM_MEMBERSET DONEM1 = %STARTDATE%,%ENDDATE%,%PERIODS%

*FOR %DONEM1% = 2016.01, 2016.02,2016.03, 2016.04,2016.05, 2016.06,2016.07, 2016.08, 2016.09 ,2016.10, 2016.11, 2016.12

*WHEN HESAP1 //account

*IS 10000

*REC(FACTOR=1, DONEM1=TMVL(1,%STARTDATE%)) // time

*ENDWHEN

*NEXT

*//************for B_MUS (client B)

.

.

.

.

.

*XDIM_MEMBERSET MUSTERI1 = B_MUS

*XDIM_MEMBERSET CURRENCY1 = TRY

*XDIM_MEMBERSET MODUL1 = A_MODUL, B_MODUL, C_MODUL

*XDIM_MEMBERSET DONEM1= TMVL(1,%STARTDATE%) /// Time

*FOR %DONEM1% = 2016.01, 2016.02,2016.03, 2016.04,2016.05, 2016.06,2016.07, 2016.08, 2016.09 ,2016.10, 2016.11, 2016.12

*WHEN HESAP1

*IS 10000

*REC(FACTOR=1, DONEM1=TMVL(1,%STARTDATE%))

*ENDWHEN

*NEXT

the view of this formula is :

Any help ?

Thank you in Avance

Regards

Capture.PNG (6.0 kB)
Capture2.PNG (7.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 25, 2016 at 01:04 PM

    Hi Ayse,

    are you sure you are using MS version of bpc? In MS version TMVL does not exists, if you are using NW version please close this thread and reopen it in NW version.

    Is not clear what do you want to obtain, if you want to add the value to the next month just use the NEXT function, see please Time-Shift Instructions

    Regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 01:23 PM

    Yea....TMVL is not supported in MS version if using NW...Please post your query on NW version here SAP Planning and Consolidation, version for SAP NetWeaver

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 12:51 PM

    Hello Ayse.....

    First please explain verbally what is it you want to achieve through this script?? Scenario!

    Second - where have you defined the parameters %STARTDATE%,%ENDDATE%...etc???

    What is DONEM1? Time dimension?

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi JP ,

      DONEM1 : time dimension

      MUSTERİ1 : client (user defined )

      ı've defined the parameters %STARTDATE%, %ENDDATE%, PERIODS% and the scenerio :

      *SELECT(%SENARYO%,ID,CATEGORY1,ID='Budget')

      *SELECT(%STARTDATE%,STARTDATE,CATEGORY1,"ID= %SENARYO%")

      *SELECT(%ENDDATE%,ENDDATE,CATEGORY1,"ID= %SENARYO%") *SELECT(%PERIODS%,ID,DONEM1,"ID>%STARTDATE% AND ID<%ENDDATE% AND LEVEL='MONTH'")

      it's a demo of sales query (if ı'm not mistaken) and trying to time-shift though this script.

      however, i'll post my question under the title of SAP NW (that i'm exactly mistaken) and rewrite the question as english variables DONEM1, ... etc.

      Thanks a lot

      Regards Ayse Aydemir

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.