Save your work Open Query Explorer and click Row Security query Add these three fields from UD Financial Data Mart to the Data Items pane: Field Name Query Subject Folder Row Level CHARTFIELD1 FIN Row Security Operator ID Descr (name of person) FIN Row Security Row Level Approver/Viewer Flag FIN Row Security Add one Filter and validate it This is a temporary filter to test the query: [Row Level CHARTFIELD1]='CHEM322239' (use the same Speedtype as above) Click the Run menu item and View Tabular Data to verify data is good (The values in Row Level Approver/Viewer Flag are Y and N – we’ll improve this later.) Disable the temporary filters for CHEM322239 on both queries Row Security query is open, click on the filter in the Detail Filters pane Go to Properties Click General/Usage and change Required to Disabled Open Query Explorer and click the Speedtype query Click on the filter in the Detail Filters pane Go to Properties Click General/Usage and change Required to Disabled Add the pre-written Purpose Prompt to both queries With Speedtype query open, click the Source tab in Insertable Objects Open the Prompts folder Drag & drop the Purpose Prompt to the Detail Filters pane Open Query Explorer and click the Row Security query Drag & drop the Purpose Prompt to the Detail Filters pane Click Query Explorer, click Queries Double-click the Join In the Join Relationship window, click the New Link button a. The join is between: Speedtype CHARTFIELD1 and Row Level CHARTFIELD1 b. Set the Cardinality to 1..1 = 1..n and click OK Save your work Open Query Explorer, double-click the Joined Data query
Save your work Open Query Explorer and click Row Security query Add these three fields from UD Financial Data Mart to the Data Items pane: Field Name Query Subject Folder Row Level CHARTFIELD1 FIN Row Security Operator ID Descr (name of person) FIN Row Security Row Level Approver/Viewer Flag FIN Row Security Add one Filter and validate it This is a temporary filter to test the query: [Row Level CHARTFIELD1]='CHEM322239' (use the same Speedtype as above) Click the Run menu item and View Tabular Data to verify data is good (The values in Row Level Approver/Viewer Flag are Y and N – we’ll improve this later.) Disable the temporary filters for CHEM322239 on both queries Row Security query is open, click on the filter in the Detail Filters pane Go to Properties Click General/Usage and change Required to Disabled Open Query Explorer and click the Speedtype query Click on the filter in the Detail Filters pane Go to Properties Click General/Usage and change Required to Disabled Add the pre-written Purpose Prompt to both queries With Speedtype query open, click the Source tab in Insertable Objects Open the Prompts folder Drag & drop the Purpose Prompt to the Detail Filters pane Open Query Explorer and click the Row Security query Drag & drop the Purpose Prompt to the Detail Filters pane Click Query Explorer, click Queries Double-click the Join In the Join Relationship window, click the New Link button a. The join is between: Speedtype CHARTFIELD1 and Row Level CHARTFIELD1 b. Set the Cardinality to 1..1 = 1..n and click OK Save your work Open Query Explorer, double-click the Joined Data query