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

    COGNOS Query and Oracle MAX() function

    Appreciate the feedback, DoubleD, unfortunately, the summary filter as given has no effect on the query. With the filter applied or not, it still displays all of the elec_eff_date's, instead of just the latest (maximum) one. It looks like the filter is not selecting the maximun date for the...
  2. sstengler

    COGNOS Query and Oracle MAX() function

    Ok, tried that, but it kept giving me a syntax error near the MAX function....this was in the Filter expression builder. I don't see anything in Query that indicates "Advanced filter".
  3. sstengler

    COGNOS Query and Oracle MAX() function

    I'm needing to duplicate the use of the Oracle MAX() function in my Cognos Query data sets. We have two tables, EMP and ELECTIONS, where EMP contains the demographic data for a person, and ELECTIONS contains thier benefit elections over time (so, there could be several rows where the person...
  4. sstengler

    Join failure between two converted to char() dates

    Thank you, that was it! However, that introduces another question: the column ia2.action_date_c has already been converted to a char() in the in-line view..why does it need to be converted agian in the WHERE clause in the main SELECT? Anyone? Sam
  5. sstengler

    Join failure between two converted to char() dates

    I have the following SQL (6.5) that apparently doesn't see the join correctly, as it doesn't see matching dates that have been converted to char(). select ia.client_id, ia.issue_number, ia.action_date, convert(varchar(10),ia.action_date,110), ia2.action_date_c, ia2.isscount from issue_activity...
  6. sstengler

    Question about concatenating rows

    Mufasa, Wow....thanks!...this is something I didn't even think of....now, if i can just get the "adding user functions to Cognos" stuff working, I'll be able to solve two problems. Thanks again!
  7. sstengler

    Question about concatenating rows

    I have a reporting system, using 8i as the database. I have been asked to create a report that concatenates some of the data from multiple rows into a single row, as follows Assume two tables with the following data: Table_a case id name address 1 123 J. Blow 111 Daisy Ave 2...
  8. sstengler

    Making an Impromptu sub-report invisible

    Ok I've got a Dashboard report made up of a dozen or so subreports. I have a row of bar charts, all displaying the same data, but for different business domains. The probolme occurs when there is no data for one or more of those domains. I want to hide the resulting very ugly bar graph, and...
  9. sstengler

    Time periods excluding weekends

    Thanks for the info. My apologies, but unless I'm missing something in your reply, this is only a small part of the solution. Neither of these functions would really work by themselves or together to give me the correct number of days with the weekends (if any) subtracted/ignored/removed. The...
  10. sstengler

    Time periods excluding weekends

    I have a requirement for a report that needs to calc a time period in Days (now just simply subtracting the two needed dates). Is there a way to change the calc using the COGNOS Impromptu functions to exclude the weekend days in the total? (i.e., if case took 5 calendar days to complete (Thurs...
  11. sstengler

    Error from Upcront (IWR ) when running prompted report

    Thanks for the info - unfortunately, this doesn't apply. THis machine has been up and running for almost a year, and all the other reports still work. Running the report from Impromptu, and Impserver, are successful, and all run on the same machine as the Upfront server. It just gives the...
  12. sstengler

    Error from Upcront (IWR ) when running prompted report

    I have an Impromptu report that has three promtps that are populated from the database. It runs fine in Impromptu, but, when I publish it and try to run it, I get teh following error: GeTemplate iwr_modifyprompts.utml failed. Reason: The content request 'DescribeNewsItem' has failed. The Cognos...
  13. sstengler

    Date Prompts and Subreports

    Oracle 8i - native Impromptu 7.0.702 select sum(T1.&quot;TOTALCALLS&quot;) &quot;c1&quot; from &quot;UHGDASHBOARD&quot;.&quot;AAC_COG_TELEPHONE_TOTAL_CALLS&quot; T1 where T1.&quot;PERIODDATE&quot;>=TRUNC(SYSDATE ,'MONTH') and T1.&quot;PERIODDATE&quot;<=LAST_DAY(SYSDATE) and...
  14. sstengler

    Date Prompts and Subreports

    Ok, checked the data source column, and it was returning a date-time. so converted it to a date (datetime_to_date(Perioddate), but it still didn't work. The only way I can display the prompt data is to Insert, Prompt variable - that shows the prompt variable name, then the variable...
  15. sstengler

    Date Prompts and Subreports

    When I use this as a filter, (Perioddate >= first-of-month( Main Query.promptdate) and Perioddate <= last-of-month(Main Query.promptdate)) - (where Perioddate is a data source column) I get the following error when I try to look at the SQL: &quot;A general exception has occurred during...
  16. sstengler

    Date Prompts and Subreports

    In the Data tab of the Main Query, i clicked on the Calculated button in the middle to bring up the Calculation Definition screen. In the Expression box I've entered ()actually, piked from the list on the left) the prompt name (ie. ?dateprompt?), and then entered a name in the Name box. Saved it.
  17. sstengler

    Date Prompts and Subreports

    Here's what I need to do: - I have a main report, with several subreports, mostly text. - I want the user to enter a single date prompt (as a date) - I want to then use the date prompts in the subreports, either directly as displayed data (or manipulated as a string, maybe), or as a filter...
  18. sstengler

    COGNOS Upfront

    Hopefully, one of you can answer my question about cubes and Upfront. When I am in a cube in Upfront, and then publish a resulting 'report' (a particualr view of this cube) to another Newsbox, does this cube have a physical existance somewhere on the Cognos Server like it's 'parent' cube...

Part and Inventory Search

Back
Top