Recent content by macrus

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