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

View data behind a visualization or an element of that visualization

Needs Votes
22
Views
2
Comments
RichardReader
RichardReader Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server Idea Lab

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):IHG


Description (Required):

It would be incredibly useful for a user to be able to interact with a chart or table to be able to see the base data which is making up that value. Currently OAC will only export the data visible on visualization, not the data which makes up that value.

e.g. To be able to right click a cell in a table and explore the rows of data from the dataset which makes up this value. If I have a cell which shows 'Revenue' on a table, it would be great to be able to easily explore all the transactions which are being summed together to calculate the value of 'Revenue'

As we begin to roll out OAC and replace Tableau, this is a frequent request from users as this is available in other systems.


Use Case and Business Need (Required):

This is incredibly valuable in exploring data - particularly transactional data. Currently users are only able to export the entire dataset, this takes time and is inefficient in allowing exploration of data.

Enhancement Request / Service Request:

Tagged:
2
Up
2 votes

Needs Votes · Last Updated

Comments

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    Quick question on the approach. Assuming revenue is coming from a fact table, would you want all columns from that fact table and the grain of the fact table?

    For a chart/table like this:

    Sales Region, Month, Revenue

    North America, Jan-22, 100K

    Would the expansion show all the rows in the fact table for the 100K with all the columns? Or just North America rows with dates at the grain of the table? Or just the Sales regions, date, and revenue columns?

  • RichardReader
    RichardReader Rank 4 - Community Specialist

    TABLE IN WORKBOOK:

    Sales Region, Month, Account, USD

    North America, Jan-22, Revenue, 100K


    DATASET:

    Region, Country, State, Month, TransactionID, AccountType, GLAccount, Description, OrigCurrency, USDAmount


    On Expansion would show:

    Region, Country, State, Month, TransactionID, AccountType, GLAccount, Description, OrigCurrency, USDAmount

    WHERE Region = 'North America'

    and  month = 'Jan-22'


    Hope this makes sense!