3 Replies Latest reply: Mar 24, 2014 8:45 AM by Srini VEERAVALLI RSS

    Combine data from two fact table (OBIA HR Analytics)

    Joni

      Dear Gurus,

       

      I have some question on BI APPS HR module. I have requirement to compute data from column employee training (Fact - HR - Learning Enrollment and Completion) / total employee (Fact - HR - Operation (Workforce)) to get the percentage, since It's coming from different fact I have difficulty to combine this column. I tried using combine request in answer and yes It can be done using seperate filter for each criteria. After I combined this two criteria I want to show only value that greater than 0 but I could not find any filter for this (can not use filter option to limit union value). Any workaround for my case?What should I do ?change in RPD or It can be done in answer?Please let know the possibility.

       

      Thanks

       

      Joni