You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areas

Received Response
326
Views
5
Comments
edited Jan 4, 2021 6:34PM in Reporting and Analytics for HCM 5 comments

Summary

The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column

Content

I'm trying to summarize Headcount based on Gender, Ethnicity and Person Legislative Attribute Values but it's only working for Gender. 

When filtered with Ethnicity it is returning 0 which is not the expected value.

When filtered with Person Legislative Attribute it is throwing error. The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column

Is there any issue with my formulas? Any alternative options to meet my objective?

Attached the XML for reference.

Code Snippet

<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" appObjectID="a714deff-7b09-4229-9a2d-aa4598135cce~11.13.20.10.0.0">  
   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Management - Worker Assignment Real Time"" withinHierarchy="true">    
      <saw:columns>      
         <saw:column xsi:type="saw:regularColumn" columnID="ce7115482a6bd1be7">        
            <saw:columnFormula>          
               <sawx:expr xsi:type="sawx:sqlExpression">IFNULL("Worker Assignment"."Head Count",0)</sawx:expr>    

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!