on 06-10-2014 6:29 PM
Hi,
I am working on a report where I need to show employees who turned 65 from the time the report is run to over the next 12 months.I have the 'Date of Birth' field available. I am using Bex Query as a data source and webi 4.1. How do I calculate this in Webi 4.1. I appreciate any help.
Thank you,
Charvi.
create a variable,
Age = year(currentdate()) - year([DOB]) // age based on current month
Age Equal 65 = [Age] where ([Age]=65)
or
Age = (Year(CurrentDate())+1)-Year([DOB]) // age calculation based on current month + next 12 months
Age Equal 65 = [Age] where ([Age]=65)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Charvi ,
Create a variable with below formula and restrict (filter ) the report with 1 .
=DaysBetween(ToDate([L01 Person Date of Birth (Key)];"d.M.yyyy");RelativeDate(LastExecutionDate();365))/365>65
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Charvi,
Get the all employees who are all in 64 age bucket till yesterday. Keep indicator for these employees.
Then obviously these employees will be falling in 65 age in coming 12 months/365 days.
Same you can get at Bex level also. Create formulae :
if employee age = 64 then 1 else 0.
(AGE = 64 * 1 + 0)
Then create condition on this formulae as Value = 1.
Revert back your feedback.
Regards, Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use Current Date and Year from Date & Time functions in the formula and get the desired result in the Webi report.
Else, you will have to create a customer exit variable on CALDAY in BEx query and write code to get the data in the report from the current date to next 12 months.
Regards,
Suchitra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.