Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can obiee filter hotspot words and count on them intelligently?

Received Response
41
Views
10
Comments
1415129
1415129 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:04PM in Oracle Analytics Cloud and Server

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!

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

    OBIEE Samples

  • 1415129
    1415129 Rank 3 - Community Apprentice

    Hi Christian,

         Thanks for your response.

         Is it in one of below pages?  I went through but did not find any text analytics example.

    sample.jpg

    Thanks.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Bose Pandian Rank 3 - Community Apprentice

    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
    1415129 Rank 3 - Community Apprentice

    @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]
    [Deleted User] Rank 2 - Community Beginner

    Yeah. Word clouds or some R.

  • 1415129
    1415129 Rank 3 - Community Apprentice

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

  • 1415129
    1415129 Rank 3 - Community Apprentice

    Hi Christian,

        I found the text analytics page as below.

        20170324172830.jpg 

         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
    Gianni Ceresa Mod

    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
    Pedro F Rank 6 - Analytics Lead

    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.