Cognos Interview Questions

1)Open the value prompt query
2)Drag a filter from tool box into detailed filter
3)Write the filter condition like country in (India,Japan,china,- - - - - - - )

that's it

I am sure your table has other high-level data item that you can group cities into like region, district or countries. You can cascade from them to limit your cities.

Two ways to used in dynamic columns in Report Studio

1.Query Calculation
2.DataItem

Mgani, How we can create the column headers dynamically using parameter maps. Here is what I am facing, in the data table we have following columns Id, Fact Period And in a Translation Table I have...

Burst: you can send the data in n no of recipients through emails burst option types is: automatic email addresses ...

Burst is; Sending information to people when the information meets the criteria. i.e Balance to the the financial controller.
Schedule; Time the production of reports.

Create a radio button on the report and set its value Sch, create a filter on the report and set it like that

case when dayofweek is monday then (somedate between (currentdate-2 day)+8:00:00 and current date 4 hrs)
else somedate between (currentdate-1 Day)+8:00:00 and current date + 4 hrs)
end

Since you want data for last one week so put condition on the report to fetch data only for last week.

While creating schedule you can click check boxes for the required days.

let me know if you need any help.

Report Studio is A Professional studio

You have used the conditional block with render variable concept.

It is not Possible any studios in congnos convert to crosstab into list is not possible but list is converted into crosstab its possible. and also list is converted into Repeater table.

there is no option for converting a crosstab to list but we can do this by using cross tab space.....at the designing page it should look like a cross tab only but when u run the report the report wil...

List: Detailed information
Crosstab: Summarized information

List: It shows detailed Information, We can use any data item available.

CrossTab: It Shows summarized information, At least one measure must be included.

Yes

Yes. It is possible

Query subject is nothing but a Table

A query subject is like a select statements which contain certain columns from the database. It is not exactly the replica of the columns in the database so you cannot say it as the database table. It is a view of the database table containing few or all of its columns.

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

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

Cognos connection

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

1) Use static values or list of values in prompts when possible.2) Perform calculations on the database side.3) Limit the number of rows to be displayed at one time when possible.4) Take off the auto...

Generally cube size is 2GB only but if we want to increase the cube size then we need to go to partition scenario. For exp: I am creating one cube with year basis that means that year cube having 2 G...

Use of Prompt in Framework Manager: Filter on query subject - to restrict the rows that are returned by filtering out the unwanted data by creating one or more embedded filters for query subject. pr...

I created value prompt, when I select Few values in prompt these values showing in report header between (,)s.
I need (-) in between two values.
Could you please suggest me.

1. Open the IBM Cognos Configuration
2. Go to Database Access,
Select ContentStore then right click on it then Delete
after that
Select ContentManaget then right click on it then Select New Source->Database->Name:xxxxx -> Type MSSQL Server-> Click OK and give the User Name and Password.

There are many ways to improve database performance. One of them being creating indexes on table columns that are queried the most. Another is create table partitioning. A whole lot else can be accomp...

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

Its simply a collection of reports.Suppose you want some data to be displayed as graph and some you think can be better understood through a pie-chart .In this case you can choose to create a dashboar...

1.Drag a list report 2.Add the query items you need for the list report 3.Add a Query Calculation to the list report and name it as Running total,In the Expression Definition Type in running-count...

Instead of doing this at cognos level, try to do it at SQL level using rownum function. Take the max of mod(rownum,5). then save the rownum value in a ?variable? and then take all the records where rownum>? Variable?

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

Scope is used to join the regular dimensions and measure dimensions to perform multi dimensional analysis such
as drill down and drill up.

relationship is join the two tables (specifies cardinality 1-1,1-n