Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to audit an OTBI report if few columns have null data for a record.

How to audit an OTBI report if few columns have null data for a record.
Answers
-
Hi, I do not undestand your question. What do you mean by the verb "audit". https://www.google.com/search?q=define%3A+audit conduct an official financial inspection of (a company or its accounts). "companies must also have their accounts audited""
Maybe you can provide an example. With perhaps some SQL. So if we make it as simple. Like if you select 2 columns from a table fetch 3 rows. Column A is the unique identfier not null with values 1,2,3. Column B is optional null column with values X,null,Y. So row 2 has null data in column B. So what? What do you need to audit it? Do you just need to find which rows have null data in a column. for example, select all t.* from table t where t.B is null order by t.A asc nulls last?
0