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
                                                       Please Read this entire post for my fix FIRST OF ALL I MUST SAY THAT THE BATTERY THE 4S IS A BEAST!!!!!!!!!! I would like to add two steps to this.  I am a pure believer davidch you are unto some [More]
Is there no way to import my old sms from my sim to iphone 3gs?I don't think you can... But Check Here: iPhone User Guide http://manuals.info.apple.com/en_US/iphone_user_guide.pdfRead other 7 answers [More]
Need to provide set delegation part to end users. So, we have provided link to delegateWorkItems.jsp to end users. By that way, the end user can open the builtIn form “End User Delegate WorkItems”, How ever, the user is not able to get users to deleg [More]
Hi, I had installed a new Gw7 on netware platform as a secondary server.When i am trying to rebuild the database fom my primary i am not able to made my PO available for all other domain but the system is working fine. Clients in other domains are no [More]
hi, I have developed a small eclipse application. I want to integrate javafx with it. I used the eclipse view's "composite" as the frame for the javafx application i developed, say a frame has a canvas which inturn has a rectangle. Integration u [More]
I currently have 2 sun boxes running ver 9 that I need to be able to have mail to the outside world. My main mailserver is a groupwise box. I put the GW server ip and name and mailhost in the hosts file. I can mail from the sun boxes internally, eg; [More]
I think I should have posted this here instead of on the basics are. Anyway here is my problem. I'm creating a little standalone program that needs to have database like functions. The program needs to store data fields like names, titles, etc. that [More]
I think DS 3.1 is already in RTM but couldn't find the PAR on the service marketplace. There is only one for version 3.0. I need this document to confirm that DS 3.1 doesn't support HPUX PA-RISC any more. My customer is still using DI 11.5.3 on PA-RI [More]
Also changed iTunes into spainishGo to the App Store, and tap the featured tab. Swipe down to the bottom and tap on your Apple ID. Tap View Apple ID. Enter your password. Go down to Country/Region. Change it there.Read other 4 answers [More]
OK, System will post, according to MSI Website I have the latest Bios version. I can boot from CD. The only odd item is that I am using the HD that I took out of my old computer with windows already on it.   Tried re-installing windows XP.  It went t [More]