Sitemap

Amicuk Programming Answers

How to calculate Age in the RPD level

-0001-11-30   Views:2

Advertisement

I want to create a logical column say 'Age' in the repository. I have the PERS_DOB in the PERSON dimension. From this I wrote a query to get the age from the PERSON dimension as below. I am wondering if I can create a logical column in the rpd using

I want to create a logical column say 'Age' in the repository. I have the PERS_DOB in the PERSON dimension.
From this I wrote a query to get the age from the PERSON dimension as below.
I am wondering if I can create a logical column in the rpd using the sql or is there any way where I can get the age of the persons calculated as a logical layer in the repository.
select pers_dob, round (((trunc(sysdate)-trunc(pers_dob))/365), 0) from w_pers_d
Thanks in advance.

The replay answer
Advertisement
I have created a repository variable 'currentdate' (to get the sysdate) in the rpd and created a new logical column AGE and in the expression builder I used the below and got the syntax error.
***round((currentdate-trunc("Program Info b".."Program Info b"."W_PGAD_PR_PERS_D"."PERS_DOB" )/365),0)***
***[nQSError: 27002] Near <(>: Syntax error [nQSError: 26012] .***
I thought functions round, trunc are not supported in OBIEE expression builder and tried the below and got a different syntax error.
*[nQSError: 27009] Unresolved identifier: "currentdate".*
Have anyone tried this successfully.
Please let me know.
Thanks/

Go to See the other 15 answers

How to calculate Age in the RPD level

Category:DefaultRelease time:-0001-11-30Views:130

I want to create a logical column say 'Age' in the repository. I have the PERS_DOB in the PERSON dimension. From this I wrote a query to get the age from the PERSON dimension as below. I am wondering if I can create a logical column in the rpd using[More]

Calculate age using DOB

Category:DefaultRelease time:-0001-11-30Views:130

Is there a way to calculate age from DOB in the RPD business model layer? In the table, there is only DOB stored in string format (e.g. 19700125, YYYYMMDD format) and we need to dervie age in the RPD.Here's a hint: use TimestampDiff funtction such as[More]

How to calculate Age in BEx query

Category:DefaultRelease time:2015-10-11Views:130

Hi, I need to calculate age in years based on person's date of birth and the key date that user of the report will enter. So, basically in my query I already have date of birth characteristic from 0PERSON InfoObject. I created ZAGE key figure and add[More]

Logical column currency format properties at rpd level?

Category:DefaultRelease time:2015-10-11Views:130

I need to show the currency amount with dollar symbol for a logical column and that should happen at rpd level. Is there anyway we could do that ? thank youHi User. You can have logical column name as 'Amount in $' or 'Amount in Dollar' this is the b[More]

Function Module to calculate age

Category:DefaultRelease time:-0001-11-30Views:130

Hi Abapers, Kindly suggest some function module which can calculate age of a person by taking date of birth till date. Thanks in advance, RadhikaHi Radhika, Check this program REPORT ZTEST. DATA : BIRTH_DATE LIKE SY-DATUM,        DAYS TYPE NUM2,     [More]

ABAP-HR MODULE(HOW TO CALCULATE AGE & YEARS OF SERVICE)

Category:DefaultRelease time:-0001-11-30Views:130

HI, HOW TO CALCULATE AGE & YEARS OF SERVICE means for example I AM USING PNPCE LDB. (1) whose age is greater than 52.833 years with 7.833 years of service, with annual rate of pay $170,000 or more, or (2) age plus employment service is 65 or more, wi[More]

How to Calculate AGE by getting difference between two Date Fields

Category:DefaultRelease time:-0001-11-30Views:130

HI Gems I need to calculate AGE from getting difference from two date fields. But when i am trying to wrte fromula as Current date - date1(some date field) then it is showing error. How can i get values. Thanks ManuYou already asked this question: Ho[More]

How to calculate AGE from two different date fields

Category:DefaultRelease time:-0001-11-30Views:130

hi I need to calculate AGE from two different date fields. Can some help me how to do, when i try to do substraction formula it is showing error. Thank You ManuManu wrote: Hi Both fields are in date format only, i need to calculate no . of days betwe[More]

How to calculate age in SQL?

Category:DefaultRelease time:-0001-11-30Views:130

I have a table with DATE as one of the column. How do I calculate age? Thanks in advance -Shilpamichaels2 wrote: TryWell it still leaves leap year question open. If person was born on February 29, how old is that person on February 28 of a non-leap y[More]

How to calculate age in oracle

Category:DefaultRelease time:-0001-11-30Views:130

Hi, T was trying do calculate age as on todays date in ORACLE but after a lot of brain storming i didn't get it. Kindly tell me how to calculate age as in years month days. For ex.. My DOB- 02-feb-1984 so my age should get as 27 Years 2 months 8 days[More]

Filter at rpd level

Category:DefaultRelease time:-0001-11-30Views:130

plz tell me the syntax for -filter a particular table on the basis of a particular column at rpd level. for exp-I want to filter a employee_detail table where dept=salesHi, In BMM layer under sources you can see logical table sources for that Table.C[More]

Hot
I'm trying to share my screen iMac to MacBook. Both on Mountain Lion. Under the VIDEO drop down Screen Sharing on both computers is checked off. In SYSTEM PREFERNCES > SHARING, Screen Sharing is on. Yet, I cannot share my screen, or share the screen [More]
Hi, I ran the cost estimate for one material on 12.06.2008 and i released the cost estimate. Here it is saying 'Cost Estimate released too early'. I thought system is releasing the cost for material for the next month. but i want to update the materi [More]
Hi Experts,      I have configured sender contentent conversion. My structure is like : H - H1,H2,H3 D - D1,D2,D3 P - P1,P2,P3 I configured as below: Document name:MT Document name:namespace Recordset name:Recordset Recordset structure:H,1,D,,P, Reco [More]
Hi, I am trying to install EBS R12.1.1 on my Windows XP SP3 machine. I use cygwin instead of MKS toolkit (for obvious reasons). The installation proceeds fine. It installs the DB without any problems and the whole process goes fine until step 4. Here [More]
So I have this monitor mentioned in the title of this post, it's a 3D monitor and is suppose to display at 120hz natively. It's native resolution is [email protected], I have no problem setting it's native resolution in 'nvidia-settings' (I have NVGF56 [More]
I see a display error on the selection screen to the left of the Run Time field.  When my mouse hovers over the display error, another display then appears below the Run Time field.  I believe an = sign should appear to the left of the Run Time. SELE [More]
Hi all, I started learning LabVIEW FPGA very recently and I have a query regarding the simulations that can be done. I don't have any NI FPGA hardware with me. I am using only the development computer for programming in LabVIEW FPGA.  I am using "Exe [More]
We have over $10 on our store credit to buy things. Whenever we try to buy anything, it asks for our billing info for our credit card. We want to use money from our gift cards. How do we get to use that instead of a credit card which we do not want t [More]
I've had Lightroom running on my iMac, but am looking at moving to Aperture on the quick recommendation of a pro photogapher friend.  I haven't upgraded LR along the way, and so I'd be looking at buying the full program, which is more expensive than [More]
Hi All Someone please advise me where can i find the java.media package. Any help will be welcomed. Thanks ShanIt seems that java.media was changed to javax.media from JMF 1.0.2 Apperently the source code that you have is old. Check out the following [More]