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
Hi All, I am using Sun Studio 4 to create a HTML form that takes in 4 inputs and then passes them on to a servlet to be processed. In my HTML form i have the form heading.. <form method = post action="processServlet"> my directory structur [More]
Hi! I'm building a system with some instruments and I want to use the same instrument-VI for all instruments. One way is to do it set it up as 'Possible solution..' (see image). Is there some way where I can loop through the 'hardware settings'-array [More]
I upgraded my iphone os into 5.1 I found out I'm no longer able to connect into my home Wi Fi....please helpUpdate router and reboot router.Read other 2 answers [More]
Hi all: I am doing an example to create a table with a registered schema associated (in Oracle9ir2), and i am trying to insert a document that fits to schema into the table. The example is very simple: I have the following schema: <schema xmlns="h [More]
Hi all. I've hit a problem here and I was hoping somebody could point me in the right direction. Here's the sitation.   I have a Wrt160N v3 router and I have 2 wired connections out of it.. one to my main computer and one upstairs where my ps3 used t [More]
my database version is 10gr2 i want to transfer the rows to column .....i have seen the examples for small no of records but how can it be done if there are more the 1000 records in a table ...??? here is the sample data that i would like to change i [More]
So my gcc used to work but now I'm getting these strange error messages. For example I wrote the most basic of C programs: int main(){ return 0; And the terminal error message I get is: gcc: error trying to exec '/usr/lib/gcc/x86_64-unknown-linux-gnu [More]
So when I connect my mac mini 2011 with hdmi into my tv the colors are more ugly ... like some colorist are very strong and i can't watch photos on it ... i don't know what to do .What TV and what resolution? Can you change the TV color settings? Hav [More]
Hi, I've deployed a Lync server 2010(4.0.7577.0) and an Exchange 2010(14.00.0639.021) for our video/audio calls/conferences. When I schedule an online meeting in the outlook, I could see the meeting web access link (https//...), but couldn't find the [More]
I am trying to embed an interactive graphic created in Tumult Hype into a Adobe Muse website. I manually uploaded the hype file to my server, then used an iframe to display the file in muse. But the file is cropped off in Muse, and I can't figure out [More]