Skip to Content
Author's profile photo Sreehari V Pillai

Supplier & Product Rating based on Customer Feedback : HANA Sentiment analysis


With this quick blog I am explaining how to implement a supplier rating application using the Text Analysis capabilities of SAP HANA. I am using Sentiment analysis feature to rate a particular product and suppliers based on the customer feedback on various web sites .


We have the customer feedback collected from suppliers and arranged in the following format. (data is copied from multiple online suppliers. Product names and supplier names are masked )

data strucure.JPG

Modelling your source Table

     Now we need to load the data into SAP HANA. For that, We are creating a table of the same structure .


After once the data is loaded into the source table, we are creating a full text index on the table for the FeedbackText column using the standard configuration “EXTRACTION_CORE_VOICEOFCUSTOMER“.

Voice of the customer content includes a set of entity types and rules that address requirements for extracting customer sentiments and requests. You can use this content to retrieve specific information about your customers’ needs and perceptions when processing and analyzing text. The configuration involves complex linguistic analysis and pattern matching that includes processing parts of speech, syntactic patterns, negation, and so on, to identify the patterns to be extracted.

Once the index is created , one new columnar table will be created in the same schema where the source table is created. This table will be having the tokens as well as the corresponding sentiments values .


Now generating some visualizations on the generated sentiment data.


SAP Lumira For Reporting

Now we have the sentiment data available in our table. That means, we have the product details, Supplier details, and the type of feedback given by the customers . Now we will generate dashboard(Real time dashboards on LUMIRA if we integrate it with live feedback data on multiple web sites) .

Pie Chart.JPG

And I love this part šŸ™‚

I love this part.JPG

(This blog is created for DataGeek ).


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ishan Mukewar
      Ishan Mukewar


      Hi Sreehari,

      Very helpful blog! I am seeking for a logic forĀ the calculation viewĀ in which TA_TYPE will work as a measure having couple of values likeĀ PositiveĀ Sentiment and Negative Sentiment based on which TA_TOKEN will show values in the graph.



      Kind Regards,

      Ishan Mukewar

      Author's profile photo Sreehari V Pillai
      Sreehari V Pillai
      Blog Post Author

      Thanks. can you post a sample output in table as expected. I am too lazy to read my blog again. Its been a long time šŸ™‚