Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the meaning of aggregation and rollup aggregation?
Difference between layout calculation and query calculation?
How do you hide the rows that have null values?
why we use query studio? what is the use of query studio
compared to report studio?

Answers were Sorted based on User's Feedback



what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

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

Is This Answer Correct ?    17 Yes 0 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

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.

Is This Answer Correct ?    10 Yes 3 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

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.

Is This Answer Correct ?    6 Yes 3 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / sri

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

Rgds,
Sri

Is This Answer Correct ?    2 Yes 1 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / upendra raju

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

Is This Answer Correct ?    7 Yes 8 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

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

Is This Answer Correct ?    4 Yes 5 No

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation an..

Answer / sp323

TO HIDE COLUMNS WE CAN USE RENDER VARIABLE TOO.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Cognos Interview Questions

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

0 Answers  


i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

0 Answers  


how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

2 Answers   TCS, Tech Mahindra,


what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

2 Answers   HCL,


What is Metrics designer?

0 Answers  


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  


What is the basic relationship between measures and dimensions in transformer modelling

5 Answers  


What do you mean by drill across?

0 Answers  


------------- How to identify the Revenue Column in Report?

0 Answers  


What is main difference mapplets and mapping?

0 Answers  


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,


i would like enter some empty space after every 3 rows how is it possible....?

1 Answers   IBM,


Categories