Example DV project: Term Frequency Analysis — Oracle Analytics

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

Example DV project: Term Frequency Analysis

Received Response
61
Views
3
Comments
Alan Walsh
Alan Walsh Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Example DV project: Term Frequency Analysis

Content

Upgraded to v4 today - lots of new features - the machine learning particularly interested me so I downloaded the above from the OA Library, the project and data are fine when I try to inspect or run the associated script ('Term frequency analysis (py)') I am getting a 'General error was found', tried full un-install and re-install.

Detailed script when running query...

Error occurred while processing the query.
select "term" as "term", "frequency" as "frequency"
from EVALUATE_TABLE_SCRIPT('''weblogic''.''Term Frequency Analysis (py)''', 'topn=25;includeInputColumns=false;', Select "Claim Description" as "text" from (select "Claim Id" as "Claim Id", "Dealer" as "Dealer", "Dealer State" as "Dealer State", "Dealer City" as "Dealer City", "Claim Date" as "Claim Date", "Claim Month" as "Claim Month", "Claim Description" as "Claim Description", "Claim Age" as "Claim Age", "Claim Age Bucket" as "Claim Age Bucket", "Vehicle Make" as "Vehicle Make", "Vehicle Model" as "Vehicle Model", "Veh. Drive Train" as "Veh. Drive Train", "Veh. Months In Service" as "Veh. Months In Service", "Num Cyls" as "Num Cyls", "Veh. Prod. Month" as "Veh. Prod. Month", "Veh. Prod Date" as "Veh. Prod Date", "Veh. Build Region" as "Veh. Build Region", "Veh. Id VIN" as "Veh. Id VIN", "Labor Task" as "Labor Task", "Commodity Part" as "Commodity Part", "Part Supplier Country" as "Part Supplier Country", "Part Supplier State" as "Part Supplier State", "Part Supplier" as "Part Supplier", "Num of Claims" as "Num of Claims", "Labor Cost" as "Labor Cost", "Parts Cost" as "Parts Cost", "Total Cost" as "Total Cost"
from XSA('weblogic'.'Auto Insurance Claims').input."Auto Insurance Claims") ApplyScript_0_Internal) FETCH FIRST 30 ROWS ONLY

Answers

  • Olivier Sinquin
    Olivier Sinquin Rank 4 - Community Specialist

    have you installed the new DVML thing (and possibly the Advanced Analytics thing too)?

    2017-11-02 17_26_32-Greenshot capture form.png

  • Olivier Sinquin
    Olivier Sinquin Rank 4 - Community Specialist

    I had not seen the requirement either :-)

    A colleague told me about it after I had banged my head on the wall for a few hours.

    I agree that if we can't install DVML with DVD for licensing reasons (which I doubt because getting rid of the GNU licensing constraint was the point beyond moving from R to Pyhton) then they should put some type of message or warning, like they did for Advanced Analtycs (AKA R )

  • Alan Walsh
    Alan Walsh Rank 3 - Community Apprentice

    I haven't - didn't spot that as a requirement, with the advanced analytics it gives you a clue that you need to do something else, the general error message isn't very helpful. I'll give it a go and advise on update (feeling slightly dim for not spotting it )