Make Process Flow Widgets Customizable

Completed

Comments

32 comments

  • Avatar
    Tim Wong

    Yes, it will further empower the B1Up process flow widgets. I hope to see this soon as one of our customer would like to use this instead of Hana Widget.

    Thank you.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    @Tim: While I understand the need, the current situation should not be a showstopper for not using the Fiori Cockpit. Their Process Flows are not customizable either so you customer should have the same options with our current offerings

    Comment actions Permalink
  • Avatar
    Tim Wong

    Hi Rasmus,

    Our customer will be very happy to see if they are able to customize the process flows.  I believe this is something many customers will love to see this feature as they can't edit the B1 process flows.

    Thank you.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Process Flow Editor will officially be available from B1UP 2020.0 

    Video how it works: https://youtu.be/8ejGopG5f88

    Early Preview Version (2020.04.06) if you wish to try it yourself: https://www.boyum-it.com/sbo/Preview/

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Rasmus.  Indeed a wonderful news.  I am sure our customer will be very excited about it.  BTW, we have a challenge to use the process flow.  it is slow if compare to the Fiori cockpit.  Is it normal?

    Thank you. 

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Could you please elaborate what you mean by that (in what way are they slow?)... During startup they take a second or two to render visually but beyond that the only real thing they do is to press menu-items on your behalf so they should be just as fast/slow as Pressing the menuitems in the main menu.

    Nobody have reported any issues with them so far...

    Comment actions Permalink
  • Avatar
    Tim Wong

    Hi Rasmus,  The dashboard loading is slow.  Basically, anything to do with the dashboard is slow e.g. click the dashboard menu items are slow.  I have installed on my local machine which is running on SQL and it is reasonable fast.  The customer that I am testing is using HANA.  Occasionally, I am getting the following error.  And also, I noted some of B1Up configurations are slow in HANA if compare to SQL.  Do you have any customers who are using HANA reported the B1Up is slow for some of configurations.  The dashboard is just real slow.  You can remotely take a look if you wish as to show you how slow it is.

    Thank you.

    Regards,

    Tim

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Hi Tim

    It is a known fact that in pure performance then HANA is slower than MSSQL (MSSQL having a 15+ year in optimizing the database engine). Where HANA shine is in not having as many database locks so more people at the same time can work without deadlocks.

    When it comes to dashboards there are 3 steps in loading them:

    Step 1: Initialization

    This step is a load of DLL files into memory. The dashboard has some fairly big DLL files (200mb) so it takes some time to load this (HDD speed and CPU being the factor that impacts how fast it can be done). But on 2 identically machines; one running MSSQL and one running HANA this time should be 100% the same

    Step 2: Data Retrieval

    This is the step that will take longer on HANA. HANA requires more hardware to be as fast as MSSQL and in your test-case you get the data from a local source taking the Network out of the equation. In this step we are not really doing anything so the speed here are purely determined by HANA and Network.

    Step 3: Data Visualization

    This is the step we turn the data into charts and pie-elements. This is done 100% the same on both HANA and MSSQL so no difference there.

    ***

    When it comes to UI-API the system is also 100% the same (there is a tiny bit of database communication but not much) so the speed of pressing a common function or a process flow should be exactly the same speed as if you did it from the SAP Main Menu (UI-API have a tiny overhead, but normally measured in milliseconds)

    So base on what you have sent it sounds like is the HANA system is slow that it perhaps is under dimensions Hardwarevice and other operations like add Invoices etc. are also slower than on your local machine.

     

    ***

    As for the error message, It is no and error we have seen before, and looking at the code I can't see a logical reason how this error can happen, but I've adjusted the code to not throw the error should it happen anyway as it is a non-critical operation that fails.

     

    ***

    But we can't fix that HANA, in general, is slower than MSSQL. That is for SAP to fix...

     

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Rasmus for clarifying it.  Every developer is telling me the same thing.  Thank you for breaking down and well explained.

    And also, we noted one thing that is very strange.  Saving B1Up UF is slow.  It will take 3-5 seconds.  Saving B1 documents will take only 1-2 seconds.  Is there anything that you can suggest where we can look it as why saving B1Up configuration (UF) is slow?

    Please help.

    Than you.

    Comment actions Permalink
  • Avatar
    Michael Haak

    Hi Tim,

     

    what is the read-/write speed of your server hard disc and what is your CPU clock frequency of the server and the client?

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Michael for your quick response.  It is HANA box and running on WMWare.  Sorry I have to ask this question, how to find out the requested info?

    Please help.

     

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    The simplest way to check is to do a Performance Profiling: https://youtu.be/zJJcbBovxRg

    If you make a such and share the files with me I can see what takes time while our code run.

    1. If it shows slowness in getting the data from the screen (UI-API) it is poor Client machine performance (bad CPU)
    2. If it shows slowness in getting/saving data to the database it is poor HANA performance / bad network performance (but we will not be able to tell you which of the two)
    3. If it shows slowness in the Boyum Logic Code it indicates that we have poorly written code

    It tends to be (2) in most HANA cases and (1) in almost other cases... In rare cases it is (3).

    ***

    Another "good test" is the "Make new DB test"... Simply go to the database selection screen and create a new empty database. In good systems that operation take 2-3 min... In poor systems it take much longer.... This test test the pure SAP Performance when it comes to HANA and Network

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Rasmus for the suggestion.  I have tried to create a new empty database and it is taking about 7 mins.   I guess it is pretty bad if you are talking about 2-3 mins for good systems.  It takes a long time to create a UDF as well.

    I can go back to talk to them by mentioning 2-3 mins for good systems.

    Thank you.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    The 2-3 min tests I've done was on MSSQL. Never had a production HANA system where I've tested myself so do not know is 7 min is good or bad (only that I've tested on small internal test-systems and there an new HANA db takes 20 min so 7 min is at least not super terrible I guess)

    But try and create the Performance Profiling... That will give the most accurate measurement in terms of B1UP

    Comment actions Permalink
  • Avatar
    Tim Wong

    We have done a Performance Profiling before with Thomas.  The performance is reasonable according to Thomas.  Do you think it will help if we do another round of performance profiling?

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    If you give me the Ticket Number I will take a second look if we still have the data and things have not changed between now and then

    Comment actions Permalink
  • Avatar
    Michael Haak

    Hi Tim,

     

    the best way to find out the read/write speed is to ask the administrator.

    There are also some benchmark apps but I won't recommend to install this on productive machines.

     

    I use a very simple way to check my machines: I copy a large file from one folder to another or from on drive to another.

    The second simple check is to zip / unzip a large file.

     

    If these to things are fast, in most cases also the ERP system runs fast.

     

    I it is to slow, my experience is to upgrade the hard drive (we only use NVMe) and CPU clock frequency (we recommend at least 3GHz).

    If you double the speed of one of them, then you almost double the speed of the ERP.

     

    If you double the RAM or the cores, in most cases you hardly notice a difference, except the RAM was too small before.

     

    Sometimes it could be helpful to deactivate the Backup Software and the Anti Virus Software during the Performance check.

     

     

    Here you can download a zipped TXT file with 5 000 000 rows:

     

    https://business-one-easy.de/wp-content/uploads/2020/03/PERFORMANCE-5MIO-Zeilen-1Sek-kopieren-10Sek-zippen-2Sek-entzippen.zip

     

     

    If you copy the TXT file, it should take less than 1 second

    If you unzip it, it should take less than 2 seconds

    If you zip it, it should take less than 10 seconds

     

    Comment actions Permalink
  • Avatar
    Tim Wong

    Hi Rasmus,

    The ticket number is 93618.  Thank you.

    Comment actions Permalink
  • Avatar
    Tim Wong

    Hi Michael,

    Our customer has a very powerful machine and they can always allocate more resources to the virtual machine if the machine resources is under stress.

    Are you looking for read/write speed for HANA box or windows server?  

    Ok, I have done the suggested testing on the server when I run my SAP B1.  

    1. Take about 1 second to copy the TXT file

    2. Take about 4 seconds to unzip the TXT file

    3. Take about 16 seconds to zip the TXT file.

    Do you think it is slow?

    Thank you.

     

    Comment actions Permalink
  • Avatar
    Michael Haak

    Hi Tim,

     

    if you have done this test on the Server AND on the Client (where B1 runs) then the hardware performance should be ok.

    On our servers B1 runs also slower than our other ERP-Systems. But I suspect that nobody at SAP can improve the performance.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Tim Wong Sorry for the delay in checking ticket 93618... I can see the Profiling the was the execution of Dynamic Code and Execute of UFs... So they can't really tell why you Dashboards are slow...

    So could you please make a profile that is using the Process Flow (Start Profiler > Click on a single Process Flow Entry to open a screen > Stop the profiler and send it to us (give it ticket number 999991)). Then reply back here so I know it has been uploaded.

    Comment actions Permalink
  • Avatar
    Tim Wong

    No worries, Rasmus. I will allocate some time tomorrow to work on this.  Hopefully, we can find out whey B1Up is slow in loading & saving.  SAP B1 itself is reasonable fast.

    Comment actions Permalink
  • Avatar
    Tim Wong

    Hi Rasmus,

    I have loaded the profiling and please check.  I started with open Sales Order (x2), open Item Master Data (x2), saving Macro UF (x1) and Dynamic (x1)

    Let me know if any questions.

    Thank you for your help.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    I can see from the Profile that UI-API is slow on this system (UI-API is dependant on CPU, Number of Cores, and HDD speed). What normally is 5-10 ms in 100-150ms in your system.

    Beyond that, I can see that the load of you screens you run some dynamic Code UFs... The take 7 seconds of the opening so you should check into that dynamic code and optimize it if possible.

     

    A pure test of the Process Flow alone would be to turn off all modules but Dashboards and test the performance.

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Rasmus,

    Our customer's dev server is reasonable powerful as the following server spec.  The SAP B1 client is running reasonable quick for updating and adding.  As for the dynamic code UFs, it is running reasonable fast in SQL environment.  It is slow when we run it in our customer's dev server with Hana DB.  I noted it is even slower when your UF calling a few UFs to do something.  For example, in your UF, you call another macro to do something.  Within the macro, you call the .Net to return something.  Each calling will slow down the performance.

    Please help.

    Thank you.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    I don't really know how to help. As Mention SAP Business One is just by definition slower than MSSQL and Windows servers running SAP Business One is also by definition slower than working on desktop machines... I've been asking SAP for years why that is and they can't give the answer... And the profile shows that it is not the B1UP logic that is the contributing factor to the slowness; it always comes down to the UI-API and DI-API calls and there we can't be faster than SAP allows 

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Rasmus and we have another customer using the Hana with lower hardware spec but don't have this issue.

    Thank you for your help so far and am really appreciate it.

    I will continue to work on it and hopefully, we can find out the cause of the issue.

     

    Comment actions Permalink
  • Avatar
    Tim Wong

    Hi Rasmus,

    Can you let me know which Hana B1 version that you used for your testing?  We are using version 9.3 PL12 at the moment.

    Thank you.

    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    I'm not sure what testing you refer to... Internally Boyum curremtly have 3 main HANA systems. One on 9.3 PL10, one on 9.3 PL13 and one on 10.0 PL01... But they are all tests system and are not used for production so they are all quite underpowered compared to the amount of users so they can't be compared to Live systems

    Comment actions Permalink
  • Avatar
    Tim Wong

    Thanks Rasmus.  Our development server is pretty powerful.  One part that I don't understand is loading standard B1 form with data is relatively quick (less than a second) but when we open B1Up UF is slow in loading the data.  For example, go to B1 Validation Configuration Screen and click UF golden arrow key.  It will take around 7-8 seconds to get UF screen with data.  The UF screen pop-up very quickly then it will take 7-8 seconds to load the data. Saving the UF is about 4 secs.  Any ideas why B1Up is slow in loading and saving?

    Thank you.

    Comment actions Permalink

Please sign in to leave a comment.