3 Replies Latest reply on Mar 24, 2014 1:45 PM by SriniVEERAVALLI

    Combine data from two fact table (OBIA HR Analytics)


      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.