Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to audit an OTBI report if few columns have null data for a record.

Received Response
2
Views
1
Comments

How to audit an OTBI report if few columns have null data for a record. 

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Aug 24, 2023 4:02PM

    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?