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 am using the example java code "RetrieveLimitedRecords" that can be found at : https://help.sap.com/javadocs/MDM71/current/API/index.html The code give the expected result and retrieves the record count for the main table Now I want to get the [More]
do you need a dedicated graphics card to run this or can it run smoothly on computers with a shared with the memory (macbook pro 15-inch vs macbook pro 13-inch)? thanks.thanks for the reply. however, the SSD gave me pause... instead of the 13-inch MB [More]
My mobo died and so I had to rebuild my system.  I am running Bridge cs6 on a win7 64 bit machine.  In order to rebuild my system I built a new C: drive, i.e., I created a new system drive.  All my files from before the crash are available.  All my d [More]
I have created a Webdynpro component(A) in which i am getting details from the BAPI(model) and I have exposed this component as a public part and I am using this component in another webdynpro component(B). In the second webdynpro component(B)  I hav [More]
I am not able to load the applet with jre24 in IE8. when all the client jars getting loaded in the client side, the JVM getting crashed while loading wlfullclient.jar. I am also try to load the same by increasing the Java run time parameters in the c [More]
Back in May, I built a distribution package for installing a bunch of software the school (where I work) uses, like Firefox, Thunderbird, etc. I built individual installers for each thing (like one for apps to put into the Applications folders, anoth [More]
I have installed an oracle DB 11g, I also installed oracle client 10g express edition to create users and tables. I noticed that the users I created can't connect to db with error message "Error java.sql.SQLException: ORA-01017: invalid username/pass [More]
I'm a heavy user of the "Use Previews Files" option when exporting files. This has worked great with Premiere CS5.5 but using the same method in CS6 no longer works and reverts back to rerendering the original files in the timeline and rerenderi [More]
I got this from a friend. She said it worked when she first got it and then one day this appeared and I can't get it to work again. Can anyone else helpI am not sure if I understand you correctly, try reset iPad Hold down the Sleep/Wake button and th [More]
SimplePass stopped working today.  I noticed a while ago that I no longer had to manually add the Website Logon extension anymore.  A small window popped up with a warning about using developer extensions and SimplePass worked.  Website Logon extensi [More]