Using Page Prompts in the Data Lineage Dashboards
Each page in the Data Lineage dashboards has a unique set of page prompts, a filtering device that enables you to refine the results of the page report. Each page has a set of default prompt values that are populated when you initially access the page.
All page prompts use a cascading filter design; when a value is changed in one of the prompts, the filter is automatically applied to the subsequent prompts, thus restricting the available values in those filters. For example, the Record page prompt in the Field Impact Analysis page allows you to initially select several records:
Image: data_lineage_prompt1
data_lineage_prompt1
However, after selecting ’Admissions and Recruiting’ for the Mart prompt, only the PS_D_RECRTR record is available for the Record page prompt:
Image: data_lineage_prompt2
data_lineage_prompt2
To modify the prompts, you can type a value directly into the prompt field or use the drop down to search for values. For cascading prompts, you must delete the prompt values for all dependent prompts. When finished, use the Apply button to view your results.
You can use the Reset button to reset the prompt values to the recently applied or recently viewed prompt values. The Clear Prompts button clears all selected prompt values and returns prompt values to default settings.
Note: Some page prompts are required and report results will not display without these prompt values. See below for a list of these values.
The following tables provide a list of page prompts and indicate whether prompt values are required:
Field Impact Analysis Page
Prompt |
Required Value? |
---|---|
Field Name – Description |
Yes |
Warehouse |
No |
Mart |
No |
Record |
No |
Field Lineage – High Level Page
Prompt |
Required Value? |
---|---|
Field Name – Description |
Yes |
Warehouse |
No |
Mart |
No |
Record |
Yes |
Server Job |
Yes |
Field Lineage – Detail Level Page
Prompt |
Required Value? |
---|---|
Field Name – Description |
Yes |
Warehouse |
No |
Mart |
No |
Record |
Yes |
Server Job |
Yes |
EPM Record Details Page
Prompt |
Required Value? |
---|---|
Warehouse |
No |
Mart |
No |
Record |
Yes |
Server Job |
Yes |
Job Run Dependencies Page
Prompt |
Required Value? |
---|---|
Warehouse |
No |
Mart |
No |
Record |
No |
Server Job |
Yes |
Dashboard Analysis Page
Prompt |
Required Value? |
---|---|
Dashboard |
No |
Dashboard Page |
No |
Report |
No |
Physical Table |
No |
Physical Column |
No |
Repository Details Page
Prompt |
Required Value? |
---|---|
Subject Area |
No |
Presentation Table |
No |
Presentation Column |
No |
Physical Table |
No |
Physical Column |
No |