Hi Christian, I found the text analytics page as below. As it is saied text to token was done by datamining workflow. It seems this is pre-bulit by ETL. then can be used in reporting. Not by real-time text analytics on text field, am i right? Regards,

Thanks,Christian. So in the SampleApp VM, can the text analytics example meet my requirement?

@S0081 Hi, Actually we can not know the hotspot words. We want obiee detect the what is the hotspot words and COUNT on them. Thanks.

Hi Christian, Thanks for your response. Is it in one of below pages? I went through but did not find any text analytics example. Thanks.

Hi Pangul, What you said is for standard funnel chat, not Last-stage Only. Expected value is caculated by obiee automatically. That's what i am trying to find out. Correct me if misunderstood you. Thanks and Regards Alv

Yes, i have not found any docs on how to caculate this. That is what i am looking for.

@Gianni Ceresa @Christian Berg, Thank you all. Actually, we have a very wired situation, we can not rely on our DBA team. I am trying to find some way to optimize our biee model, like joins, indexs etc by checking the SQL execution plan. Alvin