Search results for query: *

You're half way there by naming the data source columns the same. Now you just need a dimension (level) that uses trade id as it's source. Transformer associates like-named columns. Hope this helps

I'm migrating a v6.x installation to Series 7. Series 7 IWR appears to be much improved from v6. Publishing reports is easier with no need to "Shuttle" reports before publishing. The online portal is now integrated with Cognos Upfront (same portal PowerPlay uses). Most deployment...

Preston, I strongly urge you to enter production with Series 7 instead of migrating a v6 environment to 7. I am struggling with this right now. Series 7 has a configuration manager feature that will help you control the configuration of the server products (PPES, IWR, Upfront). You can also...

In Impromptu, before you open the catalog, select Tools--> Options. Uncheck "Retrieve database tables when editing catalog tables" Open the catalog. Select Catalog-->Tables. There will now be a "Retrieve Tables" button below the Database Tables listbox. Click the button...

I would use a standard convention for naming the exported Excel sheets (e.g. report01.xls, report02.xls, etc). Then write a little macro routine that would take the base name (report) and loop through all of the exported reports, adding them to an Excel workbook with Excel automation. HTH, Justin

I would create a database view using this SQL you describe and add it to the catalog. -Justin

The second format is much easier to get. Group ITEM# and CUST NAME in Report-->Query-->Group Tab. Leave HISTORY LOG ungrouped and unassociated. This will basically hide the duplicate ITEM#s and CUST NAMES in the list frame. Justin

This is a difficult problem because you are asking Impromptu to consolidate multiple rows of data on a single line. If you must get this behaviour, I'd suggest creating a stored procedure that consolidates the records into a calculated field. Then use the Stored Procedure report template in...

This depends on how you set up your catalog. If you create a user class for each user and then set the database login to the associated user's database login, then the database will know who the user is and will enforce security. If you use a single database login for all user classes then...

Yes, you can include summaries in page footers and headers. After you create the summary field, select Insert-->Data then click anywhere in the footer. Mark for Insertion the summary field. Or you can just drag and drop a field from the list frame into the footer. HTH, Justin

A form frame in the header might do the trick. The form frame lets you break row values out right-to-left or top-to-bottom. Sounds like you need right-to-left and then select the number of fields (rows) you want to appear. The only problem is that you have select the number of rows ahead of...

This macro saves the active report as an Excel file. Create a macro in CognosScript Editor and schedule it to run in Scheduler. You may want to modify this macro to open a specified report instead of relying on the active report to be correct. Sub Main() Dim objImpApp As Object Dim...

You need to have Cognos support to get into this area. If you have support but don't have a loggin, you can call Cognos to get the online support activated.

Does the stored proc have input parameter(s)? I ran into the same thing with a procedure that had an input parameter. The problem had to do with the Impromptu prompt datatype being slightly different than the stored proc parameter data type.

Another thing to check: Bring up the Signons dialog in Transformer. Make sure that you are signing onto the database with the proper username/pwd. Just for clarification, you are opening the IMR on the same machine as you are running transformer, right? HTH, Justin

Try to open and run the Impromptu IMR that is the parent of the IQD. If you get a connection error there then you need to reconfigure the Cognos database connection. You can do this through Impromptu under Catalog --> Databases. If no error running the report then I'd re-save the IQD from the...

Oh yeah, columns might be helpful... Add this line after the DataSourceAdd command: CreateColumns "New IQD" The MDL reference material should be installed with Transformer (it's under Cognos BI --> Documentation --> PowerPlay --> Complementary Material) Good luck!

Cognos has a "Macro Cookbook" on the support section of their site. You can download from the Impromptu 5 documentation area. try this URL: http://support.cognos.com/supported/support/support_library/impromptu/imp50doc.html Justin

We integrate our Cognos Enterprise services two ways: 1) There is a link directly from our internal corporate site to our cognos server (http://ourservername/cognos). 2) We create a supporting site on the IIS server that hosts cognos enterprise. This site contains training materials, news...

We've had a lot of success using MDL files over OLE/ActiveX automation with Transformer. I was sceptical at first but MDL ends up being *much* simpler and more reliable. You don't need another exe or script to execute MDL (because Transformer interpretes the commands for you). Any existing...