Running OTBI based upon the Results of another OTBI getting Error getting Drill Information
We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once connected we receive an error. Error getting Drill Information, Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Our use case is an audit for terminations with an action reason of Contractor Conversion where no subsequent Add Employee Work Relationship row has been added.
I have built two OTBI analysis. Both are built on subject area Workforce Management - Worker Assignment Event Real Time. The first analysis (called Future Hires) returns all future hires with effective start date greater than or equal to current day. This report returns the correct results only when SET VARIABLE PARAM_EFFECTIVE_DATE='4712-12-31'; is set on the advances tab.