Answer / x

aggregation is the grouping of data roll-up is the
extension of aggregate caluse.
Query calculation is used for calculated data items and
layout calculation is used for run-time information.we can
supress null values by dataformat
Querystudio is used for simple,ad-hoc reports

Answer / malathi

Layout calculations are used to get the runtime information
into the report for eg: date, no of pages etc.
Query Calculations are used to perform required logic used
in the report for eg: calculation the revenue, sums etc.

Using Qery Studio we create simple and adhoc reports where
as using report studio we create complex and business
reports.

Answer / pooja

Aggregation : How query data aggregates data item at lowest
level of detail.
Rollup : Specifies how query data aggregates group value for
data item.
Hidng rows: by applying filter.

Answer / sri

To hide the rows which has null values use the Zero
suppresion for rows...

Rgds,
Sri

Answer / upendra raju

plz give an answer for this questions.
+91-9885186575

Answer / neelima

you can hide the rows having null values by applying
conditional formatting as when you find null values in rows
make the box type none in the properties

Answer / sp323

TO HIDE COLUMNS WE CAN USE RENDER VARIABLE TOO.

Can you define fan trap?

0 Answers  

Where do you set security levels for users in reports?

5 Answers   HCL,

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,

What are the components of the report studio?

0 Answers  

can we join 2 different queries? One has 10 columns and other has 5+ columns?

2 Answers   IBM,

What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

1 Answers   IBM,

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 Answers  

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

Can we install cognos on windows 7?

4 Answers  

What is Correlated sub-query? Please explain

1 Answers   Target,

what is Cognos Visualizer?

1 Answers