Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mjcotter
  • Content: Threads
  • Order by date
  1. mjcotter

    Do you allow users to run Report Studio in PROD?

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

    Return to Source button grayed out after drill-through report

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

    Cognos Common Logon Error!

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

    Drill-through cube to cube

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

    Update 1 table from a 2nd table???

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

    Using VB with PPES or PPADMTOOL?

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

    Saving multiple generations of a cube?

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

    Migrate DB2 database to MySQL?

    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!
  9. mjcotter

    Upfront NewsBox Won't Delete!

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

    Deployment Manager Problem

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

    Date prompts in Impromptu report

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

    Powerplay Cube Different From Web Cube - why???

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

    Netezza database question

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

    Fiscal Year / Transformer

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

    Tech Design Examples?

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

    Quality checking

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

    Max Cube Size???

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

    Impromptu Filters

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

    Impromptu Catalog Password Question

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

    Saving an MDL to PYI ???

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

Part and Inventory Search

Back
Top