Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Example DV project: Term Frequency Analysis
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
-
have you installed the new DVML thing (and possibly the Advanced Analytics thing too)?
0 -
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 )
0 -
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 )
0