Skip to Main Content
Return to Navigation

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

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

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