Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 67 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to find employees not in specific two months.
How to find employees not in specific two months.
I have employee's data of each month. I want to find the employees not in specific two months.
Example data like below.
Emp ID | FYQ | Month | Capacity |
|---|---|---|---|
9060 | FY25 Q1 | Oct 2024 | 0.40 |
9060 | FY25 Q1 | Oct 2024 | 0.05 |
9060 | FY25 Q2 | Jan 2025 | 0.40 |
9060 | FY25 Q2 | Jan 2025 | 0.05 |
100799 | FY25 Q1 | Oct 2024 | 0.50 |
100799 | FY25 Q2 | Jan 2025 | 0.50 |
100799 | FY25 Q3 | May 2025 | 0.50 |
13509 | FY25 Q1 | Oct 2024 | 0.50 |
13509 | FY25 Q2 | Jan 2025 | 0.50 |
13509 | FY25 Q3 | May 2025 | 0.50 |
13537 | FY25 Q1 | Oct 2024 | 0.50 |
13537 | FY25 Q2 | Jan 2025 | 0.25 |
13537 | FY25 Q3 | May 2025 | 0.50 |
200605 | FY25 Q1 | Oct 2024 | 0.50 |
206299 | FY25 Q2 | Jan 2025 | 0.50 |
206299 | FY25 Q3 | May 2025 | 0.50 |
206559 | FY25 Q1 | Oct 2024 | 0.50 |
206559 | FY25 Q2 | Jan 2025 | 0.50 |
206559 | FY25 Q3 | May 2025 | 0.50 |
208460 | FY25 Q1 | Oct 2024 | 0.50 |
208460 | FY25 Q2 | Jan 2025 | 0.50 |
208460 | FY25 Q3 | May 2025 | 0.50 |
209899 | FY25 Q2 | Jan 2025 | 0.50 |
209899 | FY25 Q3 | May 2025 | 0.50 |
98364 | FY25 Q1 | Oct 2024 | 0.50 |
98364 | FY25 Q2 | Jan 2025 | 0.50 |
98364 | FY25 Q3 | May 2025 | 0.50 |
99122 | FY25 Q3 | May 2025 | 0.80 |
99122 | FY25 Q3 | May 2025 | 0.20 |
Answers
-
Hi,
Can you please specify the product where you are looking to find this information? Is it fusion analytics (FAW/FDI) or fusion SaaS?
Thanks.
0 -
It is Oracle Analytics Cloud.
1 -
@Rajakumar Burra Let us say, we are considering Jan-25 and May-25 , can you tell me the expected output? This will help to understand the requirement better.
0 -
@BalagurunathanBagavathy-Oracle Expectation is as below.
Emp ID
Jan-25
May-25
9060
Yes
No
99122
No
Yes
0 -
@Rajakumar Burra If we have a master list of employees and store it in a parameter and use the parameter in a formula to check if an employee exists in the list or not, will it suffice your requirement?
0 -
@BalagurunathanBagavathy-Oracle Parameter will serve the purpose the use case explained in this example but parameter have limitation of fetching 1000 users . Due to this I am unable to use Parameters.
Actually my use case is little more complex.
I have 4000+ employees working on different product in each month.I need change of employees between any 2 months like No more with company , New hires and moved from one org to another.
It should be retrieved dynamically.
Number of results fetching through parameter is major constraint for me.
0 -
@Rajakumar Burra I am thinking loud here. Have you explored moving this logic to the ETL layer?
0 -
There isn't an info on what part of the product is your question about. You can model this with an outer join reusing the same object to bypass the number of parameters limits. But if you are just working with a file-based dataset in DV, then the only thing crossing my mind is a new dataset based on a LSQL doing the logic (what above is suggested to be moved out in the ETL layer).
And of course, if you really move this out in a database, even just with a SQL query or a view, it will perform better because a database is built for doing such kind of queries, while the BI Server struggle a bit.
0 -
@BalagurunathanBagavathy-Oracle @Gianni Ceresa Thanks for immediate reply.
Actually, I want to do it dynamically list the employees based on two months selections. So, It should be done workbook.
After doing some experiments, almost got a solution through using Parameters with logical queries.
Hopefully it will work. Keep you posted.
0 -
Perhaps a union (minus) query, where the first leg contains your whole data set, and the minus leg is the same, but filtered on the two months in question. The resulting remainder will be those employees that did not work in the two selected months.
0
