Explain with an example

sai

• May 4th, 2016

While defining a drillthrough for certain measure based on the data it is retrieving for we have to pass data item value/parameter value ex: if you have Geo field in row/column you are referring to wh...

Santhosh

• Oct 6th, 2014

Pass Data item means, in a drill through reports if we passing Column values(ex: ?Column_Name?), it is called passing data item value. Pass parameter means, In drill through reports is we passing par...

Answer Question  Select Best Answer

Hi All,
I am using cognos report sudio 8.4. I have got a problem in adding each cell to its next cell data (means running total not addition two cells).

I tried with available report studio functions like running_total, Moving_total. I got errors.

I am automating excel reports into cognos report studio. Converting sum(previous cell + current cell) function in excel...

Ravikiran Vaddi

• Feb 14th, 2016

On field explorer, you find running totals. Right click on it and add running total. Asks to enter name, selection operation as sum. Then you find three sections. Whether to sum the column on each rec...

Answer Question  Select Best Answer

We know that Alias never effects if the parent updates where as Reference will. My question is if suppose I took an Alias shortcut for a Query Subject and linking that with parent and if I took a Reference from that query subject what will be the difference for those in performance.

RemyaG

• Feb 4th, 2016

A regular shortcut (Reference) is nothing but a simple reference to another object. Its a soft link. An Alias shortcut is a copy of an existing object and is treated independantly. It is easier ...

Sai Nandigam

• Feb 1st, 2016

Regular shortcut is as reference to the target object. Alias shortcut is like a copy of the original object with completely independent behavior. Alias shortcut is available only for query subjects an...

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

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

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

In IBM Cognos Viewer properties, I have checked the options Normal mode and Maximize Mode. Still, on running the portlet page, I am not able to view the toolbar. What could be the issue? How to resolve this?

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

What is the problems faced in your project (cognos report studio)will you please send me to mail id

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

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

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

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

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

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 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

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

Hi,

I have a report with several drill through.
I scheduled the report in HTML Output by selecting desired sine on.
When I opened the scheduled HTML Output and click on Drill through it is asking the sine on information again. Is there any way to bypass sine on page and run the drill through child report?

Thank you,
Krishna.

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

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