Skip to Content
avatar image
Former Member

Dynamic Dates in Design Studio

Hi everyone,

I am new to SAP BO Design Studio.I have a start date ,end date,calendar date,current date,and have a from and to date propmts in the report.

I have to show by default 3 months data.I need this to dynamically change the current date and its previous 3 months.After that according to the strt date nd end date that is being selected,chart should get filtered.

How can I achieve this? I have referred How to use arrays for finding trailing months.

Regards

Archana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 03, 2015 at 10:30 AM

    Dear all,

    I tried using the above method which actually didn't work 😔

    I need to restrict the no of months to latest 3 months(current month),previous month and its previous month) for the first time login. This should happen dynamically.

    I tried by referring "How to Use Arrays for trailing months". But still it didn't work. The month start date format of mine is in YYYY-MM-DD

    Can anybody help me regarding  this?

    Archana

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Vivek,

      Current date  can be find out using :

      1) find application sys date

      2)Split DD,MM,YYY from YYY-MM-DD and store it in  local variables

      3)Now apply prior date logic as above mentioned in Karthik's post.

      4)Filter it in your data source accordingly.

      Karthik had already explained here and you can find current date also refer his thread -How to use Arrays in SAP BO Design Studio for trailing months.

      Regards

      Archana

  • Oct 21, 2015 at 01:42 PM

    Hi Archana,

    have a look on this site: Possibility to Bypass mandatory prompts on DS startup

    regards

    Simon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Simon,

        Thanks for your immediate response.

      I have implemented as:

      1) Loading two datepropmpts with columns curr month nd prev month

      2)As u told had defined two global variables X_from and X_to as default values of current nd prev mnth in Yyyy-mm-dd..as in backend format.

      3)Set variable value to both current nd prev date

      4)filtered data source from getting dates from datepropmts

      5) ds_1.reloaddatasource()

      But my doubt is hw will nxt tym on the new mnth strt date the data ll refresh..as wehve already set the default values..will it be a problem?

      Regards

      Archana