Pre-General Availability: 2023-04-04
Viewing Entity Details
To view details about an entity, click the 
Actions icon at the right of the entity entry, then click View
Details.
For all entities, the details include Lineage and Impact sections. The inclusion of other details, such as Preview and Statistics, varies by entity type.
Preview
Preview displays the data of the entity. For a table, the Preview displays the columns of the table and the data in those columns. You can sort the data in the column into ascending or descending order by clicking the up or down arrow to the right of the column name.
Describe
For an analytic view, the Describe tab has information about the entity, and displays the hierarchies, levels, level depth, dimension tables, level columns, and number of distinct values for a level.
Lineage
Lineage displays all known information about the upstream dependencies of the entity, and therefore how the entity was created and how it is linked to other entities.
For example, for a table that you created in your database, the lineage is just the table. For a table that you created by loading a CSV file from cloud storage, the lineage includes the ingest directive for the data load and the CSV file that is the source of the data.
Pointing to the name of an item in the lineage displays the table name, the application that created it, the type of entity, the path to it, and the schema it is in.
Arrows point from an entity to the entity that it derives from. For example, for a table created in a data load job, an arrow points from the table to the ingest job and an arrow points from the ingest job to the CSV file. If you point to an arrow, then a Links Information box appears that shows information about the relationship between the two entities.
To view more details about an item, click the Actions icon for the item, then click Expand. For a table, the columns of the table are displayed. Pointing to the name of the table or of a column displays the name, application, type, path, and schema of the table or column. To collapse the display, click the Actions icon, then click Collapse.
You can increase or decrease the size of the displayed objects by using the + (plus) and - (minus) keys. You can reposition the objects by grabbing a blank spot in the display and dragging vertically or horizontally.
The lineage for some entities, such as analytic views, is more complex. An analytic view entity deployed for a business model has links to columns in a fact table and to hierarchies. The fact table has links to attribute dimensions and, for a data load job, to an ingest directive for the job. The ingest directive has a link to the source file. The attribute dimensions have links to tables for the dimensions. Those tables have links to ingest directives that have link to source files.
Impact
Impact shows all known information about the downstream use of an entity, and therefore how a change in the definition of an entity may affect other entities that depend on it. For example, if a table is used in an analytic view, a change to one of the column definitions in the table may affect the mapping from that column to the analytic view.
Classifications
For an analytic view and its attribute dimensions, hierarchies, and measures, the Classifications tab displays classifications and their values. Classifications are metadata that applications can use to present information about analytic views. When creating a business model, you may specify the values for the Caption and Description classifications.
Optimize
For an analytic view, the Optimize tab has information about caches created for the analytic view. A cache may exist if the advanced option Enable Autonomous Aggregate Cache was selected for the business model for which the analytic view is deployed.
Statistics
Statistics display information about the entity. For example, the statistics for a table include the size of the table and the numbers of rows and columns. They also include the names of the columns, their data types, the number of distinct values and null values, the maximum and minimum values, and other information.
The data is represented in the form of histogram which is column statistic which provides more detailed information about data distribution in a table's columns.
- Frequency: In a frequency histogram, each distinct column value corresponds to a single bucket of the histogram. Since each value has its own dedicated bucket, some buckets may have many values, whereas others have few.
- Top-frequency: A top frequency histogram is a variation on a frequency histogram that ignores non-popular values that are statistically insignificant
- Height-Balanced: In this histogram, column values are divided into buckets so that each bucket contains approximately the same number of rows.
- Hybrid: A hybrid histogram combines characteristics of both height-based histograms and frequency histograms. This approach enables the optimizer to obtain better selectivity estimates in some situations.
Data Definition
Data Definition displays the Oracle Autonomous Database DDL that created the entity.
Share entity
To include an entity in one or more shares, click the Actions icon at the right of the entity entry and select Share.
- Select the existing share: Click on any of the available shares in the list below. The list displays the name of the share and the tables shared with it. For example, Share1. Click New Share to create a new share. Selecting New Share opens a create share wizard. Refer to the Create Share section of the document for more information.
- Input the Schema Name: Enter the schema name in which you wish to add the selected entities in the selected or newly created shares. For example, TEST.
Click OK.
After a successful update, you will view that the Share1 will add Table in the TEST schema.
Note:
You can utilize share only for table entities on condition that you have access to provide a share.