Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Analysis - Calculate Years of Service Formula
New to OBIEE. I have an analysis that I need to add a column that shows the employee's actual years of service (as of current date), for example, 4.3 years or 2.7 years. The field I'm using is
"Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Hire Date". I would like to use a formula on the field to do this. Appreciate any help you can provide please.
Answers
-
TIMESTAMPDIFF(SQL_TSI_MONTH, "Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Hire Date", NOW()) / 12.00
0 -
Thank you for your quick response. Would you mind updating the formula to show only two decimal places.
0 -
What about you look at all the formulas in the formula editor and check out "ROUND" ? It has a little example and few lines explaining how it works.
The target isn't us giving you fully working code but you learning the tool. I'm sure you can do that part (ROUND is almost the same in 80% of the languages and tools)
0 -
Beaten by Gianni, but my 10 cents:
I love helping people, but have you clicked on ANY of the buttons? Like the "Format Column? There is a tab called "Data Format". You can either ROUND in The formula or format it to show 2 decimals.
And already having 2 options: *think* about which one would be appropriate for you.
0 -
Thanks everyone for your responses. I apologize for the inconvenience. I'm very new to Oracle reporting, and find myself getting caught up in the job pressures of others needing data urgently. I lean on this forum for the quick expertise while I continue to learn. Thanks again everyone.
0 -
No need to apologize. Just click and try first. The GUI contains tons of possibilities which are pretty well explained - case in point: The formula editor with some 200 functions that you can just put together with point and click; no need to code yourself.
You can't really break things in the front-end. Try out things. Test. Once you have something you can always run it by us to see if it's the most optimal way of doing things or if there's a different approach or maybe even an out-of-the-box solution for somehtng you've tediously scripted together.
Luckily your case was straightforward but any questions in here tend to be very vague and almost impossible to answer without more information as we aren't sitting in front of the system where the issue comes from.
If you want to learn, then there's also the Oracle Learning Library: https://apexapps.oracle.com/pls/apex/f?p=44785:1
It has tons of examples, tutorials for just about anything. Just search and click on what you want.
If you also use Data Visualization, then there's tutorials there too: https://www.oracle.com/business-analytics/data-visualization/tutorials.html
Same for Cloud: https://www.oracle.com/technetwork/middleware/oac/tutorials/index.html
Oracle even put a free course on Udemy: https://www.udemy.com/course/augmented-analytics/
Long story short there's a lot of places that Oracle provides where you can learn for free
0 -
Great information, thank you!
0 -
That's what we're here for
0
