Search results for query: *

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...

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...

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...

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...

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!

I log into Upfront as Administrator and go to the Personal NewsBox folder. There is a user's NewsBox that still shows up, but the user doesn't exist anymore. The user has been deleted from Access Manager. When I click on the user's NewsBox, I get the following error: Page generation error...

I'm trying to deploy from my Production server using Deployment Manager 7.1. I get the following error when I'm trying to create the package definition file: 1. Upfront Error -00000001: The object of type (NewsBox) with ID (80846ad8e7a011d8a453a8c26f11d2f5) cannot be found. It may have been...

I need to create an Impromptu report. The report will have 3 possible prompts/filters: Prompt1 = Date 1 Prompt2 = Date 2 Prompt3 = Date 3 The users will only use one of the prompts when they run the report. The other 2 prompts will not be used and should not send any values to the retrieval...

I have a cube that I'm having a problem with. I have a Dimension that shows assorted codes. When I view the cube: In the PowerPlay client, from the Dimension Viewer, when I expand the dimension, all of the codes I expect are listed. In Upfront on the web, from the Dimension Viewer, when I...

I'm hoping someone here can help. Doesn't seem to be much info on the web on Netezza... We have a Netezza box and have imported some of our database tables into the Netezza database. Our DBA claims that the Netezza database cannot handle uppercase table names and columns. It needs them in...

Hi, I'm trying to build a Fiscal Year date dimension in Transformer 7.0. The dimension will be based on a field in my DB called CANCEL_DATE. I've been trying to use the date wizard. I select Lunar Period; a 4-5-4 pattern; week begins on Sunday; etc. When the dimension builds, the dates...

Does anybody have any examples of a tech design for Impromptu IMR's and Transformer Models (cubes)? We are building cubes for our customer and they are looking for some documentation as to where ultimately the data in the cube is coming from. I would love to see a format/template you all might...

What are you all using to check the quality of your published cubes and reports? I need a way to give my users some assurances that the cubes and reports I publish each month are good in terms of totals matching up to the database tables, etc. I do not want to have to manually open each cube...

We have a Transformer cube that is greater than 2 GB. Evidently, Cognos cubes cannot be larger than 2 GB. I added an entry to the Trnsfrmr.ini file MultiFileCubeThreshold=10000000 My thought was that this would create 1 .MDC file and multiple .MDP files during the cube build process...

Does anybody know of a way to automate the setting of filters in Impromptu? For example, I have roughly 1600 identical IMR's. The only difference is 1 filter, which is a month sequence. Currently, I am manually opening each IMR and editing the month sequence field in the filter. Is there any...

Is there a way to automate the changing of a Catalog password? Our database passwords change every 30 days. We have DB ID's and passwords hard-coded in our catalogs. I would like to write some sort of script to: 1. Open a catalog 2. Change the password 3. Close the catalog...

I'm trying to write some MDL scripts to open an MDL and save as a PYI. I also want to add in signon info. I would like to string it together to do multiple file saves. However, the below script errors after the first save. I assume b/c the first MDL file is still open. Is there a way to...