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

Executing a SQL query on a dataset within OAC?

Received Response
44
Views
3
Comments
User_N4O6X
User_N4O6X Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Is it possible to executing a SQL query on a dataset within OAC to generate a table as a result?

Answers

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

    You can run a logical sql query on a dataset just like you see in the query logs. What is the requirement here you are trying to satisfy?

  • User_N4O6X
    User_N4O6X Rank 2 - Community Beginner

    I have created the dataset from a connection to Oracle ADW. I have a set of pre-built SQL queries that I would like to run on this dataset directly in OAC to create tables to my canvas. I am not proficient in SQL.

    I ran the below query on the "focus table table" in ADW. But I want to run this query (and others) against the dataset that was created from that table in OAC

    sample query:

    SELECT  BillingPeriodStart,  ProviderName,  SubAccountId,  SubAccountName,  ServiceName,  SUM(BilledCost) AS TotalBilledCost,  SUM(EffectiveCost) AS TotalEffectiveCostFROM focus_data_tableWHERE ServiceName = ?  AND BillingPeriodStart >= ? AND BillingPeriodStart < ?GROUP BY  BillingPeriodStart,  ProviderName,  SubAccountId,  SubAccountName,  ServiceNameORDER BY MonthlyCost DESC
  • User_N4O6X
    User_N4O6X Rank 2 - Community Beginner

    did this use case make sense? any thoughts?