How to create a IQD in Cognos? Which is tool Used?

sreenivasulu pokuru

• Aug 5th, 2013

IQD is nothing but IMPROMPTU QUERY DEFINITION.It contains sql query instead of data. IQD can able to create in two ways. 1)By using Impromptu version. 2)By using "EXTERNALIZED METHOD" property in Fr...

sravan.job

 Profile Answers by sravan.job Questions by sravan.job

• Dec 25th, 2010

IQD is an SQL statement which is generated by Impromptu

Answer Question  Select Best Answer

Sandy

• Sep 24th, 2013

Different aggregate functions are used to perform different operations on the column of the table. Aggregate functions are MAX,MIN,SUM,AVG and COUNT. It makes the calculation more easier.

Prakatta

 Profile Answers by Prakatta Questions by Prakatta

• Mar 21st, 2013

Aggregate Function specifies what type of aggregation to be applied on a data item like Total ,Average, Min etc., The roll-up aggregation of any item is important only when you create the aggregatio...

Answer Question  Select Best Answer

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

Dashboard may be simple or complex depending upon the interactivity it has. It is the collection of may reports....

SUDHEER

• Jul 26th, 2012

In simple understandle way ,dashboard is a ,to view number of reports in a single page.

Answer Question  Select Best Answer

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

1.Choose Run with Options 2.Click on advanced options link3.Click run in the background (Now) 4.Change Format option to desired Option (Excel, PDF, HTML, CSV, etc.) 5.Select Delivery Option of Send th...

Joe

• Mar 13th, 2013

Cognos connection

Answer Question  Select Best Answer

Hi All,
There is a scenario.There should be one prompt page having choice to choose between:
->List
->Cross tab
According to the choice selected, the page generates either List or Cross tab.
Please suggest the solution with steps.
Thanks

Samir

• Nov 19th, 2013

1. Create the List and Cross tab reports with required data. 2. Drag and drop a value prompt to the prompt page. 3. Name the parameter as selection, then click on finish. 4. High light the value promp...

santosh

• Oct 9th, 2013

In your first page Drop your list and CrossTab Insertable objects fill ur data in those. Then create a Prompt page where in drop Value Prompt Object with paramter1 just click finish In the properties...

Answer Question  Select Best Answer

Tejas Bi helpdesk

• Feb 5th, 2014

I am working with cognos10. Too much user Friendly GUI.

Bipin

• Oct 9th, 2011

Cognos Impromptu 6.0, Cognos Impromptu 7, Report net 1.1,Cognos 8.0, Cognos 8.1, Cognos 8.2, Cognos 8.3, 8.4 and latest is cognos 10

Answer Question  Select Best Answer

There is a scenario: Display the list data in the order-first even position rows and then odd position rows.....Can anyone help on this issue..

Soumyadeb Halder

• Feb 17th, 2014

Suppose your table is "employee" and column name is "empid" . Now you want a list which contains EVEN empids first and then ODD empids. Your query will be like below, Select empid from employee orde...

Gajendra kumar

• Nov 28th, 2013

First check based on which column the odd and even value should come. For example in a list EVEN EMP_ID should display first and than ODD EMP_ID. Now drag this column to query subject. Create an...

Answer Question  Select Best Answer

nikhil

• Feb 19th, 2014

We can do this by making single query for both the reports.assign both crosstab to single query

Answer Question  Select Best Answer

Internally what will happen in cognos if we run a report in report studio

Jay

• May 10th, 2014

Once the user runs the report, 1.The request is passed to the Web Server and gateways (CGI, ISAPI). The Cognos Gateway applies encryption to the information received, adds necessary environment vari...

Raghavendra

• Mar 13th, 2014

It will goto content store database to get metadata of required columns and data from specific database.

Answer Question  Select Best Answer

I have three report filter parameters. They will appear as render variables in a .pdf COGNOS report output as if they were simple text fields serving as report header text. These same three items will not appear if you run the COGNOS report output to a Microsoft XL file. How can I program the report (whether using a render variable or not) to make these parameters appear, not as column headings...

Sandeep

• Jun 4th, 2014

You can use tables and put one parameter in each record.

Did you mean this?

Answer Question  Select Best Answer

If you have a report with list and cross tab in the same page. How do yourestrict one user can see only the list and the other user can see both?

Sandeep

• Jun 4th, 2014

You can use the function CSV IdentityName (or something similar). This will return the details of the user.
Use this to check the current user, and base your conditional blocks on this.

Smita

• Apr 4th, 2014

You have to create a variable to check which user is logged in uning the session parameter (eg. account.defaultName) and then assign this variable to either conditional block or use it as render variable for the Cross tab.

Answer Question  Select Best Answer

I have a drill down report that has three parameters passed to it. When the report runs, it can be exported to a .pdf file with those three parameters displayed as text on the top of the first page. They are not column headers, just parameters that are passed to the drill down report. I would like to display them in a Microsoft XL spreadsheet as merely text items in a row of their own, but cannot...

Anamika Jain

• Jun 27th, 2014

You would like to display the information of the parameter you have selected by using paramdisplay() value function etc.

Answer Question  Select Best Answer

I want report that display student who are Withdrawn from (all) courses in specific academic period and his registration status are registered but the student course column display even if he has at least one Withdrawn course since there is no loop in Cognos how can I restrict it only if the student withdrawn from all courses

thank you

Buchi Reddy

• Jul 18th, 2014

1. Take one data item with the expression of (Count of Subjects) for Student

2. case when (Count of Subjects) for Student =0 then student end

Answer Question  Select Best Answer

Try to answer it

Abhishek

• Aug 22nd, 2014

There are 3 layers 1. Database Layer - Tables are imported in this layer. 2. Model View Layer - All the relationships, renaming of query subjects and query items, resolving loops etc are done in thi...

Bhaskar reddy tamatam

• Jul 23rd, 2014

In cognos three types of layers are there

1.physical layer
2.business layer
3.presentation layer

Answer Question  Select Best Answer

bhaskar jha

• Nov 8th, 2014

List report show the data in row and column(detail information of report).
crosstab report show the data in grids, dimensions in row and column and measures in cells or in intersection point.

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

List can be converted to Cross tab but Cross tab cant be converted to list...There is no direct option available in Report Studio to convert the cross tab to list....

Answer Question  Select Best Answer

What are the complexities faced in your Project?

Jay

• Nov 21st, 2014

Performance issues plays a major role , some reports take a lot of execution time due to the huge amount of data retrieval

nikhil

• Feb 18th, 2014

1)sometimes Understanding the requirement will not be clear as per the business 2)you develop one code by understanding one requirement but from onsite(client) again they will tell u the changes to ...

Answer Question  Select Best Answer

How to identify duplicate values in a report?

Vijay

• Apr 15th, 2015

Run the report in excel format. select the entire worksheet and it will list the count of rows.
Now in excel u can navigate to data - data tools - remove duplicate. Take teh count again.

Answer Question  Select Best Answer

How to perform totals on crosstab,list and chart?

Sarvesh

• Sep 23rd, 2015

Cross-tab: By selecting appropriate column and select summation option.

List: You will have add grouping on the column you wish to have sum and then select the numeric column and select summation option.

Answer Question  Select Best Answer

What are the steps to be taken care to increase the executing of Reports?

Shiv Tripathy

• Dec 14th, 2015

Start by checking if the left outer join which is used for relationships, if can be converted to inner joins..if the L.O.J is that much required then make sure the link which is used to maintain the j...

Madhusudhan Rao.C

• Jan 21st, 2013

Set the report hints,
limit the maximum execution time,
limit the maximum table retrieving,

Answer Question  Select Best Answer

What are the session parameters in Frame work managers, how exactly we use in Report studio?

Sai Nandigam

• Feb 1st, 2016

A session parameter is a variable that is associated with a session. These parameters are the values that provides session properties like the user id, user name, run locale, machine name, and timesta...

CognosT

• Jan 20th, 2016

Session parameters are macros available in either Framework Manager that can be used to dynamically determine and display information about a users session. This can be especially handy for general di...

Answer Question  Select Best Answer