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?

Answer Posted / sowjanya

1. For making Union query Both the input queries should
contain same columns.

2.Aggregation refers to Detail level Aggregation
Roll Up Aggregation is for Summary Level Aggregation

3.By making Box Type property None, we can hide a column. To
see the Hidden objects click on Visual Ads button and check
View Hidden objects

4.Queries can be joined making use of join query. when there
is any null record in the joining column which is to be
fetched then we go for outer joins(1..0)

5.To change the default date selection in the date prompt,
Java script need to be implemented

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1911


What is main advantage datawarehousing over oracle?

784


What is the difference between drill through, drill across?

815


What is a Datastore in Cognos?

1048


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2167


What are initial page components of Cognos connection?

818


What are the considerations regarding performance kept in mind while setting up cognos?

763


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1929


Define query items?

808


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2168


What is zero-foot print?

809


4. How many dimensions did you use in your reports?

1713


What are the advantages of cognos?

759


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

1892


what are the errors faced while bursting the reports and how to solve those errors?

1807