Search results for query: *

I have created a measure without aggregate 1. Days (Database field / 5) and another measure with aggregate 2. PTO Hours (sum (Database field)). When the measure with aggregate field alone is used in the report, it works well. When the measure with aggregate is used with the measure without...

Sridharan, Where you successfully enough in digging your previous work to find a solution for my question? Please let me know. Thanks, Anu.

Hi Steve, Can you please let me know if it is good practice to check the "Do not regenerate SQL" checkbox. Also please let me know the dis-advantages of using this? Thanks, Anu.

I have 2 input date parameters, Start date and end date. My requirement is to retrieve all records where (database date field + 7) is between start date and end date. (input date parameters) Is this possible to achieve without creating an object in the universe as this condition will be...

Blom, The whole table where report output is displayed is under Division (Section 2). In the outline view, when I move the Department (Section 1) total from Section 2 to Section 1, the column displays a computation error. How do I retain the totals? Thanks, Anu

Shoot, The data is an a table. The department total is under the division section. I am not able to drag and drop the deparment total in the table to the department section. How do I drag a row in a table from one section to another? Is there any alternate way? Sridharan, The report display...

Hi, I have two sections incorporated in my report. One section for Department and the other section for Division. My input parameter is Department. Based on the department, various divisions will be displayed. Each division will have multiple levels. Each level will have several employees...

Hi Sridharan, Based on your suggestion, I made the corresponding change. I also need to get the total for each employee as below: EmplID Sch Incidents Unsch Incidents 1 2 1 Total of 1 2 1 2 1...

Hi, My requirement is to run a report through 2 input parameters. Parameter 1: Begin Date Parameter 2: Either Department ID or Dept Level 2 ID. I'm working on BO full client ver 5.1.7. When I try to run the report given this condition, I get the input parameters dialog box. If I enter...

Hi Sridharan, My requirement is to create the same in the report level. I have similiar conditions for hours and days also. Hence there will be a total of 6 extra objects in the designer. This is going to be an overhead as far as maintenance to the universe is concerned. Could you...

Hi, I'm facing an issue in BO reports. My requirement is: For each employee, based on scheduled field (in the database), I need the count of scheduled incidents and un-scheduled incidents. For ex: Values in the Database for Absence Table EmplID SCheduled 1 Y 1...

I understand that list of values would resolve this to a greater extent. A scenario that restricts using LOV: Assume Absence Begin Date starts from 10 Oct 2003 in the DB. If the user needs to run a report from 01 Jun 2003 to 31 Jun 2003, he should be able to run the report though there will...

Hi, My report requires two input date parameters. Based on the input parameters, the data is retrieved from DB2. I created a report prompt for the 2 input parameters. Please find below the condition: Absence Begin Date between Prompt(Enter the Report Begin Date (mm/dd/yyyy)) and Prompt...

Is it recommended to install both WEBI and BO Full Client on the same server?? Please let me know.

I got that stuff working. If anyone is interested, please find the solution below: Create three variables in the report. Number of Weekends: =Truncate((DayNumberOfWeek(<Start Date>)+DaysBetween(<Start Date> ,<End Date>)) /7 ,0) Non Working Days: = <Number of Weekends>*2 Number of days ...

For the BO report that I need to create, I have two different dates. I need to find the difference between the two dates excluding saturdays and sundays. For example, Date 1: 03-Nov-03 Date 2: 10-Nov-03 The result should be Total Days: 5 (excluding saturdays and sundays). Please let...

I created a filter with @prompt. The syntax is table.field IN @Prompt('Enter ALL for all Departments or select from list','A','Prompts\Department ID',MULTI,FREE) OR 'ALL' IN @Prompt('Enter ALL for all Departments or select from list','A','Prompts\Department ID',MULTI,FREE). But when I try...

The Database is DB2. When I include the filter condition as 1. table.field(date) <= date(@prompt('Enter the Report Year','A',,MONO,FREE) || '12-31'). I get the error as &quot;An unexcepted token <end of statement> is found following &quot;'&quot;. I changed it to the following: 2...

Hey Steve, Thanks for the suggestion. I changed the department prompt to select the values from the table and used the prompt in the filter.

Hi, My requirement is the user will be prompted for a year and based on the year, I need to concatenate it to the last date of the year (i.e., &quot;12/31/&quot; + prompt year) and fetch the corresponding record. Can you please suggest a way to get this done. Thanks, Anu.