Skip to Content
Product Information
Author's profile photo Lekhak Patil

Exporting Whitelisted Content and Importing it to SAP Web IDE (Cloud Foundry account)

Disclaimer: The information is not up to date.

With SAP Marketing Cloud you are able to import own SAP HANA Views by using the SAP Fiori App “Add Custom View”.

This blog post will tell you steps you need to carry out to build the HANA Calculation Views.

On opening the “Add Custom Views” application, you are informed that HANA views would be migrated to HANA 2.0. Post-migration, you can only import views that are modelled using HANA 2.0 Modeller ( SAP Web IDE)

In this blog post, you can see how to export all whitelisted content and how to import it to SAP Web IDE.

 

Part 1: Export HANA 2.0 Whitelisted Content

With SAP Marketing Cloud you can export all whitelisted content by using the Export All option in the Add Custom Views application (This option is available after upgrade to HANA 2.0 version).

 

Exporting will take some time as all whitelisted content along with their dependencies, all uploaded custom views, whitelisted Tables, CBO Tables are exported.

At the end of the process, MKT_Metadata.zip file is downloaded to your local system.

 

Part 2: Import the Whitelisted HANA Calculation Views with Dependencies in SAP Web IDE

For details on setting up the  Cloud Foundry Trial Account using SAP Web IDE refer:

Exporting Whitelisted Content and Importing it to SAP Web IDE (Cloud Foundry account)

 

a. Import the downloaded zip into your workspace by choosing Import > File or Project.

The imported file looks like the below screenshot:

b. Right-click on the folder hdbtables.Choose Build > Build Selected Files to build downloaded hdbtables.

Once the build is successful, you can see the message below:

c. To build the downloaded HANA 2.0 views, right-click on the folder sap. Choose Build > Build Selected Files.

Once the build is successful, you can see the message below:

 

Till now we have learned how to export whitelisted content from SAP Marketing Cloud, how to import it to SAP Web IDE, and how to activate the whitelisted content in SAP Web IDE.

To create new custom views and import it back to SAP Marketing Cloud, refer

Working with HANA 2.0 white listed content and building custom views in SAP Web IDE using Cloud Foundry account

 

Assigned Tags

      24 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Tobias Schneider
      Tobias Schneider

      Hi Lekhak Patil

      like your Blog Series! 🙂

      I wanted to export the content from our test tenant. But do you know how long it might usually take to export the Whitelisted Content?

      I tried to export but nothing happens. It only shows "Please wait while the content is being exported..." The system remains in that status for hours.

      Do you think I have to open an incident for that?

      BR Tobias

      Author's profile photo Tobias Schneider
      Tobias Schneider

      Nice... shortly after I asked you, the export was completed (after I waited the whole night :-D). So you can forget what I said 😐

      Author's profile photo Andrej Bergant
      Andrej Bergant

      Hi,

       

      I have a problem when trying to build the hdbtables folder.

      Below is the error log. Does anyone have an idea how to fix this?

      .....

      13:46:26 (HDB) Precompiling "src/sap/hana-app/prodreco/samples/CA_INTERACTION_INTEREST.hdbcalculationview"... ok (0s 2ms) Precompiling "src/sap/hana-app/prodreco/samples/CA_OFFER_BY_LOCATION_RUNTIME_PF.hdbcalculationview"... ok (0s 3ms) Precompiling "src/sap/hana-app/prodreco/internal/CA_D_CUAN_PRODUCT_VARIANT_TO_BASE_MAP_GENERIC.hdbcalculationview"... ok (0s 4ms) Precompiling "src/sap/hana-app/prodreco/samples/CA_TG_MEMBER_ID_IC_KEY_PF.hdbcalculationview"... ok (0s 2ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/topn/CA_GET_TOPN_CURRENT_CAT.hdbcalculationview"... ok (0s 6ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/topn/CA_DYN_TOP_N_CURRENT_CAT_GENERATE_MODEL.hdbcalculationview"... ok (0s 8ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/mostrecent/CA_RECO_GENERATE_RECENT_USER_ITEM.hdbcalculationview"... ok (0s 13ms) Precompiling "src/sap/hana-app/prodreco/algorithm/postfiltering/basketremoval/CA_FILTER_SOLD_ITEMS_INTERACTIONS.hdbcalculationview"... ok (0s 13ms)
      13:46:26 (HDB) Precompiling "src/sap/hana-app/prodreco/algorithm/query/offers/CA_RECO_ELIGIBLE_OFFERS_LEADING_PRODUCT_CATEGORY.hdbcalculationview"... ok (0s 12ms) Precompiling "src/sap/hana-app/prodreco/algorithm/association/apriori/modelgeneration/CA_GENERATE_ASSOC_SQL_TRX_ITEM.hdbcalculationview"... ok (0s 14ms) Precompiling "src/sap/hana-app/prodreco/algorithm/query/topn/CA_GET_TOPN_PARENT_CAT.hdbcalculationview"... ok (0s 8ms) Error: Precompiling... failed [8212133] Error: Calculating dependencies... failed [8212108] Make failed (25 errors, 0 warnings): tried to deploy 292 files, undeploy 0 files, redeploy 0 dependent files Error: Making... failed [8211605] Error: Starting make in the container "RENAULTMKT_HDI_DB_1" with 292 files to deploy, 0 files to undeploy... failed [8214168]
      13:46:26 (HDB) Deployment to container RENAULTMKT_HDI_DB_1 failed - error: HDI make failed [depId].
      13:46:26 (HDB) Error: HDI make failed
      13:46:26 (HDB) (6s 44ms)
      13:46:26 (HDB) Deployment failed with exit code: 1
      13:46:26 (HDB) STRUCTURED LOG CHECKSUM 108d0660be8bfe0b5fdbee8f24a07605250cf3954f3e36ab9b8a5f3caa0d1268
      13:46:26 (HDB) STRUCTURED LOG SIZE1401584
      13:46:26 (HDB) SENDING STRUCTURED LOG
      13:46:26 (HDB) Ended because of error: Deployment failed with exit code: 1
      13:46:26 (HDB) Build command failed : Please check the Problem view for more information.: hdi-build operation failed: Deployment failed with exit code: 1
      13:46:26 (HDB) Build of /RenaultMKT/db failed due to The "task for hdb build" process finished with code 1.

       

      Thanks,

      Andrej

      Author's profile photo Tobias Schneider
      Tobias Schneider

      Hi Andrej,

      are you trying to do the build for the hdbtables folder? Because it looks more like creating the Calculation Views.

      Has the build of hdbtables before been successful?

      BR Tobias

      Author's profile photo Sael Guerra
      Sael Guerra

      Hi,

      Thank you for your information.

      I tried to do you steps exactly but I received this error

      ....
      10:44:46 AM (import) Import request sent
      10:44:57 AM (import) Import request completed successfully
      10:56:06 AM (Executor) The “task for hdb build” process started.
      10:56:06 AM (Executor) Started the “task for hdb build” provision.
      10:56:17 AM (Provision) Service provisioning for module: “/db”
      10:56:17 AM (Provision) Could not create the ‘MKTMetadata-hdidb-S0018316080-work5mGFZedNQHVaPB7j’ instance of the ‘hana’ service type for the ‘hdi_db’ resource.
      CF-ServiceBrokerRequestRejected(10001): Service broker error: Service broker hana-broker failed with: Can not create service instance
      ‘MKTMetadata-hdidb-S0018316080-work5mGFZedNQHVaPB7j’: There is no database available. Ensure that you have a database available in space ‘Dev’ within organization ‘3bc071cdtrial’.
      10:56:17 AM (Provision) Provision fail since one of the provision tasks finished with error.
      10:56:17 AM (Executor) The “task for hdb build” provision finished with an error: Provision failed. See console for more details.
      10:56:17 AM (HDB) Build of /MKT_Metadata/db failed due to Provision failed. See console for more details..
      ....

       

      When I read the error I think "of course there are no steps to create a database in this tutorial, but is it necessary? The WEB IDE in the Import step "create" the database?".

      So I have a question:
      Do we need a previous database creation, to build a table or views?

      Thanks in advance,

      Sael Guerra

      Author's profile photo Lekhak Patil
      Lekhak Patil
      Blog Post Author

      Hi Sael,

       

      Looks like the cloud foundry trial account is not configured properly.

      In entitlements make sure that you added only two items:

      1.SAP HANA Schemas and Containers Trial

      2.Web ide trial

      and nothing else.

      For details on setting up the  Cloud Foundry Trial Account using SAP Web IDE refer:

      Exporting Whitelisted Content and Importing it to SAP Web IDE (Cloud Foundry account)

       

      Regards,

      Lekhak Patil

      Author's profile photo Sael Guerra
      Sael Guerra

      Hi Patil,

      Thank you, I have the two you mentioned, and another as you can see in the following image:

      Should I remove the other "entitlements"?.

      Services%20plans%20configured

       

      Thanks in advance,

      Sael Guerra

      Author's profile photo Lekhak Patil
      Lekhak Patil
      Blog Post Author

      Yes

      Author's profile photo Ilonka Schmidt
      Ilonka Schmidt

      Hi Lekhak,

      I followed the guide for setting up the trial account and

      I only have one subaccount "trial" with the two entitlements

      - SAP HANA Schemas & HDI Containers Trial

      - SAP Web IDE for SAP HANA Development

      However, I am facing the error "You have exceeded the total routes for your organization's quota"  when trying to build the hdbtables. Any idea how to solve the error?

      Thanks and best regards

      Ilonka Plesnivy

      Author's profile photo Ilonka Schmidt
      Ilonka Schmidt

      I found the solution on

      https://blogs.sap.com/2020/05/22/create-hana-2.0-custom-view-in-sap-web-ide-using-cloud-foundry-hana-trial-account-part-1/

      and Halley Rozario feedback dated August 21,2020  to delete the plan hdi-shared in the service SAP HANA Schemas &HDI Containers (Entitlements).

      By now also most of the steps described in the blog Trial Account setup are done automatically. So all the more valid input from Halley to delete the above entry.

      Author's profile photo Lekhak Patil
      Lekhak Patil
      Blog Post Author

      Hi Ilonka,

       

      Good to know that you have got the solution and it is working.

      Kindly follow the below blog for setting up a trial account next time, if required.

      https://blogs.sap.com/2020/10/21/cloud-foundry-hana-trial-account-setup-for-creating-hdi-custom-views-in-sap-web-ide/

       

      Regards,

      Lekhak Patil

      Author's profile photo Ilonka Schmidt
      Ilonka Schmidt

      Hi Lekhak,

      that was the block I followed. However, by now most of the steps described in the block (create sub account, space, entitlements) are done automatically when initiating the trial. (But still great to have your block and the step-by-step description.) Above all, all entitlements are assigned. In my first attempt, I deleted them except the two mentioned in your block and got the above error when importing the export from SMC and running the built.

      So I started from scratch again, meaning I deleted my trial account and initiated it anew. Now I got another error in the built and the solution was the one indicated above.

      So maybe, you want to recheck and - if reproducible - update your block. (Tobias Schneider had a similar issue and also for him the solution worked as well.)

      Best regards

      Ilonka

      Author's profile photo FILIPPO AMBROSINI
      FILIPPO AMBROSINI

      I'm having the same issue ... still working to fix it .

      Author's profile photo Daniel Meissl
      Daniel Meissl

      Hi Filippo,

      could you fix it in the end on your side?

      The recommended solution from Ilonka above to delete the plan hdi-shared in the service SAP HANA Schemas &HDI Containers (Entitlements) lead to following error at my side: No hdi-shared plan available found in this space.

      So as it seems a need this hdi-container.

      Many thanks,
      Daniel
      Author's profile photo Daniel Meissl
      Daniel Meissl

      Hi Lekhak,

      I followed your blog in a very detail manner, but still running in following issue: "You have exceeded the total routes for your organization's quota."

      As it seems Ilonka Schmidt had the same issue, but on our side it does not solve the issue to  delete the plan hdi-shared within Entitlements.

      Any idea how to solve this issue?

      I have deleted the whole subaccount already twice and built everything up from scratch.

      Kind regards,
      Daniel

       

      Author's profile photo CRM Support CRM Support
      CRM Support CRM Support

      Hi Daniel,

      did you only delete the plan "HDI-shared" in SAP HANA Schemas & HDI Containers. You also have SAP HANA Schemas & HDI Containers Trial. There, you should keep it.

      Best regards

      Ilonka

      Author's profile photo Daniel Meissl
      Daniel Meissl

      Hi IIonka,

      thank you for the update. Within trial I kept it and now it worked. As it seems someone on an overall/global layer deleted it, but there I do not have access.

      But finally I have received "build ... completed successfully" and I can jump to next steps to create custom views.

      Thank you for your help.

      Kind regards,

      Daniel

      Author's profile photo Sercan Yemeni
      Sercan Yemeni

      Hi Lekhak Patil ,

       

      When i create a trial account and subaccount via Wizard, I am getting error while i try to build hdbtables folder like below;

      3:46:26 (HDB) Ended because of error: Deployment failed with exit code: 1
      13:46:26 (HDB) Build command failed : Please check the Problem view for more information.: hdi-build operation failed: Deployment failed with exit code: 1
      13:46:26 (HDB) Build of /MKTMetadata/db failed due to The "task for hdb build" process finished with code

       

      I got referenced to start my setup with trial account via CX Works link

      Is it mandatory to apply the steps to create a custom calculation view via this link or enough with this link

      Alternatively, when i create a subaccount to click on "Create Subaccount" and just enable only "SAP HANA Schemas & HDI Containers Trial" and "SAP Web IDE for SAP HANA Development" entitlements, it raiases an error for memory quota limit.

       

      I am looking for your comments,

      Thanks in advance,

      Author's profile photo Christian Holzer
      Christian Holzer

      Hi Lekhak Patil ,

      great blog!

      Unfortunately since SAP will not continue to support Web IDE, this recipe does not work anymore.

      Can you create the same story with the Business Application Studio, too?

      This would be of great help.

      Regards

      Christian

      Author's profile photo Joyca Vervinckt
      Joyca Vervinckt

      aaaah, that's why...

      Indeed on part 1 of this blog on https://blogs.sap.com/2020/08/05/exporting-whitelisted-content-and-importing-it-to-sap-web-ide-cloud-foundry-account/# I had commented that I got stuck.

      Then I read this comment, and then found https://sapui5.hana.ondemand.com/docs/topics/34bfb4531a974bf7be15f5937c7899d8.html#/topic/6bbad66475d040f39df6fbbaabe6f40f.html that indeed the web IDE isn't available anymore...

      So I'd like to know how we can now build our custom views for SAP Marketing Cloud too!

      Author's profile photo Christian Holzer
      Christian Holzer

      Hi Joyca Vervinckt,

      the only way I mange to do this now is using the Web IDE in HANA Express.

      Regards

      Christian

      Author's profile photo Joyca Vervinckt
      Joyca Vervinckt

      Thanks for that info Christian Holzer . I just checked how to get that HANA Express. But it seems like I need a Linux virtual machine for that :s

      Author's profile photo Joyca Vervinckt
      Joyca Vervinckt

      It took a while, but I was able to make it work with Business Application Studio.

      In short, I followed this guide:

      https://developers.sap.com/tutorials/hana-trial-advanced-analytics.html

      but during Step 6, choose "Import" instead of "Clone from Git". Import the file that you export from SAP Marketing Cloud there.

      Then continue with step 7, until 7.4

      on step 7.5, don't deploy the top node immediately. For that step, the hint on https://www.sap.com/cxworks/article/453913143/how_to_model_custom_sap_hana_views_for_sap_marketing_cloud_in_your_browser is important: "build the hdbtables folder always before...".

      There might be an error about a version range, then just click the update button and try again.

      Now, after deploying the hdbtables, I don't seem to be able to deploy the rest of the sap objects though.

      However, I am able to create new custom views (right click on a folder, select New File, then manually name the file something.hdbcalculationview), build the views, and download the .hdbcalculationview file which can be renamed to an .xml file and then imported in SMC. Only tried a very simple custom view now, but it worked. Now I can get started to build the more complex one that I actually need.

       

      Author's profile photo Christian Holzer
      Christian Holzer

      Hi Joyca Vervinckt,

      correct. I use Oracle VirtualBox VM for this.

      This works without any issue.