Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
As Of Date Report Not Pulling Current Row if Ethnicity Is Included In Output
Content
The report below is an "As Of" dated report. The issue i am seeing is that if ethnicity is included in the output of the report multiple rows are pulled for associates who have made a change to that field at any point. That seems to be the only cause of the duplicate rows as far as i can tell, if i remove that field i no longer get duplicates. Has anyone else seen this before and if so do you know how to fix it?
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">
<saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Management - Worker Assignment Real Time"" withinHierarchy="true">
<saw:columns>
<saw:column xsi:type="saw:regularColumn" columnID="c3bbdaccd1d72ba96">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Department"."PER_ORGANIZATION_UNIT_DFF_CRSPNTNG_LGL_NTY_"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Department</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Company</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cfab9e7b221714c78">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Department"."PER_ORGANIZATION_UNIT_DFF_LB_DEPARTMENT_CODE_"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Department</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Store Number</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c31e8a48a1130a634">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Department"."PER_ORGANIZATION_UNIT_DFF_TRAN_LB_DEPARTMENT_TYPE_"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Department</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Building</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c0b2bdaed1fdeca68">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Internal Location Code"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Location</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Location</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c03f00f393d354e55">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Worker Location Name"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Location</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Store Location</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c02b7220f1c6bd5f3">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Address Line 1"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c3f13bade6c86404f">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Address Line 2"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c8111a71b71cfa0e5">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Address Line 3"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cbb67c546e0fd3b9b">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."City"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c7b72c1ab4031648e">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Region 2"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Location</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>State</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c5b625d541470ade5">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Worker Location Postal Code"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cad75da19d1623066">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Worker Location Name"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c92f46991f95d7197">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">case SUBSTRING("Location"."Worker Location Postal Code" FROM 1 FOR 1) WHEN 'A' THEN 'NL' WHEN 'B' THEN 'NS' WHEN 'C' THEN 'PE' WHEN 'E' THEN 'NB' WHEN 'G' THEN 'QC' WHEN 'H' THEN 'QC' WHEN 'J' THEN 'QC' WHEN 'K' THEN 'ON' WHEN 'L' THEN 'ON' WHEN 'M' THEN 'ON' WHEN 'N' THEN 'ON' WHEN 'P' THEN 'ON' WHEN 'R' THEN 'MB' WHEN 'S' THEN 'SK' WHEN 'T' THEN 'AB' WHEN 'V' THEN 'BC' ELSE ' ' END</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Location</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>State/Province</saw:text></saw:caption>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c798500e5651da221">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."Region 3"</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Location</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>Province</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c3a3faa933d0dbb90">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Location"."PER_LOCATIONS_DF_LB__LOCATION__CODE_"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c1a41c0f51ea6a9a4">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Hourly/Salaried"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cfdcaa25f6c7f7ed3">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">LEFT("Worker"."Assignment Category Code", 1)</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Worker</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Full Time/Part Time</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c31b64a42869a66e4">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">RIGHT("Worker"."Assignment Category Code", 1)</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Worker</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Reg/Temp</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="ce1d32ae1f2aad156">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c6829c0a9f428270a">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Employee Name"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c139227b505432d31">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Employee Date Of Birth"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true">
<saw:dataFormat xsi:type="saw:custom" customFormat="MM/dd/yyyy"/></saw:formatSpec></saw:displayFormat>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cbfbb9c3a34769563">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Employee Ethnicity"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c58e98606c96fe034">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Employee Hire Date"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true">
<saw:dataFormat xsi:type="saw:custom" customFormat="MM/dd/yyyy"/></saw:formatSpec></saw:displayFormat>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c824659a682690fc0">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Enterprise Seniority Date"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true">
<saw:dataFormat xsi:type="saw:custom" customFormat="MM/dd/yyyy"/></saw:formatSpec></saw:displayFormat>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c4d6026297711d2b9">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Manager Person Number"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c675887dd3dd9b7bc">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Manager Name"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="ccc4c7faae41e821a">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Employee Mailing County Code"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cb716b86725da789d">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Assignment Status"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c62c156ddf58759d7">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Start Date"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c60d3807048aa16ae">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Job Legislation Data_United States Job Information"."Job Legislation Data_PER_JOBS_LEG_EFF_HRX_US_JOBS__FLSA_STATUS_v"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c4f0261eab6028200">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Job"."Job Code"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Job</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Job Code</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c25141abdf7c6eac2">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Job"."Job Name"</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="repeat" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Job</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat>
<saw:caption fmt="text">
<saw:text>Job Title</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c9f42d4698851a7dc">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Legal Employer"."Name"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c3cc67727d43b5b7d">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">CASE WHEN "Business Unit"."Business Unit Name" = 'Henri Bendel Store' THEN ' ' ELSE CASE "Department"."PER_ORGANIZATION_UNIT_DFF_LB_DEPARTMENT_TYPE_" WHEN 'Region' THEN RIGHT("Department"."Department Name",3) WHEN 'District' THEN RIGHT("Department"."Department Name",3) WHEN 'Store' THEN RIGHT("Department"."Department Name",3) ELSE ' ' END END</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Hierarchy</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>Region</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cffe2269394b0731a">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">CASE WHEN "Business Unit"."Business Unit Name" = 'Henri Bendel Store' THEN ' ' ELSE CASE "Department"."PER_ORGANIZATION_UNIT_DFF_LB_DEPARTMENT_TYPE_" WHEN 'District' THEN LEFT(RIGHT("Department"."Department Name",7),3) WHEN 'Store' THEN LEFT(RIGHT("Department"."Department Name",6),3) ELSE ' ' END END</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>Business Unit</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>District</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns>
<saw:filter>
<sawx:expr xsi:type="sawx:list" op="in">
<sawx:expr xsi:type="sawx:columnExpression" formulaUse="code" displayUse="display">
<saw:columnFormula formulaUse="display">
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Assignment Status"</sawx:expr></saw:columnFormula></sawx:expr>
<sawx:expr xsi:type="xsd:decimal">2</sawx:expr>
<sawx:expr xsi:type="xsd:decimal">1</sawx:expr>
<sawx:expr xsi:type="xsd:decimal">1002</sawx:expr>
<sawx:expr xsi:type="xsd:decimal">6</sawx:expr>
<sawx:expr xsi:type="xsd:decimal">5</sawx:expr>
<sawx:expr xsi:type="xsd:decimal">1003</sawx:expr></sawx:expr></saw:filter>
<saw:prefix>SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}{2018-04-24}';</saw:prefix></saw:criteria>
<saw:views currentView="0">
<saw:view xsi:type="saw:compoundView" name="compoundView!1">
<saw:cvTable>
<saw:cvRow>
<saw:cvCell viewName="titleView!1">
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow>
<saw:cvRow>
<saw:cvCell viewName="tableView!1">
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:cvCell></saw:cvRow></saw:cvTable></saw:view>
<saw:view xsi:type="saw:titleView" name="titleView!1"/>
<saw:view xsi:type="saw:tableView" name="tableView!1" scrollingEnabled="false">
<saw:edges>
<saw:edge axis="page" showColumnHeader="true"/>
<saw:edge axis="section"/>
<saw:edge axis="row" showColumnHeader="true">
<saw:edgeLayers>
<saw:edgeLayer type="column" columnID="ce1d32ae1f2aad156"/>
<saw:edgeLayer type="column" columnID="c6829c0a9f428270a"/>
<saw:edgeLayer type="column" columnID="c139227b505432d31"/>
<saw:edgeLayer type="column" columnID="c58e98606c96fe034"/>
<saw:edgeLayer type="column" columnID="c824659a682690fc0"/>
<saw:edgeLayer type="column" columnID="cbfbb9c3a34769563"/>
<saw:edgeLayer type="column" columnID="c3bbdaccd1d72ba96"/>
<saw:edgeLayer type="column" columnID="cfab9e7b221714c78"/>
<saw:edgeLayer type="column" columnID="c31e8a48a1130a634"/>
<saw:edgeLayer type="column" columnID="c4f0261eab6028200"/>
<saw:edgeLayer type="column" columnID="c25141abdf7c6eac2"/>
<saw:edgeLayer type="column" columnID="c1a41c0f51ea6a9a4"/>
<saw:edgeLayer type="column" columnID="c60d3807048aa16ae"/>
<saw:edgeLayer type="column" columnID="c03f00f393d354e55"/>
<saw:edgeLayer type="column" columnID="cfdcaa25f6c7f7ed3"/>
<saw:edgeLayer type="column" columnID="c31b64a42869a66e4"/>
<saw:edgeLayer type="column" columnID="cbb67c546e0fd3b9b"/>
<saw:edgeLayer type="column" columnID="c7b72c1ab4031648e"/>
<saw:edgeLayer type="column" columnID="c0b2bdaed1fdeca68"/>
<saw:edgeLayer type="column" columnID="c02b7220f1c6bd5f3"/>
<saw:edgeLayer type="column" columnID="c3f13bade6c86404f"/>
<saw:edgeLayer type="column" columnID="cad75da19d1623066"/>
<saw:edgeLayer type="column" columnID="c9f42d4698851a7dc"/>
<saw:edgeLayer type="column" columnID="c8111a71b71cfa0e5"/>
<saw:edgeLayer type="column" columnID="c3cc67727d43b5b7d"/>
<saw:edgeLayer type="column" columnID="cffe2269394b0731a"/>
<saw:edgeLayer type="column" columnID="c5b625d541470ade5"/>
<saw:edgeLayer type="column" columnID="c92f46991f95d7197"/>
<saw:edgeLayer type="column" columnID="c798500e5651da221"/>
<saw:edgeLayer type="column" columnID="c4d6026297711d2b9"/>
<saw:edgeLayer type="column" columnID="c675887dd3dd9b7bc"/>
<saw:edgeLayer type="column" columnID="ccc4c7faae41e821a"/>
<saw:edgeLayer type="column" columnID="cb716b86725da789d"/>
<saw:edgeLayer type="column" columnID="c62c156ddf58759d7"/>
<saw:edgeLayer type="column" columnID="c3a3faa933d0dbb90"/></saw:edgeLayers></saw:edge>
<saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views>
<saw:prompts scope="report" subjectArea=""Workforce Management - Worker Assignment Real Time"">
<saw:promptStep>
<saw:individualPrompts>
<saw:prompt xsi:type="saw:variablePrompt" columnID="c14" required="false">
<saw:promptUIControl xsi:type="saw:editBox">
<saw:customWidth width="120" using="default"/></saw:promptUIControl>
<saw:promptSource xsi:type="saw:choiceList" useCaptionOnly="true" dataType="date">
<saw:promptChoices/></saw:promptSource>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="presentationVariable" variableFormula="AsOfDate"/></saw:setPromptVariables>
<saw:promptOperator/>
<saw:constrainPrompt type="none"/>
<saw:label>
<saw:caption>
<saw:text>As Of</saw:text></saw:caption></saw:label>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="false"/></saw:prompt>
<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c38" subjectArea=""Workforce Management - Worker Assignment Real Time"" required="false">
<saw:formula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:formula>
<saw:promptOperator op="in"/>
<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false">
<saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="false"/>
<saw:constrainPrompt type="none"/>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>
<saw:promptSource xsi:type="saw:allChoices"/></saw:prompt>
<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c19" subjectArea=""Workforce Management - Worker Assignment Real Time"" required="false">
<saw:formula>
<sawx:expr xsi:type="sawx:sqlExpression">"Department"."PER_ORGANIZATION_UNIT_DFF_CRSPNTNG_LGL_NTY_"</sawx:expr></saw:formula>
<saw:promptOperator op="in"/>
<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false">
<saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>
<saw:label>
<saw:caption>
<saw:text>Company</saw:text></saw:caption></saw:label>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="false"/>
<saw:constrainPrompt type="none"/>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>
<saw:promptSource xsi:type="saw:allChoices"/></saw:prompt>
<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c20" subjectArea=""Workforce Management - Worker Assignment Real Time"" required="false">
<saw:formula>
<sawx:expr xsi:type="sawx:sqlExpression">"Department"."PER_ORGANIZATION_UNIT_DFF_LB_DEPARTMENT_CODE_"</sawx:expr></saw:formula>
<saw:promptOperator op="in"/>
<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false">
<saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>
<saw:label>
<saw:caption>
<saw:text>Department Code</saw:text></saw:caption></saw:label>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="false"/>
<saw:constrainPrompt type="none"/>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>
<saw:promptSource xsi:type="saw:allChoices"/></saw:prompt>
<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c26" subjectArea=""Workforce Management - Worker Assignment Real Time"" required="false">
<saw:formula>
<sawx:expr xsi:type="sawx:sqlExpression">"Department"."PER_ORGANIZATION_UNIT_DFF_TRAN_LB_DEPARTMENT_TYPE_"</sawx:expr></saw:formula>
<saw:promptOperator op="in"/>
<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false">
<saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="false"/>
<saw:label>
<saw:caption>
<saw:text>Building</saw:text></saw:caption></saw:label>
<saw:constrainPrompt type="none"/>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>
<saw:promptSource xsi:type="saw:allChoices"/></saw:prompt>
<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c30" subjectArea=""Workforce Management - Worker Assignment Real Time"" required="false">
<saw:formula>
<sawx:expr xsi:type="sawx:sqlExpression">"Job"."Job Code"</sawx:expr></saw:formula>
<saw:promptOperator op="in"/>
<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false">
<saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="false"/>
<saw:label>
<saw:caption>
<saw:text>Job Code</saw:text></saw:caption></saw:label>
<saw:constrainPrompt type="none"/>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>
<saw:promptSource xsi:type="saw:allChoices"/></saw:prompt>
<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c39" subjectArea=""Workforce Management - Worker Assignment Real Time"" required="false">
<saw:formula>
<sawx:expr xsi:type="sawx:columnExpression" formulaUse="code">
<saw:columnFormula formulaUse="display">
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Assignment Status"</sawx:expr></saw:columnFormula>
<saw:columnFormula formulaUse="code">
<sawx:expr xsi:type="sawx:sqlExpression">DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Assignment Status")</sawx:expr></saw:columnFormula></sawx:expr></saw:formula>
<saw:promptOperator op="in"/>
<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false" enableSelectByCodeColumn="false" showCodeColumnValue="false">
<saw:customWidth width="120" using="custompixels"/></saw:promptUIControl>
<saw:promptDefaultValues type="reportDefault" usingCodeValue="true"/>
<saw:constrainPrompt type="none"/>
<saw:setPromptVariables>
<saw:setPromptVariable location="value" type="none" variableFormula=""/></saw:setPromptVariables>
<saw:promptSource xsi:type="saw:allChoices"/></saw:prompt></saw:individualPrompts>
<saw:customWidth width="120" using="default"/></saw:promptStep></saw:prompts></saw:report>
Answers
-
Please see if below helps:
0 -
Thank you. I did find a possible solution in that thread. It would be nice though if associates who choose more than one ethnicity have to pick a default so this kind of workaround isn't necessary. Either that or a change with how the field pulls in reports so duplicate rows don't pull if more than one ethnicity is listed.
0