Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to compare data in OAC

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?
Answers
-
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.
1 -
its more about comparing the data (2nd option)
1 -
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.
1