Search results for query: *

Hello ! OK -- I have a set of 6 Parallel jobs that I am now putting together into a SEQUENCE job to control job flow. Here's a description of what I need to do : PJ1 , PJ2, PJ3 can run in parallel, are fed through a Sequencer. PJ4 isnt really a job -- I just need to check the value of a...

On my Transaction Download from the As/400 ODBC connection, I am getting 200 or so extra records than I am expecting – using job parameters as variables in my SQL where clause on the ODBC step. If I HARDCODE the values into the WHERE clause, I get the correct number of transaction records. So...

HEllo. I searched, but couldn't find a thread about this -- On my ODBC input connection, on the COLUMNS tab -- Does it make a difference if the columns are in the correct order ? We had a change to the output table, and the new field happens to NOT be the last field on the table. When...

Another question trying to replicate a process we have in DataManager in Data Stage. (I know I need to stop comparing the 2, but I can’t seem to find any documentation on how to perform the tasks I need in Data Stage and I am more clear in my question if I explain the Data Manager process I am...

Hi I am BRAND NEW to Datastage and am tasked with converting our porcesses from Data Manager to Datastage. >>> In Data Stage, our task is : We are trying to use a table accessed through our ODBC connection to an AS400 system as our input Stream. Our requirement is that the SQL statement...

We are using PPLAY Web and Enterprise SErver Admin version 7.1.341.2 (7.1 MR1) We have several "base" cubes that we build and publish (to refresh the data) everyday. Our users manipulate the cubes and then very often "SAVE AS" to their own Newsbox. Today, all of a sudden, ONE of these base cubes...

I am trying to create an Impromptu Report that uses an Excel Spreadsheet as input. Using v7.1 MR2 on WIN 2003 OS. I defined an ODBC using the Excel driver. I created a logical Database name. In the Excel file, the first row has simple column headings (only 8 columns of data) and is a "named"...

Hello ! We currently have MR1 in our production environment and MR 2 in our test environment. In MR1 -- PPES Server Admin tool, when you go to PROPERTIES of the SERVER level...the first tab is called "GENERAL", the second tab is "SETTINGS". In MR1 - in the SETTINGS tab, there is a section...

Has anyone done this upgrade yet ?? We have been testing MR2 and are just about ready to out it into production. But since it is seems to work just fine, we can't really measure the benefit of upgrading from MR1 to MR2. We just want to be sure we don't make things worse by installing MR2...

When we are in a PPLAY WEB Explorer report, we can "export to PDF" and "Export to CSV" without problems UNTIL we use the "SAVE" icon on the bottom, right of the Cognos Toolbar. If we hit "SAVE", then try to "Export to CSV", we get a blue status bar, then nothing happens. We have tested this...

Can anyone help me ?? I believe I am using Rich Text Format. Here is the exact Script: >>>>>>>>>>>>>>>>>>>>>>>>>>>> Sub Main() Dim objOutlook As Object Dim objOutlookMsg As Object rem ********** send e-mail *********************************************** Set objOutlook =...

I have very unusual situation that I need help with. We have a few IMR reports that we save as Excel with Format and then e-mail to several people who do not have acces to the Cognos tools. We are trying to automate this process by using Cognos Script...which works fine as far as running the...

Hello ! Here is our problem - we have 2 tables - Table A and Table B - which are IDENTICAL except for 2 fields at the end of Table B. What I want to do is COPY the data for all the common fields from Table A into Table B, leaving the 2 extra fields on the Table with a value of NULL or blank...

Please reference the complete error text between <<<<< and >>>> lines below: We are running Impromptu Client v 7.1.339.0 on a WIN 2003 server. This report has been in production for over 2 years under WIN NT on Impromptu v6.0.613. It was upgraded, along with several other reports about in...

We are using Transformer 7.1.320.0-0 on WIN 2003 server against a SQL server 2000 DB. In our model we have an 'ALL FISCAL YEARS' dimension based on a date field with the following information: (FIRST day of week is MONDAY) >YEAR -- Lunar Year; Ranking=10 >QUARTER -- Lunar Quarter; Ranking=20...

We are running Decision Stream 6.5 on a WIN NT machine and it is writing to a SQL server database on a WIN 2003 machine. The job runs 12 DS jobstreams. on jobstream 11, the job appears to just hang. The first 10 steps write to other tables on the same database on the same server as step 11. If I...

We recently upgraded from Cognos whole suite of products Version 6.x to Series 7 Version 2 (v7.1 mr2)on WIN 2003 servers. Where is the setting that lets the administrator change the PP Web Explorer view from the Enhanced Interface to the Dynamic Interface? We cannot find where this is done...

We are in the middle of upgrading to Cognos Series 7 version 2. We are getting an error when opening an Impromptu report -- WIN 2003 OS, SQL server database. ONe catalog, 6 reports, all but one are OK....the one we have a problem with is getting a Segmentation Violation error. We have tried...

Hello ! We are in the process of upgrading from Upfront 6.0 to 7.1 (Series 7 version 2). Our users have expressed SEVERE dislike of having to go through extra clicks to get the same options that exist on the bottom toolbar in V6.0 of PPLAY WEb Explorer. For example, in version 6.0 and also...

Hello ! We are in the process of upgrading our entire Cognos suite of products from v6.x to v7.0 as an interim step of going to series 7 version 2 (or v7.1). In Access Manager, we have about 50 user classes and all of our users are assigned to one of these classes. There are several cubes that...