Skip to Content
avatar image
Former Member

How do I calculate Year to Date for Last year in SAP Analytics cloud with Bex Query as Data source?

Hello Guys,

Can someone help me on below scenario?

I am using Bex Query as a source.

We have Data for 2 years lets say 2017, 2018.

Current Year YTD will show data from Jan-Apr( Till Date) for current Year.

Last year YTD will Show data from Jan- Apr (Till date) for the Last Year.

In SAP Analytics cloud, for Current year YTD, we can use a dynamic filter option but there is no option like current year -1 to get YTD data for last year.

Thanks in Advance!

Regards

Rakesh

Add comment
10|10000 characters needed characters exceeded

  • Hi Rakesh,

    Is this a live or acquired data model?
    If its acquired, you can use the cross calculations dimension to enable the YTD, QTD, MTD Member Functions.

  • Get RSS Feed

2 Answers

  • Apr 09 at 09:07 AM

    Hello Rakesh - I would look at doing these types of calculations back in the BEx query first; performance will be faster that way

    See https://blogs.sap.com/2012/10/29/define-ytdyear-to-date-logic-on-query-designer/ and https://archive.sap.com/discussions/thread/3520705

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 10 at 09:33 AM

    Thanks a lot Tammy Powlas.

    We are also following the same approach and trying to create YTD and MTD on the backend.

    Add comment
    10|10000 characters needed characters exceeded