If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Joins at report level

Started by elisha, 18 Oct 2005 11:24:38 PM

Previous topic - Next topic

elisha

How to create and modify Joins at report level in Impromtu ?

dwood09

Joins are usually created in the catalog, not in reports.  You can overwrite the sql within a report, and therfore create any join required, however you will loose most of the report layout functionality that Imprmptu offers.


cognosfreelancer

It is possible to create joins in the report by dragging in appropriate columns into the filter dialog box.

The filter clause will complement the existing join if any that was created at the catalog level. It will not overwrite the existing join.

NKT

Blue

It would appear from your questions that you have not attended any training course for Impromptu Administration. 
I suggest that if your boss have assigned this responsibility to you then he/she MUST provide training for you.
You can get answers to these questions by reading the manuals and I strongly urge you to do this before asking anymore similar questions in these forums.  You can't shortcut your education by replying on other to read the manuals for you.
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand

danimahesh


V cannot use joins at report level.as it is the admin or the creator's work to create the catalog with all the requirement specified to him.