CRM and CX Blogs by SAP
Stay up-to-date on the latest developments and product news about intelligent customer experience and CRM technologies through blog posts from SAP experts.
cancel
Showing results for 
Search instead for 
Did you mean: 
2,300
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 Foun...

 
24 Comments
SCHNEIDERT
Active Contributor
0 Kudos
Hi lekhak

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
SCHNEIDERT
Active Contributor
Nice... shortly after I asked you, the export was completed (after I waited the whole night :-D). So you can forget what I said 😐
AndrejBergant
Explorer
0 Kudos
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
SCHNEIDERT
Active Contributor
0 Kudos
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
sguerra
Explorer
0 Kudos


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

0 Kudos
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
ilonka
Explorer
0 Kudos
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

ilonka
Explorer
0 Kudos
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...

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.
0 Kudos

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-view...

 

Regards,

Lekhak Patil

ilonka
Explorer
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
sguerra
Explorer
0 Kudos
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"?.


 

Thanks in advance,

Sael Guerra
0 Kudos
Yes
I040107
Advisor
Advisor
0 Kudos
I'm having the same issue ... still working to fix it .
former_member720502
Discoverer
0 Kudos
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
former_member720502
Discoverer
0 Kudos
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 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

 
ilonka
Explorer
0 Kudos
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
former_member720502
Discoverer
0 Kudos
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
former_member334571
Participant
0 Kudos
Hi lekhak ,

 

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,
chholzermsg
Participant
Hi lekhak ,

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
vervinckt_joyca
Active Contributor
0 Kudos
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... 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/6bbad66475... 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!
chholzermsg
Participant
0 Kudos
Hi vervinckt.joyca

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

Regards

Christian
vervinckt_joyca
Active Contributor
0 Kudos
Thanks for that info chholzer . I just checked how to get that HANA Express. But it seems like I need a Linux virtual machine for that :s
chholzermsg
Participant
0 Kudos
Hi vervinckt.joyca

correct. I use Oracle VirtualBox VM for this.

This works without any issue.
vervinckt_joyca
Active Contributor

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_c... 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.