Oracle Analytics Cloud and Server Idea Lab

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

Auto Insights for Subject Area

Needs Votes
281
Views
8
Comments

Allow users to have Auto Insights for Subject Area. Currently it's only available for Datasets.

18
18 votes

Needs Votes · Last Updated

Comments

  • Doug Ross
    Doug Ross Rank 5 - Community Champion

    Would you expect this to be set on a subject area basis? some of our subject areas have multi hundred million row fact tables which wouldn't seem to be good candidates.

  • @Doug Ross yes - I believe product development will have to provide some kind of fine grain permissions and ability to enable/disable based on the subject area, basically like the option we have for dataset.

  • raviagr7052
    raviagr7052 Rank 1 - Community Starter

    Yes this functionality is needed to fully leverage tool.

  • ManishHathi
    ManishHathi Rank 3 - Community Apprentice

    I think insights on subject area seems like a no-brainer functionality until you consider that the underlying data volume could be huge as someone mentioned earlier. But the platform could provide some configuration options where you could enter say profile 5K rows per table involved for Fact tables, but I can see how this can get messy.

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Subject areas are tipically designed to help people answering questions that they already know (no need for serendipity imo) and the amount of data is generally way bigger than datasets. Having auto insights applied to a whole subject area will surely lead to performance issue and people complaining about it.

    As an alternative, you can already create a dataset based on a subject area and get auto insights for it. If you find something useful, you can add the insight/visualization to the workbook and eventually replace the dataset with the original subject area.

  • peacey
    peacey Rank 3 - Community Apprentice

    Frederico - I understand your alternative - create a dataset from a subject area, get an auto insights from it then rewrite these against original subject area. Wouldn’t it be nice though if I could get a computer to do all that leg work….
    Clearly Select * from subject area isn’t possible. But selecting individual measures and getting insights on these by available dimensions is what is needed.

  • Prashant Chawla
    Prashant Chawla Rank 1 - Community Starter

    Need this functionality for making proper use of the tool.Since most of the security aspect in built in SA and things are centrally controlled, auto insights would be a great feature to look at different viz available.