how to compare data in OAC from a data set and a subject area which is having a primary key connection (eg: project number). DO you have any related document for the same?
Hi,
You mean by having a dashboard in which you display one source, the other source and various deltas between the 2?
Or more about comparing if the full content of the dataset is the same as what the subject area returns without looking at the meaning of the data (more like a technical comparison than a functional one)?
Any extra detail in what you have in mind will help in giving you some possible ideas.
its more about comparing the data (2nd option)
For that case, what you could do, is to use a data flow doing the comparison between columns.
Doing first a unique to Input 1 and then a unique to Input 2 or common rows and counting them and things like that.
You can then save the result in a dataset and that will tell you how the 2 inputs are the same or not.
You can also probably do it directly in a dataset making it based on a LSQL query where you do the matching between the 2 sources.
I will say it depends if this is a one-time job or something you want to do regularly and do something with that information.
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.
