How to combine data from 2 fact table in OBIEE (OBIA)

[joni lie]

Hi All,

I faced problem when tried to combine data from 2 fact table in OBIEE. Here is my requirement

- I have report requirement to show Percentage of employees who have attended training with this calculation

  Percentage = No. of employees who have attended training course / Total no. of employees 

- I am using OBIA HR Analytics module, No. of employees who have attended training course is coming from (Fact - HR - Learning Enrollment and Completion) and Total no. of employees is coming from under Fact - HR - Operation (Workforce). So data are coming from 2 different facts and no linkage between this 2 fact tables. 

- Currently I am using combine request in answer to combine data from this 2 fact tables.

But I had problem after combining data from 2 fact table to limit only for data which have percentage greater than 0 to display. I could not find anything to filter this data. I only can filter for each request not for combine request. Is It anyway to make It happen? I you guys have any thought please let me know. Really appreciate for your help.

Regards,

Joni

[Vijayaraghavan R]

My 2 cents - Can you bring the total number of employees in a session variable? This number will not change frequently and just for this one number, there's no point to join the two reports.

Vijay

[Kashif M]

Dear,

Make multiple logical table source and try your calculation

Regards
Kashif M
http://mkashu.blogspot.com

[Mariano Espagnol]

I understand that only "No. of employees who have attended training course" has to be grater than 0, to make it work.
On the other hand, "Total no. of employees " will always be >= 0.
So, you just have to add that filter in one of the union reports.

a / b > 0 => a > 0 & b <> 0.

Regards, Mariano

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mariano Espagnol
mesp...@gmail.com