nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Can obiee filter hotspot words and count on them intelligently?

1415129

Hi experts,

Can obiee have such function as below:

there is a field with text type named NOTE, user want to a report which will display hotspot words and it's occurrence number in database records intelligently base on this field value.

User could not predict hotspot words.

Thank you!

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

If you have a look into SampleApp there are text analytics examples in there including word clouds.

OBIEE Samples

1415129

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.

[Deleted User]

I mean the full blown SampleApo Virtual Machine. Not the "Lite" demo that comes with a base install.

At the moment there is no public image runnig but you can just download the VM, deploy it in Virtualbox and then use anything you want from in there

Bose Pandian

Hi,

There is a string function LOCATE that will helps us to identify particular text in columnand then we can apply COUNT on top of it.

for e.g COUNT(LOCATE("Table"."Column",'ING'))

The above example will count the repetition of the value 'ING' in the table field.

Hope it helps!

1415129

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

[Deleted User]

Yeah. Word clouds or some R.

1415129

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

1415129

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,

Gianni Ceresa

Hi,

For word clouds there must be an example in SampleApp using Oracle Database 12c functions (something they added in the 12c release and the highlighted the use in OBIEE SampleApp) or you can also use R to produce it.

Both these 2 things are done at the time you open your analysis/dashboard page.

Isn't that what you look for?

OBIEE can use R and if you google R + word clouds you get quite a few result, and for the DB 12c functions I would have to search in SampleApp to find the reference.

Pedro F

If you're using an Oracle database, you can use Oracle Text to do that for you, it isn't really that complicated and you can easily create a table that counts the number of occurrences of each word in a specific database column.

In this example here, it's shown how it's done against documents but you can do it using database tables and specific columns as well, just take a look at the Oracle documentation for Oracle Text.

PS: Never checked what Sample App does, so it may just be the case that they already do something similar.