Search results for query: *

I have some files on the AS400 to be copied into SQL-Server, for further massage/ETL. I'm copying an existing DTS package, and everything works except adding fields onto an existing table. I think I'm misunderstanding the 'INSERT...SELECT' functionality. In the AS400 files, there's a date field...

There are 2 tables, a MEMBER with 1.1 million rows, ACTIVITY with 50 million (Yes, I know it's too big; try arguing with corporate execs who overpromise on projects)! The report template needs to pull in an attribute of member.company id (common to both tables), and give the average number of...

I have to find a number of days between a registration & activity, 2 date fields. These date fields are attributes. I'm trying to get the average number of days, for many rows within 1 group. So, the heirarchy is company avg. days between reg. & activity. The 'Apply Simple' formula I keep...

Any way to convert a number field to its binary equivalent (ex. BINARY(15) = 1111, BINARY(13) = 1101 )?

We upgraded from 7.0 to 7.1, uninstalled 7.0 first, then installed and configured 7.1. I created newsboxes and the newsitems (reports), and they run fine, with filtering, as stand-alone, personal reports. However, there are some that need to be bursted. So, I set security, give read access to...

My dept. is migrating from 6.0 to 7.1, so I have to test the reports to ensure no compatibility problems. Part of the test is timing how long the report runs under different user profiles in the catalog. There are some reports that pull in data from 2 tables that have no join, thus a...

Ready to get the audit process going, but need it to run on Oracle, not the built-in Access database. I open the catalog, create a native database connection, then try to switch to the new database in the 'tables' section. It prompts me for the access database userid and password. How can I...

Anyone know a simple way to replace the standard icons that appear next to each newsitem in IWR 7.0? I'm portalizing to the extreme, putting in IWR reports, Powerplay cubes, Word documents, Excel spreads, etc. I have all the .gif files I need loaded in the Upfront images directory. The...

There are times when an error message from a Cognos application is like a call from a telemarketer: it harasses you at the worst time, and is equally unintelligible. In case an error message is useless (i.e. 'logon error connecting to database', when your logon is defined and you're able to...

I get this message when running a Cognos query on a new database. The dba says he must bump up the parameter for PROCESSES initialization parameter. 1) Any formula for estimating how big it should be? 2) what other configuration issues or parameters should be looked at, when rolling out a new...

Impromptu SQL run against fields of this type are 'not supported' by Cognos, which means they will crash the report with a 'dms-e-general' type of error. If you get a strange error on 8i tables, and nothing else appears wrong, examine the table field properties (I use TOAD), and check there are...

It's ridiculous that the generated pdf's to be read thru IWR have those long generated names - like it'd be rocket science to pull the username from the report, it's a one-to-one relationship for each userclass anyway! It's not 'simply an inconvenience since it's invisible to the userr anyway'...

If report prompts are loading too slowly when opening an impromptu report, they may be 'taking the long way home' (from Supertramp-1980). There are 2 things to do about this. 1) avoid report picklists, go with catalog picklists. While report picklists are more flexible and require no database...

Here's the problem: I have a production catalog and database, let's call them PROD. The catalog pulls in tables from the PROD database defined in the databases section. I get projects to parallel develop on another database. So, I copy the PROD catalog, rename the copy to TEST, and point its...

I have a unix box with Oracle 7.3 & 8i loaded under directories /u and /u01. I'm upgrading to 8i, & need to test scripts working on 7.3 on 8i. In a script, there's a line that looks exactly like this: . offline.env right before it calls another script to load tables. There's a file...

Oracle 8i, IWR 7.0 Can someone explain in explicit detail what needs to be done in Access Manager, Report Administrator, and Upfront, to successfully burst to select users? I have a catalog with user profiles, reports off the catalog, on the client they work fine. Publish to IWR intranet, as...

I have a working audit database, collection files written to Oracle 7.2, Impromptu catalog & reports & even a cube running off the audit database, table structure & definition modelled after the Access sample provided with IWR 6.0. We're upgrading to IWR 7.0, and naturally want to continue with...