Skip to Content
Product Information

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

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:

Create HANA 2.0 Custom View in SAP Web IDE using Cloud Foundry HANA Trial 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

 

4 Comments
You must be Logged on to comment or reply to a post.
  • 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

  • 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

    • 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