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!

  • Congratulations strongm 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. pwhp67

    Install Cognos8 on Tomcat

    I was told that Tomcat was not supported. Why, I have no idea. But they couldn't give me any suggestions at all. So we ended up just using IIS.
  2. pwhp67

    Force Impromptu to filter on database

    Do you mean that Impromptu formulates a separate query to calculate a total? Oh yeah. Every single time. It doesn't matter how you define the total either. You can do it in the Data tab or you can do a data insert after the report runs and define the total that way. Then you look in the SQL...
  3. pwhp67

    Force Impromptu to filter on database

    This will take you into the "Magic Query" window where you will see what the "true" SQL is... Hey, that's cool! In this window it shows that the SQL is using the date prompts. So why doesn't it show that in the SQL window? Thanks again for that.
  4. pwhp67

    Force Impromptu to filter on database

    Database only in Client/Server Tab gives the error: Cannot execute query. Processing requirements exceed the current Client/Server limits. ========================================================= It won't let me edit the SQL. Because the report has totals it sends two queries; one for the...
  5. pwhp67

    Values not Displaying

    It looks like an outer join was used in Impromptu but not in FM. I'm not using FM or Report Studio yet. Can you see the SQL? If you can, and there isn't an outer join, I would look at the Impromptu SQL.
  6. pwhp67

    Force Impromptu to filter on database

    I noticed that some reports filter a date range in the database while others return a brazillion records and then filter on the PC. For example. If I use: and ( Transaction Date between ?Start Date? and ?End Date? ) No date filter is in the SQL! If I use: and ( Transaction Date >= ?Start...
  7. pwhp67

    New GL Account on Import

    We are going to start bringing GL data into CF and CP via ODBC. The question I have for anyone doing this is: Have you been able to modify the scripts/process to automatically create new accounts in Cognos? Currently when we do the GL Extract if a new account was created in Oracle that we don't...
  8. pwhp67

    Cognos Training

    Thanks. The Metadata Modeling course is being held in April so I will probably take that one. (Part 1 and Part 2) My boss wants me to take Cognos Planning 7.3/8.1 Technical Administration so I might be in that one this month. Thanks again.
  9. pwhp67

    Cognos Training

    Most of the classes seem to be for Finance people or report developers. I'm new to Cognos and our company would like to move from a Finance-Installed Series 7 to an MIS-Installed Cognos 8. I'm the lucky guy who gets to configure the entire enterprise. Can anyone recommend any classes that cover...

Part and Inventory Search

Back
Top