Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Data Prep Steps on Entire Dataset

Under Review
31
Views
2
Comments
Branden Pavol
Branden Pavol Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server Idea Lab

I'm using a Group step in Data Prep and it's not giving me all options. It's only giving me some of them and not all of them.  In my screenshots, you will see I'm grouping every table with the name "argus" in it.  In the data prep step, it's showing only two are available based on the profiling.  When I go to the actual results, there are more.  There should be an option to profile based on the sample size or the entire dataset. Otherwise, I'm forced to do a large case statement.

image.png
image.png

Tagged:
4
Up
4 votes

Under Oracle Review · Last Updated

Comments

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    Year back, it used to work. I have few datasets defined with those options.

    Later it is regressed, and I have filed SR as well.

  • Luis Rivas -Oracle
    Luis Rivas -Oracle Mod

    Hi, as you have already noted, the values shown in the Grouping dialog are based on representative sampling and in some cases, low frequency values in columns will be missed. We are exploring both options to increase the sampling for profiling or allowing full sampling, but we are also exploring options of the dialogs such as grouping and others that depend on the distinct values, query their own values instead of using the sampling from profile. This will allow the random sampling to continue and for the dialogs to get their own values. I'll check to see where we are and report back soon.