sadique_ghitm

 Profile Answers by sadique_ghitm Questions by sadique_ghitm

• Nov 24th, 2011

CAST is a complex function that transforms one or more values from one data type into another. .- >--+-------------------+--+----------------------+--------------> '-CCSID--expression-' '-ENCODIN...

Answer Question  Select Best Answer

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• May 27th, 2012

Framework Manager supports stand-alone filters and embedded filters. Use a stand-alone filter when you want to reuse the expression. You can add a stand-alone filter to one or more dimensions or ...

Answer Question  Select Best Answer

Can someone help me with the question below?
How can we handle Empty reports other than using "No Data Contents" option in Report Studio?

This question was posed to me in an interview.

aba.aguiar

 Profile Answers by aba.aguiar Questions by aba.aguiar

• Feb 1st, 2012

Specify Not to Render a Page If It Does not Contain Data You can specify not to render a report page if the page does not contain any data when the report is run. Steps 1. In the report page, click a ...

Answer Question  Select Best Answer

SHYAM

• Mar 17th, 2012

If we apply filters,prompts,calculations in a report then that is called Complex report.

Answer Question  Select Best Answer

What exactly Cognos 4GL? What are the resources of Cognos 4GL?

sohil

• Mar 23rd, 2013

Cognos 4GL is a 4th generation language by IBM, which is used for reporting in Cognos, but these days it is outdated and not much organisations are using it.

It contains 4 tool:
QTP
QUIZ
QDESIGN
QUICK

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

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

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

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

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

How to Validate Date in cognos report studio (eg start date should be less than end date)

srijib mandal

• Aug 12th, 2018

You can use date range prompt if you need it in prompt page, in filter you can convert to timestamp and then compare

Answer Question  Select Best Answer

Dnyanesh

• Mar 20th, 2006

To create a powerplay report1)You have to create a IQD file from impromptu by saving IMR report as IQD2)Use Frame Work manager model and externalise the query subject you want to use in powerplay tran...

Answer Question  Select Best Answer

Jas

• Apr 9th, 2006

Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main.

Answer Question  Select Best Answer

jyothsna

• May 15th, 2006

PowerplayFrom format menu-->title, header & footer-->title-->insert report filename

Answer Question  Select Best Answer

Raymond Ellis

• Jun 25th, 2006

1 Start Cognos Impromptu Administrator.2.From the File menu select Catalog -> New.3. In the File name text box, type the desired name of the catalog. In the Description text box you can add a descr...

Answer Question  Select Best Answer

ZenOfBI

• Jun 13th, 2006

Steps1. Right-click in the Data Sources list of your model and select Insert Data Source.2. In the New Data Source wizard, enter the name of the data source in the Data Source Name box.3. In the So...

Answer Question  Select Best Answer

Ra79

• May 16th, 2006

You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions)

Answer Question  Select Best Answer

Udeshka

• Jul 30th, 2006

In Cognos 8, you can do it in three stages 1) Package Level 2) Object level 3) Data level Package level Expan the namespace, R click on package > Click on Edit Package Package Access window ...

Answer Question  Select Best Answer

Chakrapani Sharma

• Sep 8th, 2006

1)framework manager2)metric designerboth of above two connects to COGNOS CONNECTION to run, view and manage contents:cognos viewer - view reportscognos office connection - cognos content on MS officem...

Answer Question  Select Best Answer

lax

• Sep 16th, 2006

Hi 3MB size

Answer Question  Select Best Answer