Database table
Enter “PurchaseOrder” in the Search text box in the upper right.
As you see, the PurchaseOrder table in dbo schema in the Staging DW model is first in the list because it is certified.
Select the PurchaseOrder table in the FinanceDWStaging.sql catalog, in dbo schema in the Staging DW model.
There is a downward facing caret allowing you to expand or contract each section/widget in the object page Overview tab.
Tables in a database generally have a great deal of related information in tabs. For example, we have:
- Related Reports
- Columns contained within this table
- Data Sample
- Relationships including PK/FK, inferred and user-defined relationships with other tables. Especially important when joining this table with others, such as in a self-service BI tool.
The numbers next to the tab headings, e.g., Columns 7, indicate how many items are under that tab.
For other tabs, like Data Flow or Semantic Flow, we see arrow indicators showing what lineage reports are available.
Search for POLineItemView in the same model.
Click MORE on the value presented in the View Statement.
One may always either click MORE or right-click and select Show value to see details in the attributes listings which are longer than can be displayed on the object page itself.