This is very strong and important features of SAP HANA.

Follow some steps to implement Sentimental analysis.I am using my previous Blog  data for Sentimental analysis

Following are the steps to implement Sentimental analysis.

1.Create a column table

Sentimental Analysis only takes VARCHAR,NVARCHAR,NCLOB,CLOB,BLOB for applying analysis on the text or document column.


Sentimental Analysis supported  only for English, French , German, Spanish , Chinese.

CREATE COLUMN TABLE “TEST”.”TEST” (ID NVARCHAR(50), TEXTANA NVARCHAR(5000), PRIMARY KEY(ID))


“TEST”.”TEST”— > SchemaName.TableName

2.Insert some records into Test table


insert into “TEST”.”TEST” values(‘1′,’Barely hours after sitting on a hunger strike at the Jantar Mantar in Delhi’)

insert into “TEST”.”TEST” values(‘2′,’off-spinner Ravichandran Ashwin admitted that India have been below par in the ODIs against New Zealand and they want to avoid another series defeat when they face the Black Caps in the fourth ODI here Tuesday.’)

insert into “TEST”.”TEST” values(‘3′,’Ashwin said the tied match at the Eden Park in Auckland was disappointing.’)

insert into “TEST”.”TEST” values(‘4′,’Pune weather is good’)

insert into “TEST”.”TEST” values(‘5′,’Bangalore weather is also good’)

insert into “TEST”.”TEST” values(‘6′,’good better best’)


3.

a.Create FullText Index “TEST”.”SENTIMENT” On “TEST”.”TEST”(“TEXTANA“)

TEXT ANALYSIS ON

CONFIGURATION ‘EXTRACTION_CORE_VOICEOFCUSTOMER‘;


b.Create FullText Index “TEST”.”SENTIMENT” On “TEST”.”TEST”(“TEXTANA“) ASYNC FLUSH EVERY 1 MINUTES LANGUAGE DETECTION (‘EN’) TEXT ANALYSIS ON;

Both above SQL query are same in one we are asking to SAP HANA engine to put the synchronization by default and in second we are using ASYNC<Asynchronous>  .Don’t confuse  when you are trying to execute the query.

4. Once you will execute the query which is mention in Step 3, SAP HANA will generate the Analysis table in the same schema where your source table reside.

5.You will find another table with the prefix $TA_TEST_ANA which will contain the results. Please check the attachment for result table.

6.This analysis will give you the positive,negative,neutral sentiment of your text or document. Just for example take below text

‘bad good best’

bad- StrongNegativeSentiment

good-WeakPositiveSentiment

best-StrongPositiveSentiment


We can use sentimental Analysis to read the customer’s sentiment about the products or etc.

Please check the out put table.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

    1. navin c

      Hi Rahul,

      I would like to know more about this feature . we have a similar requirement in our org.

      Will you be able to share your email id for further clarifications.

      (0) 
  1. Ranjit Alapati

    Hi Colleagues,

    There is a feature/product(Social Intellignece) available in SAP Business Suite which does the sentiment calculation on data from Social Media Channels and provides the results.

    There is Fiori App ‘Analyze Sentiments’ from SAP which can display the analysis in a graphical way.

    More details are here

    http://scn.sap.com/community/mobile/blog/2014/04/15/understanding-saps-connector-to-datasift-in-5-questions

    http://scn.sap.com/community/mobile/blog/2014/03/17/understanding-sap-fiori-application-analyze-sentiment-in-5-questions

    Best Regards,

    Ranjit

    (0) 

Leave a Reply