Recent content by mjcotter

I agree that all end users should not have Report Studio. Most do not have the need or the knowledge. Not to mention it's too costly! We plan to give a small subset of "power" users Report Studio in Production. Overall, we have probably 300 users and initially there will be less than a dozen...

Hi, I'm curious what people are doing for Report Studio in their Production environments? Management here is very fearful of allowing the end users the ability to use and run Report Studio in Production. The fear is that users can potentially create and run queries that could take down the...

Yes, I did figure it out. Hopefully, this will do the trick for you too... Our Prod server had themes copied over from an old server which had Cognos 7.1 installed. Instead of copying the themes over from the old 7.1 server, I created them from scratch on the new 7.3 server and this did the...

After running a drill-through report, when returning to the cube, the "Return to Source" button in the bottom right-hand corner of the cube is grayed out. This is using PowerPlay Web. We are using 7.3 MR3. Again, this happens only after drilling through to a report. Please help me enable the...

I am getting the following error, specifically when I try to open Access Manager: "Common Logon Error (hex 80070005): Access is denied." This is a Windows 2003 server. We are running Cognos Series 7 version 3 MR3. Points of Interest: (1) I have 3 other servers where I am not getting this...

Thanks JGirl for the suggestion! The user I am logged in as is an administrator, so I should have the appropriate permissions.

I thought I set up everything correctly. We are running Cognos 7.1. This is our first foray into cube-to-cube drill through. We are using cube-to-imr drill through successfully. I get the error: "Could not find the Upfront newsbox specified in the Drill Through to Newsbox using current...

Thanks ddiamond! Your SQL statement worked perfectly. DB2 had no problem with the from clause in the update statement. Also, that was a good heads up about the exists clause. I definitely needed it b/c the table I was updating had records that did not exist on the other table. Thanks...

I have a column on 1 table (entry_filed_dte column) that I need to update with values from the entry_filed_dte column on a second table. The following SQL statement did exactly what I wanted it to do in the SQL Server world. However, it does not work in DB2. Can anybody help? Thanks...

Is there a way to use VB to write a program to: (1) add a cube to PPES (2) publish that cube to the web ? I think there might be a way to do it in a DOS batch file using the PPADMTOOL. However, I would like to use VB instead. Has anyone done this before? Maybe have some sample code? I...

Is there a way to save multiple versions/generations of a cube? We have a cube that is a snapshot of data at a given point in time. We would like to save the old version of the cube when the new one is built, so that the users may access it to compare to the new version. Users are accessing...

Yes, it's on the Cognos website. Under SUPPORT SERVICES, go to the UTILITIES link and you will find it there. I believe it requires you to log into the Cognos website.

Hi, Does anyone know of a freeware/shareware tool for migrating a DB2 database to a MySQL database. MySQL has a Migration Toolkit, but it looks like it currently only supports Oracle and Access databases. Thanks!

Hi johnthomaz, I'm not able to get your workaround to work either. :-( I was so hoping it would work too. We have no plans to upgrade PPES to either 7.3 or the fix that Cognos has released. There are disagreements over the level of testing that is required. Think making a mountain out of a...

Hi Magesh, You're right - my final goal is to move my complete Upfront environment from 1 server to another. However, I will be moving from a server with Cognos 7.1 installed to a new server with Cognos 7.3 installed. I don't believe I can use the Backup and Recovery Guide steps b/c of the...