Skip to Content


Sep 22, 2017 at 01:31 PM


avatar image
Former Member

Dear All,

Need a small info on program UJHANA_SYNC.

What is the purpose of execution of this program and how it helps for BPC cubes. What is the frequency of executing this program.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lucas Costa Sep 24, 2017 at 08:27 PM

Fragment removed from note:

1902743 - Write-back Optim. for Planning and Consolidation 10 on HANA:

  • A regular and frequent data sync between planning table and BW fact table is highly recommended to ensure performance for both reporting and planning.
  • During data sync, data will be moved from planning table to BW fact table through BW write API. Process is done in backend with NO interruption on reporting and planning for end user.
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member
Thnq Lucas... But in BPC 10.0 also the data will always be sink b/w planning and BW fact table...How it is different from BPC 10.0 to BPC 10.1...

Technically I don't believe there is a difference between the versions... Well, not that I know of

Gersh Voldman
Sep 26, 2017 at 08:04 PM

Hi Aditya,

You need this program only if you have Native HANA Allocations enabled. In this case result of allocation goes to planning table instead of directly to the cube. Usually all scripts and Queries read data from a view based on cube AND planning table, but if you have your own BADI that reads data most probably it reads from the cube only. In such case you need to run UJHANA_SYNC before you run such BADI.

Also, if you have too many records in that planning table it slows down allocation and defeats the purpose of having it.



10 |10000 characters needed characters left characters exceeded