Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Cognos Basics!

Cognos Basics!

Cognos Basics!

Hello All,

I'm new to Cognos. I have a few basic doubts.

1. What is the relationship between Impromptu and Transformer. I was told that one could do reports in Impromptu itself then why should we need Transformer and Powerplay.
2. What is the purpose of calculations and conditions in Impromptu.
3. How do i create a Impromptu query definition which can be used in Transformer.
4. Is it possible to give filter(where conditions) for a measure.
5. How do i do a report in Powerplay without a measure(metric) i.e. i want to display just the attributes.

Can someone give / point me to some guide on fundamentals to start with Cognos.

Still lot more to follow. Hope someone help this new kid in a wild jungle.

Million thanks for your responses


RE: Cognos Basics!


I'll take a crack at some of the questions. Anyone else join in.

1) Impromptu is a general reporting tool use to access database information directly. It can report either summary or transactional data. It can also be used to create a SQL-like IQD file used by transformer to retrieve data to be used in a Powerplay cube.

2) Calculations and conditions in Impromptu are used to create calculated columns, data not directly stored in the database. An example might be to look at name prefixes (Mr., Ms, Mrs.) and calculate a column called 'Gender' that was not present in the data. They can also be used in conditional formatting and in the filter expressions.

3) Write your query or report in Impromptu and choose 'Save As' then look for 'Query Definition (IQD)'  third from the bottom of the list of options.

4) Yes. An example might be changing signs on Income Statement measures where the account type is revenue (usually stored as a negative number for positive results).
There are other ways to do this in Transformer as well.

5) I'm not sure I understand this one. One of the fundamentals of an OLAP cube is that there are dimensions (attributes not directly involved in a measurement), and there are measures, usually aggreations of some numeric values in the data. A Powerplay cube without measures would be a different animal for sure.

There are a number of good Powerplay experts that frequent the forum (I'm not one of them), so feel free to post questions as you go forward exploring the product.

Hope this helps,

Dave Griffin

RE: Cognos Basics!

Dave Griffin ,

Thanks very much for your good reply. Regarding my question 5 let me make it clear. Suppose I have created a cube which contains measures and dimension attributes as well. Is it possible to do a report in Powerplay where i don't use the measures instead use only dimensions and display the report (eg. displaying employee details where there is no need for measures to be displayed). Let the created cube contains measures.



RE: Cognos Basics!

Never saw a PowerPlay Report without measures.  Have seen it in Excel though.  Where you use Impromptu linking.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close