Forum Discussion

NovaBI's avatar
NovaBI
Post Patron
6 years ago

Automated Snapshot / Bookmark

Hi everyone,

 

I am looking for a solution for the following issue: 

I have an report that is refreshed on a daily basis from SAP. Everything is fine.

But as the data implies one month and is dynamically imported from SAP, a month change creates the issue that the last working day is missing (as the friday data is created saturday as an endpoint for the month to be fully correct).

If the report is now updated on Monday, it shows the new data from current month, so there is no way for the user to see the "end status" of the last month.

 

As the query is automated in SAP I do not have the opportunity to work with Slicers/Logics to make it visable via a month cut for example. I'd need a automated bookmark or snapshot for the last working day of month (i have this in my query), or an daily snapshot. Both ways would be okay.

 

Any hint? No premium available right now. Just Pro everywhere.

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    NovaBI ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • NovaBI's avatar
      NovaBI
      Post Patron
      6 years ago

      Hi amitchandak ,

       

      okay I will try to clarify it in a better way. I will put it simpler and just explain it on one visual.

       

      We have a progression visual (clustered column chart) showing data until workday 19. Now lets say the last friday in a month is workday 20 and is created on the last saturday in a month. All calculations are done in SAP itself, nothing to do with BI.

       

      But the data output is always centred around the current month. So if its now June, the refresh will "kill" the may data and show June, starting with Workday 1 again. And that is why i need a snapshot/bookmark of the data form the last month. Because people want to see the final numbers in BI.  I don't have the chance to get a period pearameter right now, so no slicers are   reasonable.

       

      Last week:

       

      current update:

       

       

      So I need a automated snapshot in the last week of the month on the weekend or a bookmark people can refer to.

       

      Otherwise they will say "where is my final data?"