Skip to Content

YTD actual report on Periodic Model

Hi Experts,

System BPC Embeded 10.1

Model is periodic model

Bex query

AO 2.4

Requirement:

In the below screen shot right now data is getting displayed monthly based on periodic model.

But the requiremnt is data should be displayed in YTD , please find data format which we require in below screen shot.

Can we achieve above requirement using formula key figure in Bex query if yes please let me know how to write formula for achieving above YTD requirement.

Thanks in Advance

SK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 10, 2017 at 11:44 AM

    Hi,

    use the current member feature in the BEx query, more details can be found here:

    https://blogs.sap.com/?p=444923

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2017 at 06:59 PM

    You are talking about AO 2.4, not about

    EPM Add-In for Excel

    Please remove tag!

    Add comment
    10|10000 characters needed characters exceeded