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.

What you mean by drill across and what is the difference between drill through, drill across?

0 Answers  

What is a dimension?

0 Answers  

Usage of Stored Procedures in Cognos

1 Answers   General Motors GM, TCS,

How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?

5 Answers   CTS,

In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

0 Answers  

What is use of Field Set present in toolbox?

1 Answers  

what is the difference between aggregation and role up aggregation ?

1 Answers   Systime,

In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?

0 Answers   CTS,

Wt is the Diff between Business Key & member caption?

2 Answers