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 John Tel 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: johnoha
  • Content: Threads
  • Order by date
  1. johnoha

    Cognos 7.4 Currency Symbols in Cubes

    Hello Can someone please explain how currency symbols are displayed in powerplay. After I build the cubes, and open them in powerplay on the Cognos server they correctly display in Euros. However, when the cubes is opened on another client, currency values show UK Pounds. Is there a setting...
  2. johnoha

    Passing Parameters into a Macro

    Hello Is it possible to pass parameters into a macro from a batch file (.bat) I would like to be able to pass strings such as catalog names, folder names etc. to reduce the number of macros that I need to maintain as these items are currently hard coded within each macro. Thanks
  3. johnoha

    Limit number of Rows Extracted in an IQD

    What is the SQL syntax to limit the number of rows read from the database in an IQD? Can someone please post an example. I want to do this to test that the structure of the cubes look OK before building a cube full of data. Thanks in advance.
  4. johnoha

    Trapping Excel with Format Errors from Within a Macro

    Hi I have a Macro that reads the content of a directory full of *imr's and creates Excel with Format output. The basic process works fine until there is a formatting error. The Macro hangs on this statement.. objImpRep.ExportExcelWithFormat saveExl$ when run interactively, there would...

Part and Inventory Search

Back
Top