Search results for query: *

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...

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...

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.

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

I performed a safe recovery on a repository but the document domain is missiing. I am trying to re-create a document domain but when i get to the 'define document domain ' window and enter the relevant parameters, I keep getting the error message that "a repository domain of that type already...

A user has scheduled a BO report to be refreshed on BCA and saved (as a PDF document) without exporting to the repository. Problem is we have lost all soft copies of this report, thus unable to retrieve the underlying SQL. When I open the BCA console I can see the document on the queue but I...

I have a slight problem with a report The report comprises 3 dimensions and 3 measures, 2 of which (Serious and Non-Serious)are derived from other values in the report. Country State Town Total Serious Non-Serious USA NY NYC 6 6 6 The problem i have is the count for serious/non-serious...

I have got a requirement from my users that after refreshing a report if a particular column(s) has no data, they want this column hidden , i.e not to be displayed in the report. Can anyone suggest how this can be done please? Thanks

Can anyone tell me if there is a way that I can force a LOV to be displayed in numerical order, either ascending or descending?

Can anyone tell me how to hide a result object within a webi document?