BO Report to populate incremental data

[former_member1275783]

I have a table SALES:

SALE_ID, SALE_TIME

S1, 6/1/2020 8:00:00 AM

S2, 6/1/2020 9:00:00 AM

S3, 6/1/2020 11:30:00 AM

S4, 6/1/2020 01:30:00 PM

And I have a report, which runs every day to pull all the sales details since last report run time.

For E.g. Day 1 report ran on 6/1/2020 at 10 AM And Populated the Claims S1 and S2 (Since S3 and S4 loaded after 10 AM)

And when the Day 2 report run, it should populate only S3 and S4.

I dont think LastExecutionDate() will work. Since I cannot pass the value in query.

Is there any way I can create this kind of report ( Report only incremental data)

[mynynachau]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment).

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Mynyna

SAP Community moderator

[TammyPowlas]

Sandeep - which front end tool are you using? For now I am going to assume Web Intelligence, so I will update your main tag to that.

[DellSC]

I think you would have to have a field in the data that records the creation or last update datetime in order to be able to do what you're trying to do.

-Dell

[former_member1275783]

How can I create such a field?

Since we cannot push the last refresh time to DB, is there any way for that?

[DellSC]

Unfortunately, no.