HDB modeling in WebIDE – and why we are staying in HANA Studio for the time being

HDB modeling in WebIDE.

We are working with lots of mixed-scenarios, meaning that our data is stored in BW and exposed as Calculation Views for further HANA native processing. When we became aware that HANA modeling is moving away from HANA Studio and into Web IDE for SAP HANA with quite some new features, we were excited at first. This blog explains, why we are nevertheless staying in HANA Studio for the time being.

First off, SAP made it clear that the next “major” HANA release will remove XS Classic (XSC), see SAP Note 2465027. This also means that the HANA Modeler within HANA Studio is deprecated, already there are no new features but only critical bugfixes. The following picture shows the transition:

While XS classic runtime is delivered with the HANA DB out-of-the-box, you need to install and configure the XS advanced (XSA) runtime if you want to use the “Web IDE for SAP HANA” (XSA WebIDE). By the way: don’t confuse it with the “HANA Web-based Development Workbench” (XSC WebIDE), which you won’t miss, because you probably did not know that it existed anyway.

We thought: great – the Web IDE is browser-based, so no more HANA studio maintenance necessary. Also, there is no more proprietary HANA repository, but a shift to the well-known GIT instead. Very nice, but wait… what does that mean for deployment?

Deployment

Up until now, we created Calculation Views in HANA Studio, and then deployed them to our other BW systems simply by using transaction SCTS_HTA (HANA transport for ABAP – HTA). However, this only works with packages of the classic HANA repository. SAP announced that HTA will work within the new environment as well, however this support is only planned for BW/4HANA. If you are still using BW 7.x, like we do, then you are already massively discriminated at that point. Sure, you could go for other deployment options – see picture below – but none are as convenient as HTA from a BW perspective.

Migration

If you want to reuse your existing HANA models within WebIDE, then you have to follow SAP Note 2396214 first. For that reason, we converted all our Attribute- and Analytic Views to Calculation Views and also adapted our Script-based Calculation Views to make use of table functions. By the way, this is a step that is recommended in any case – even if you are still far away from WebIDE usage – as it optimizes the runtime performance. But back to our POC – so now we had all our objects ready for moving into WebIDE, and to do so we ran the command line tool „xs-migration”. It reads the content of a Delivery Unit – which you need to prepare first – and converts all included objects to the new HDI-compliant format. The HANA Deployment Infrastructure (HDI) is basically the framework for handling DB artifacts within WebIDE. However, this first conversion step went rather well, at least after SAP fixed a bug that was obstructing us. The next step was to import the converted objects within WebIDE. Unfortunately, despite all efforts this just failed for us. Within an OSS incident we once more learned that the software version you are using, really is essential. That is because some features that our Calculation Views would have required, are just not supported with WebIDE on HANA 1. We were suggested to upgrade to HANA 2, which was not supported by our hardware at that time.

Cross Schema Access

So now it was already clear that you need to have BW/4HANA on HANA 2, if you want to utilize the WebIDE reasonably. Somewhat disillusioned we started to play around within WebIDE anyway. We created a simple Calculation View and wanted to include an External HANA View, generated out of BW. Immediately we learned that this is not as simple as it used to be anymore. The reason is that all HDB artifacts are kept within a HDI container, which technically is an isolated DB schema, see picture below.

If you want to access data from another schema like _SYS_BIC (where all the legacy Calculation Views are stored) or some other schema YXZ (could be your ERP system), then you have to go through Synonyms. At the time we ran our POC, it was necessary to manually create Synonyms for every single object involved. Also, it was required to setup a user-provided service through command line tool for that purpose, which is all but user-friendly (why can’t it be done via XSA Administration?). At least there have been improvements, so meanwhile Synonym generation can be done automatically from within the Calculation View editor. Still, if you want it the other way around – that is to access HDI objects from outside – then you need to set appropriate authorizations. For that purpose you will have to make yourself familiar with. hdbrole, .hdbgrants and all that comes with it.

Summary and recommendations

For HANA database development there is no way around WebIDE in the near future.

On the plus side, it runs within the browser, has an integrated GIT client with source control and versioning, there is an all-or-nothing build approach instead of individual object activation (so no more broken single objects), there is a graphical CDS editor and additional Calculation View nodes (graph, intersect, minus) are available among other new features.

On the negative side, it’s not simply the user interface that changed, but the whole repository and deployment infrastructure. This comes with the loss of backwards compatibility and also with complex new access scenarios that need to be taken into account. So, my personal recommendations are:

  • Migrate Attribute-, Analytic- and Script-based Calculation Views now
  • Familiarize with HDI and new security concept
  • Start exploring WebIDE and its modeling tools
  • Experiment with GIT teamworking scenarios
  • Consider switching to XSA with BW/4HANA and HANA 2

Read at https://blogs.sap.com/2018/06/15/hdb-modeling-in-webide-and-why-we-are-staying-in-hana-studio-for-the-time-being/

Posted on Juni 18, 2018 in BWBLOG

Share the Story

Responses (71)

  1. louis vuitton shoes for women
    Januar 16, 2022 at 10:19 am ·

    louis vuitton shoes for women

    Cheap authentic Original Women louis Vuitton Sale|Authentic Women louis Vuitton Sale|Cheap Louis Vuitton Handbags Factory Outlet Online Sales sale online store ,LV Exhibition Highlight 2: Fantasy bags that can change with gloss

  2. canadianpharmacy
    März 31, 2022 at 12:34 pm ·

    canadian viagra https://kertvbs.webgarden.com/

    Kudos! I like it!

  3. tadalafil without a doctor’s prescription https://derkuy.timeblog.net/45076032/key-pieces-of-online-pharmacies

    Wow tons of terrific knowledge!

  4. canadian pharmacies that are legit
    April 5, 2022 at 11:21 am ·

    northwest pharmacy canada https://gwertvb.mystrikingly.com/

    Incredible a good deal of good knowledge.

  5. tadalafil tablets https://telegra.ph/Is-It-Safe-To-Lift-COVID-19-Travel-Bans-04-06

    Really quite a lot of great knowledge.

  6. canadian-pharmacies0.yolasite.com
    April 9, 2022 at 4:52 pm ·

    medication without a doctors prescription https://canadian-pharmacies0.yolasite.com/

    Really loads of amazing information.

  7. https://pharmacy-online.yolasite.com/
    April 10, 2022 at 10:07 am ·

    cialis 5mg prix https://pharmacy-online.yolasite.com/

    You actually stated that wonderfully.

  8. kevasw.webgarden.com
    April 11, 2022 at 11:38 am ·

    buy cialis without a doctor’s prescription https://kevasw.webgarden.com/

    Thanks! Awesome stuff.

  9. canadian rx
    April 12, 2022 at 12:44 pm ·

    canadian pharmacy meds https://62553dced4718.site123.me/

    Kudos, Valuable stuff.

  10. https://site128620615.fo.team/
    April 14, 2022 at 3:10 pm ·

    purchasing cialis on the internet https://site128620615.fo.team/

    You’ve made the point!

  11. https://fwervs.gumroad.com/
    April 19, 2022 at 4:40 pm ·

    medication without a doctors prescription https://fwervs.gumroad.com/

    You said it terrifically.

  12. trosorin.mystrikingly.com
    April 19, 2022 at 9:37 pm ·

    buy cialis online https://trosorin.mystrikingly.com/

    Cheers. Ample knowledge.

  13. https://generic-cialis-20-mg.yolasite.com/
    April 22, 2022 at 1:31 pm ·

    cialis purchase online without prescription https://generic-cialis-20-mg.yolasite.com/

    Effectively voiced truly. .

  14. https://hemuyrt.livejournal.com/325.html
    April 26, 2022 at 12:33 am ·

    cialis 5 mg https://hemuyrt.livejournal.com/325.html

    Valuable knowledge. Thanks.

  15. https://site373681070.fo.team/
    April 26, 2022 at 12:20 pm ·

    buy cialis https://site373681070.fo.team/

    Wonderful posts, Thanks.

  16. buy cheap cialis on line
    April 26, 2022 at 7:37 pm ·

    medication without a doctors prescription https://sehytv.wordpress.com/

    Nicely put, Many thanks!

  17. purchasing cialis on the internet https://ghswed.wordpress.com/2022/04/27/he-final-word-information-to-online-pharmacies/

    You’ve made your point quite effectively!.

  18. canadian pharmacies online prescriptions
    April 27, 2022 at 9:01 pm ·

    top rated online canadian pharmacies https://kerbgsw.mystrikingly.com/

    Very good knowledge. Appreciate it!

  19. canadian pharmaceuticals online
    April 28, 2022 at 2:04 pm ·
  20. canadian pharmacies without an rx
    April 29, 2022 at 10:58 am ·

    canadian pharcharmy online https://kerbiss.wordpress.com/2022/04/27/14/

    Fantastic stuff, Thanks.

  21. https://kertubs.mystrikingly.com/
    Mai 1, 2022 at 11:01 pm ·

    cialis https://kertubs.mystrikingly.com/

    Cheers. I value this!

  22. cialis 5mg https://canadian-pharmaceuticals-online.yolasite.com/

    You said it adequately..

  23. no 1 canadian pharcharmy online
    Mai 3, 2022 at 1:38 pm ·

    canadian pharmacy cialis https://online-pharmacies0.yolasite.com/

    Thank you. I appreciate this!

  24. https://deiun.flazio.com/
    Mai 4, 2022 at 3:15 pm ·

    cialis https://deiun.flazio.com/

    Regards! Ample knowledge!

  25. kertyun.flazio.com
    Mai 4, 2022 at 11:48 pm ·

    cialis tablets https://kertyun.flazio.com/

    Awesome content. With thanks.

  26. buy cialis without a doctor’s prescription https://kerntyas.gonevis.com/the-mafia-guide-to-online-pharmacies/

    This is nicely put! .

  27. kerbnt.flazio.com
    Mai 5, 2022 at 7:12 pm ·

    cialis tablets https://kerbnt.flazio.com/

    Nicely put, With thanks!

  28. nanos.jpjmp?url=cialisonlinei.com
    Mai 6, 2022 at 1:20 am ·

    cialis 5mg prix http://nanos.jp/jmp?url=http://cialisonlinei.com/

    You actually mentioned that fantastically!

  29. ime.nucialisonlinei.com
    Mai 6, 2022 at 11:54 am ·

    tadalafil 5mg http://ime.nu/cialisonlinei.com

    Terrific data, Cheers.

  30. kerntyast.flazio.com
    Mai 7, 2022 at 3:51 pm ·

    cialis without a doctor’s prescription https://kerntyast.flazio.com/

    Thank you. Numerous knowledge.

  31. canadian pharmacy viagra brand
    Mai 8, 2022 at 1:54 pm ·

    drugs for sale https://gewrt.usluga.me/

    Whoa loads of valuable advice.

  32. canadian pharmacy world
    Mai 9, 2022 at 5:21 pm ·

    northwest pharmacy canada https://pharmacy-online.webflow.io/

    Superb stuff. Cheers.

  33. canadian-pharmacy.webflow.io
    Mai 9, 2022 at 11:53 pm ·

    cialis uk https://canadian-pharmacy.webflow.io/

    Info nicely taken!!

  34. cialis canadian pharmacy
    Mai 10, 2022 at 10:01 am ·

    canadian pharmacies that are legit https://site273035107.fo.team/

    Very good stuff. Many thanks!

  35. pharmacy
    Mai 10, 2022 at 6:22 pm ·

    canada pharmacy online https://site656670376.fo.team/

    You expressed it perfectly!

  36. site561571227.fo.team
    Mai 11, 2022 at 4:33 am ·

    cialis 20mg prix en pharmacie https://site561571227.fo.team/

    Truly all kinds of good material.

  37. site102906154.fo.team
    Mai 11, 2022 at 10:37 am ·

    cialis canada https://site102906154.fo.team/

    Wow tons of good knowledge!

  38. https://hekluy.ucraft.site/
    Mai 11, 2022 at 4:37 pm ·

    cialis purchase online without prescription https://hekluy.ucraft.site/

    Great material. Many thanks!

  39. https://kawsear.fwscheckout.com/
    Mai 12, 2022 at 3:08 am ·

    cialis generico online https://kawsear.fwscheckout.com/

    Useful write ups. Appreciate it!

  40. hertnsd.nethouse.ru
    Mai 13, 2022 at 5:28 pm ·

    tadalafil 20mg https://hertnsd.nethouse.ru/

    Excellent knowledge. Thank you!

  41. canadian pharmacies mail order
    Mai 14, 2022 at 5:26 pm ·

    highest rated canadian pharmacies https://uertbx.livejournal.com/402.html

    Tips very well used!.

  42. lwerts.livejournal.com276.html
    Mai 14, 2022 at 11:44 pm ·

    buy generic cialis https://lwerts.livejournal.com/276.html

    Whoa lots of very good info!

  43. avuiom.sellfy.store
    Mai 15, 2022 at 3:50 pm ·

    Generic cialis tadalafil https://avuiom.sellfy.store/

    You have made the point.

  44. canada online pharmacies
    Mai 16, 2022 at 3:49 am ·

    legitimate canadian mail order pharmacies https://pharmacies.bigcartel.com/

    Nicely put. Cheers.

  45. https://kwersd.mystrikingly.com/
    Mai 16, 2022 at 5:16 pm ·

    cialis 20mg https://kwersd.mystrikingly.com/

    Factor nicely regarded..

  46. gewsd.estranky.skclankydrugstore-online.html
    Mai 16, 2022 at 11:16 pm ·

    cialis 5mg https://gewsd.estranky.sk/clanky/drugstore-online.html

    You mentioned this really well.

  47. northwestpharmacy
    Mai 17, 2022 at 7:41 pm ·

    online canadian pharmacies http://site592154748.fo.team/

    Superb postings. Thank you.

  48. cialis 20mg prix en pharmacie https://lasert.gonevis.com/recommended-canadian-pharmacies-2/

    Appreciate it! Lots of posts!

  49. aonubs.website2.me
    Mai 18, 2022 at 9:01 pm ·

    cialis canada http://aonubs.website2.me/

    This is nicely expressed. !

Leave a reply

Back to Top