Is it possible to executing a SQL query on a dataset within OAC to generate a table as a result?
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?
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
did this use case make sense? any thoughts?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
