Recent content by tunjio

Orace 9i

I have got a date field - ACTUAL_START - stored as a varchar and managed to change this to a a date field by doing the following: TO_DATE(ACTUAL_START,'HH24:MI:SS') Thi sgives me something like this 01/08/2007 08:50:04 However what I need to do is to retrieve the time portion of this field...

Are you sure that you have not checked the 'Refresh Document when Opening' Option is not enabled? You can get to this by clicking on 'Tools', 'Options', 'Save' tab.

How do you create a prompt, based on a date object, into which you can enter a month value and have BusinessObjects return all of the date values for that month? e.g you enter 3 into a prompt and Busines Objects returns all values for the month of March?

I have a date condition in a universe as follows: PS_JOB.ACTION_DT >= to_date(@Variable('Enter the first date of the date range')) AND PS_JOB.ACTION_DT <= to_date(@Variable('Enter the last date of the date range')))) The database is oracle 8.1 and the Action Date column is a date type column...

I have got an Employee Table that looks like below: EMPLID EFF DATE ACTION 001 05/20/2005 HIR 001 05/21/2005 TER 002 05/22/2005 HIR 002 05/22/2005 PAY 002 05/22/2005 TER 003 05/21/2005 HIR 003 05/22/2005 PAY 003 05/23/2005 PAY The current requirement is to retrieve the latest row based on the...

EMPLOYEE EMPLID NAME 6001 John Doe 6002 Mae Ellen ACCOUNT EMPLID Date Account Type 6001 01/02/2005 A 6001 05/02/2005 A 6002 08/02/2005 B 6002 09/02/2005 B I want a query that will give me the latest row (based on date) for each employee and by the account type. The output of my...

Thanks Brian for the post. It dodn't work as expected but I took your advice and posted on the native db forum (oracle 8.1.7)and lo and behold got a working solution. Good idea - this forum

Thanks very much for this insight . It worked like a treatand you've made someone very happy

II have got two tables – employees and payroll that have an outer join between them because not all employees have a value in the payroll table. In addition the payroll table has an effective date value and I need to find out the latest effective date. For instance I have a PS_PERSONAL_DATA...

I have got two tables – employees and payroll that have an outer join between them A simple query between the two would be as follows: SELECT PD.EMPLID,PI_SYSTEM_ID,K.EFFDT FROM INGIPRD.PS_PI_EMPLID_TBL K,INGIPRD.PS_PERSONAL_DATA PD WHERE PD.EMPLID=K.EMPLID(+) and PD.EMPLID IN...

I run a report in Business Objects full client and the report contains a date prompt of the format 'Dd/Mm/YYYY'. When I run the same report in WEBI using the same universe in WEBI I get a 'CONNECTION OR SQL Sentence error'ORA-01847 Day of month must be 1 and last day of month.

Hi Steve, Thanks for your reply. I am on version 2.1.6 and this probably explains why I am unable to copy and paste QL from the SQL window

Hello, I tried this but for some reason the text does not get copied when I do a ctrl + C and paste into my editor. Have you tried it and it worked for you?

Cn anyone tell me if there is an easy way to copy the SQL for a WEBI document. I can view the sql but I am unable to do a select all, copy and paste to a text editor