Search results for query: *

You could also use the options provided under the: Format>Background>Printed Watermark.. menu. Here you can add watermark text or a picture etc.

Extra Information: We have feverishly been reviewing our archived logs from the past 12-18 months and have found that this problem began occuring when we upgraded to Version 7.1 The log completes 2 passes and subsequently runs each IQD twice (doubling the time taken to build a cube). 1st...

Thanks for both quick replies. sudhi8645: The command I posted previously is executed on the server by the scheduling tool TNG. Here an excerpt from the log showing the end of the cube build followed by the immediate start of the 2nd run. 04/26/2004 08:23:02 AM 4 00000000 Updating the...

Has anyone else experienced a cube build that when initiated by a DOS batch file, runs through its FULL build process TWICE before completing?? [dazed] Here is the DOS command that we issue against our server machine. c:\program files\cognos\cer3\bin\trnsfrmr.exe -n...

Thanks puppyquestion1, we thought that this 'temp' space could be causing some of the hanging symptoms we are receiving. Still haven't had any helpful response from Oz Cognos support as they believe it is our Lan that is causing the problems. I am not convinced of this, as we still get huge...

Help, Since upgrading to Impromptu version 7.1.116.11 we are experiencing weird %-( performance issues such as: 1) Open Impromptu report, make change and then attempt to use the "Save As" option. Impromptu seems to hold some type of lock on the file and returns an error "You...

We have now resolved this issue and it related to the ppx file specification which was fixed by running the upfadm.exe with the Upgrade command. This takes the Upfront.pkg file created when backing up the Upfront metadata and replaces all references to 'cer2' with 'cer3'. thanks for the...

Pedro (&others), I've since discovered that I am ONLY unable to publish a *.ppx file if it was created linking to a REMOTE cube. A *.ppx report created against a LOCAL cube is fine. What's the real difference between local cubes and remote? We have NO real need to use a REMOTE cube but would...

Pedro, These reports were defintely created against a web/remote cube. I have even created a NEW report against a NEW remote cube and PPES still will NOT publish a *.ppx file. Cognos Australia Support are also confused because we CAN publish a cube to Upfront and ALSO open ANY report and/or...

Fellow Cognos nuts, After upgrading from 7.0 to 7.1 (the next version up from Series 7 initial release) we are experiencing a weird problem where we are NOT able to publish ppx reports to Upfront from the PPES Admin tool. We CAN publish cubes to Upfront. All our settings seem to allow the...

Has anyone come across a way to remove the automatically generated entry in Page variables of Pivot Tables called (All)? We need to remove this so that users don't select this options as it makes the results non-sensical. VBA or other solutions would be greatly appreciated. :)D

This may help. If you are only ever going to have the same number of columns in your pivot then I'd suggest removing the "Sum of Price" altogether from the Pivot. Alongside the Pivot table you should make use of a formula such as this one to disply the price. You can label the...

This may help. Sort your data by the first column (patent number). Then in a new column enter a 1 on the first row. In the second row enter the following formula (assume patent number is in column A): IF(A2=A1,0,1) Copy this formula in each row of the new column down to the last row of...

In your data range simply create a counter column for the variable you need to count such as this: IF(A2=A1,0,1) This will work for all records from row 2 onwards. Simply hard-code row 1 with a 1. A Pivot Table can then simply sum up this column to give a unique count.

I'd agree with Dave's consensus. MR2 supports NDS but Version 2 does NOT. Pedro is going to let us know if he finds information to the contrary. thanks for all the posts gents [2thumbsup] Marcus

Yes, It definitely is Series 7 VERSION 2 that we're upgrading to and NDS is NOT on the media provided. This leads me to think that perhaps Pedro is talking about a different 'version' than me. We've decided to use Sun ONE and hope that it will be supported by Cognos and then we'll change again...

Thanks for that Pedro, I seem to be getting mixed messages from Cognos Support here in Oz. The Cognos website states (by omission) that NDS is no longer supported in MR2 see the link here: http://support.cognos.com/support/products/series71_software_environments.html They have replied...

We're currently using Netscape Directory Server for our security storage and this works fine with Series 7 Version 0. I've read somewhere on this forum that Netscape is no longer supported by Cognos in Series 7 Version 2. Can anyone confirm this and also what is the impact for people like us...

Interesting point JMiller13 about re-installing NDS. Did you lose all your User/User class information when you re-intsalled NDS? We're also staring down the barrel of a possible re-install.

Thanks for the ideas guys! Here are 3 sample records from our DB2 table: DATE FIN_YR CAL_YR MON_LBL 1/1/03 2002-03 2003 2003-Jan 2/1/03 2002-03 2003 2003-Jan ... ... ... ... 1/8/03 2003-04 2003...