Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Some tables cannot be used in reports
Answer ID 9089 |
Last Review Date 03/18/2019
How do I know which table columns be used in reports?
Environment:
Analytics, Data Dictionary
Oracle B2C Service, All versions
Issue:
As one example, fields related to SSO are not accessible in reports.
Resolution:
There are some tables that are not meant to be used for reporting purposes. You can check this by accessing Data Dictionary. If "Analytics Usage" is not present under "Column Information" then the column cannot be used with analytics.
To help illustrate:
- In the following table can be used in analytics:
- In this table, the "Analytics Usage" section is missing. This indicates this table cannot be used in analytics:
For more information, refer to Answer ID 2611: Accessing the data dictionary.