Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Anu1284

    Unable to use the two measures( one with aggregate) and the other with

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

    Prompt modification...

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

    Prompt modification...

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

    Prompt modification...

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

    Avoiding Multiple rows in the section total

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

    Avoiding Multiple rows in the section total

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

    Avoiding Multiple rows in the section total

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

    Avoiding Multiple Rows in the Report

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

    Multiple input parameter selection in the report

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

    Avoiding Multiple Rows in the Report

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

    Avoiding Multiple Rows in the Report

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

    Date Format in Report

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

    Date Format in Report

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

    WEBI and BO Full Client Installation on the same server

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

    Excluding Saturdays and Sundays between two dates

    ...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 : =Floor((DaysBetween(<Start Date> ,<End Date>)-<Non Working Days>))
  16. Anu1284

    Excluding Saturdays and Sundays between two dates

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

    @PROMPT OBJECT BEHAVING DIFFERENTLY IN WEBI

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

    Can a prompt value be concatenated in Universe

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

    Need a help with @prompt function

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

    Can a prompt value be concatenated in Universe

    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.

Part and Inventory Search

Back
Top